Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Self Join alternative RE: Self Join alternative

  • July 2, 2015 at 10:31 am

    #1809988

    I would need it to show as below

    12015-07-01 07:00:00.000NULLNULL

    22015-07-01 09:00:00.0002015-07-01 09:30:00.0002015-07-01 10:00:00.000

    32015-07-01 06:00:00.0002015-07-01 06:45:00.000NULL

    42015-07-01 04:00:00.0002015-07-01 05:00:00.0002015-07-01 06:00:00.000

    42015-07-01 04:00:00.0002015-07-01 05:00:00.0002015-07-02 06:00:00.000

    Does anyone have any ideas?

    Thanks

    Sam