Home Forums SQL Server 2012 SQL Server 2012 - T-SQL TSQL Script help for new user RE: TSQL Script help for new user

  • July 28, 2014 at 3:38 pm

    #1733035

    select

    MethodDate,

    Method

    from

    @TestData

    where

    Method = 'A'

    UNION ALL

    select top 1

    MethodDate,

    Method

    from

    @TestData

    where

    Method = 'B'

    order by

    MethodDate DESC

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura