Viewing 3 posts - 1 through 3 (of 3 total)
Apology for confusion, it is Mark Cowne
April 3, 2020 at 12:05 pm
#3740178
I ran all the queries by setting IO and Time on. Assumption data has 7 rows as used by Jeff.Jeff query is the clear winner
Jeff Query:
Table 'Delete2Columns'. Scan count 1,...
April 2, 2020 at 1:27 pm
#3739990
Hello Jack and Moderator,
I am sharing the following query which I tried and tested without using ROW_NUMBER() on SQL server 2016. Don't you think this is also an efficient way
March 30, 2020 at 11:33 am
#3738906