Viewing 3 posts - 1 through 3 (of 3 total)
John Mitchell-245523 - Thursday, December 28, 2017 8:43 AMWITH NumberedbyMachine AS (.....John
WITH NumberedbyMachine AS (.....
John
thnx john.This actually worked.WITH NumberedbyMachine AS ( ...
December 28, 2017 at 10:04 am
#1973716
Although you didn't provide any data or ddl, I am guessing it's because you...
December 28, 2017 at 8:21 am
#1973703
You have the cte doing a select 1 so it's only selecting one row...
December 27, 2017 at 5:53 pm
#1973651