Home Forums Article Discussions Article Discussions by Author Discuss content posted by rajesh_friends2005 Delete duplicate rows from the table using row_number() RE: Delete duplicate rows from the table using row_number()

  • July 5, 2011 at 1:52 pm

    #1348555

    mtillman-921105 (7/5/2011)

    SanDroid (7/5/2011)

    This was done in a single script, but not a single query.

    The insert into the #temp table is executed as a sperate query.

    You would need to start with the use of a WITH table statement, or a derived table to get this done to a single query.

    Interesting way to resolve a bad table design issue without correcting the bad table design.

    At times you have to work with less than perfect data even if it's no fault of your own.

    Also, in my estimation, the "single query" push is a little overrated. What's the advantage of a single query? Performance can be enhanced in some cases with more than one query. So performance itself can't always be the answer.

    The name of the article compared to it's syntax and content inspired the entire post.

    Please do not confuse my comments on the authors odd word choice in this article as a personal opinion on some subject that was not mentioned.