• First things first. We need some consumable ddl and sample data. I created this for you this time so you can see what I mean.

    if OBJECT_ID('tempdb..#Something') is not null

    drop table #Something

    set dateformat mdy

    create table #Something

    (

    dt1 datetime,

    dt2 datetime,

    dt3 datetime,

    dt4 datetime,

    dt5 datetime

    )

    insert #Something

    select '3/31/2011', '3/30/2011', '4/4/2011', '3/30/2011', '4/4/2011' union all

    select '10/24/2012', '10/23/2012', '10/27/2012', '10/23/2012', '10/27/2012' union all

    select '12/10/2012', '12/8/2012', '12/19/2012', '12/8/2012', '12/19/2012' union all

    select '12/20/2012', '12/8/2012', '12/19/2012', '12/8/2012', '12/19/2012' union all

    select '1/16/2013', '1/14/2013', '1/24/2013', '1/14/2013', '1/24/2013'

    select * from #Something

    So based on your sample data what do you want for desired output? I would like to point out that you do not have any duplicate rows here at all. Can you explain what you mean by that?

    _______________________________________________________________

    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/