Viewing 15 posts - 241 through 255 (of 1,244 total)
Why would you not assume that?
Given that it's a temp table there's a pretty high likelihood that it's being populated with a distinct set of values, specifically for this...
September 17, 2018 at 1:51 pm
Start by adding a POC index...
September 17, 2018 at 11:54 am
September 17, 2018 at 9:34 am
September 17, 2018 at 8:33 am
In addition to the ROW_NUMBER method offered up by below86, here are two additional methods... One is usually faster than the others depending on existing indexes so all are worth...
September 14, 2018 at 2:12 pm
September 6, 2018 at 1:12 pm
August 29, 2018 at 7:04 am
August 29, 2018 at 7:01 am
August 28, 2018 at 5:07 pm
I think this should be pretty close to what the OP is looking for in terms of results.
If not, it was still a fun little exercise.
Please be sure...
August 28, 2018 at 4:04 pm
August 13, 2018 at 11:24 am
August 8, 2018 at 2:11 pm
Viewing 15 posts - 241 through 255 (of 1,244 total)