Viewing 15 posts - 1,576 through 1,590 (of 4,087 total)
The problem with this approach is that it requires two scans of the base table. Here is an approach that only requires one scan of the table.
[code...
October 19, 2017 at 8:48 am
It's really hard to say without something even remotely concrete to reference, but I think the first thing...
October 17, 2017 at 12:10 pm
October 12, 2017 at 8:07 am
You didn't specify what start and end dates you used. If you don't supply dates, then the parameters will default to NULL and no records will qualify.
You should...
October 10, 2017 at 10:07 am
rosarozina - Monday, October 9, 2017 10:30 AMThere are actually rows within that date range
If there were, then you would...
October 9, 2017 at 11:47 am
Check out the following articles:
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
October 4, 2017 at 11:59 am
Okay. I did a quick test, and my intuition bore out:
Here are the results:Method duration
October 3, 2017 at 1:31 pm
October 3, 2017 at 1:19 pm
Look at the following article which talks about using Windowed Functions to solve FIFO queues. FIFO Queues
Drew
October 3, 2017 at 12:47 pm
September 27, 2017 at 1:53 pm
Viewing 15 posts - 1,576 through 1,590 (of 4,087 total)