Home Forums SQL Server 2008 SQL Server 2008 - General Delete duplicate row based on one column, but need to retain rest of the values in tmp file RE: Delete duplicate row based on one column, but need to retain rest of the values in tmp file

  • December 18, 2013 at 8:21 am

    #1674458

    Gillian_Pappas2002 (12/18/2013)

    My posts look fine in preview then get messed up when I post it. Sorry. I have included an attachment.

    Thanks for all of your help.

    Displaying tabular information is not something html is good at. That is why there are html tables. UGH!!! It is generally best to just create a temp table for your results. It only takes a few more seconds.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/