Viewing 5 posts - 1 through 5 (of 5 total)
Lynn Pettis (6/12/2013)
This arbitrary 3rd column is only for the final sort or does it also impact the select of the rows?Is this query contained in a stored procedure?
Unfortunately no.....it...
June 12, 2013 at 8:50 pm
Lynn Pettis (6/12/2013)
Part of the problem you are having...
June 12, 2013 at 6:09 pm
Hi Lynn,
Firstly, thank you so much for spending the time helping out!
The rewritten queries perform approx the same as my...
June 12, 2013 at 5:09 pm
Ok, I'll modify my original question.
Why does this first query perform so much worse than the second one?
First query:
with doc_index As
(Select ROW_NUMBER() Over (Order By docdate desc, docid asc)...
June 11, 2013 at 6:17 pm
Lynn Pettis (6/11/2013)
June 11, 2013 at 1:07 am
Viewing 5 posts - 1 through 5 (of 5 total)