Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Difference between ROW_NUMBER() and ORDER BY...DESC

    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...

  • RE: Job Schedules

    iain.jacob 29849 (11/10/2015)


    There is always another way...

    WHERE js.next_run_date = cast(convert(varchar(8),GETDATE(),112) as int);

    yep, and personally I find this more readable

Viewing 2 posts - 1 through 2 (of 2 total)