• You haven't received much response because your question is so vague. I think this may be what you are looking for.

    Notice how I provided a table and sample data. This is something you should do in the future.

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

    drop table #Something

    create table #Something

    (

    Div_Time datetime,

    Unit_id varchar(25),

    Filled_time datetime

    )

    insert #Something

    select '1/1/2013 01:00', 'Machine5', '1/1/2013 12:10' union all

    select '1/1/2013 01:00', 'Machine5', '1/1/2013 12:15' union all

    select '1/1/2013 01:15', 'Machine7', '1/1/2013 12:19' union all

    select '1/1/2013 01:15', 'Machine7', '1/1/2013 12:19'

    select distinct s1.Div_time, s1.Unit_id

    from #Something s1

    join #Something s2 on s1.Div_Time = s2.Div_Time and s1.Filled_time <> s2.Filled_time

    _______________________________________________________________

    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/