Viewing 15 posts - 5,461 through 5,475 (of 13,877 total)
Here's one way. It uses an in-line dates table (thanks, Rob Farley), joins that to your data and finally groups it.
Be sure to set the start and end dates...
July 4, 2017 at 6:13 am
July 4, 2017 at 5:47 am
Does it sometimes work OK, or does it fail every time?
July 3, 2017 at 12:49 pm
July 3, 2017 at 12:25 pm
how to query dynamic values to include only row that match ALL items.
'Select *...
July 3, 2017 at 10:22 am
I see that you have built the package with 64 bit runtime on and...
July 3, 2017 at 10:13 am
July 3, 2017 at 10:06 am
Please note that you have posted in the SQL Server 2016 forum, and that your comment about lag/lead is therefore somewhat puzzling. Why did you not post in the forum...
July 3, 2017 at 7:08 am
June 30, 2017 at 5:58 pm
June 30, 2017 at 11:03 am
June 30, 2017 at 8:25 am
Please take heed of the requests for sample data, in a consumable format (see the link in my signature for details).
And when you provide desired results, make them match...
June 30, 2017 at 7:31 am
June 30, 2017 at 6:54 am
A question about distributed databases. After a migration to SQL2016, we used a DWH...
June 30, 2017 at 6:04 am
Just to clear things up a little. An object variable is used to hold a full result set and this is what drives the number of iterations of the FOREACH...
June 30, 2017 at 5:54 am
Viewing 15 posts - 5,461 through 5,475 (of 13,877 total)