I'm not sure on the average size of the tables really. Currently the etl is a c# app that exports some tables whole and some tables just new entries based...

Hi Steve, thanks for your reply

so would ssis or powershell be able to export direct from the local db to the azure db? (Both technologies I know little about as...

yep, thanks Gila

Thanks Gila and Jack point taken on index consideration.

'2014' was an example, that value's passed by the user.

Jones post - a good example of reading the posts fully before posting...

thanks, they both do the job (minus the select in the second where sql statement)

Hi thanks,

I don't think it will ever be zero but if it is it needs to be treated as if it was a positive

Oh yes, thanks Scott

thanks guys. BWFC's last post does appear to work ok but I'm back on it tomorrow with some big testing so take Chris's posts into account then as well.

cheers

that works for the sample but when I apply it to the working sql I get a problem with the group by

;WITH Main as

(

SELECT

DISTINCT t.transactionID, b.TransDate, b.TransType, b.TransDesc1,...

Actually guys, the old classic, it worked on that specific example but not on the full data set.

So a better example would be using a table with ..

CREATE TABLE #Question...

Brilliant, that works thanks guys.

Just in answer to GilaMonster, the dates/multiple dates passed are always going to be just the month and year and I'm pretty sure there will always be in month order....

sorry I missed rymthnk post. Yep that also works with the sample db, however my actual working sql is (with user variables included)....

WITH Main as

(

SELECT

DISTINCT t.transactionID, b.TransDate,...

thanks BWFC that works but instead of

WHERE q.Description = 'Bob'

I'd want the q.Description to be the description of row number 1 as I can't hard code 'Bob' into the sql...

actually this does the trick surprisingly...

AND t.TransactionDate >= 'Apr 2014' AND t.TransactionDate <= DATEADD(mm,1,'Apr 2014')

BUT if multiple dates were passed through, say Apr 2014, May 2014, June 2014 so I...