Viewing 2 posts - 1 through 2 (of 2 total)
Hi frdrckmitchell7,
row_number() is not actually meant to sort the result set. In this case you got lucky and you get the same result.
But try this:
SELECT p.FirstName
,p.LastName
,ROW_NUMBER() OVER(ORDER BY...
August 31, 2016 at 3:01 am
#1898477
iain.jacob 29849 (11/10/2015)There is always another way...WHERE js.next_run_date = cast(convert(varchar(8),GETDATE(),112) as int);
iain.jacob 29849 (11/10/2015)
WHERE js.next_run_date = cast(convert(varchar(8),GETDATE(),112) as int);
yep, and personally I find this more readable
November 10, 2015 at 3:38 am
#1838786