Assuming dataset2 is required, the following 2 results were found.
AS ReportStartTime FROM... Then add another dataset (using the same data source if you like): -- Oracle 10g: DataSet2 -- a quick dataset following the first (started before the first ends? hope not) SELECT TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS...
(only 1 row returned for a count). The dataset for this is the same as for DataSet1 but just the count is extracted: -- DataSet2: SELECT COUNT(*) AS myCount FROM PersonsTable WHERE (Reference = @GivenRef OR @GivenRef ='') AND (Forenames LIKE...