Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Remove duplicates in result set RE: Remove duplicates in result set

  • May 3, 2016 at 6:56 am

    #1876201

    Mac1986 (5/2/2016)

    Thanks a million for differing me to the old thread. I got the answer from there .

    ROW_NUMBER() OVER(PARTITION BY ser.servername ORDER BY ser.servername DESC) AS RowID,

    Just a small note. Your RowID is not guaranteed to assign the row numbers the same way every time. I'm not sure if you could assign a significant way to order the rows.

    Otherwise, I'm glad to have been of some help.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2