Home Forums SQL Server 2014 Development - SQL Server 2014 Looking to sort two queries by Date, Time RE: Looking to sort two queries by Date, Time

  • January 30, 2018 at 9:31 am

    #1977888

    Steve Jones - SSC Editor - Tuesday, January 30, 2018 8:58 AM

    I assume you mean that you want to UNION these two queries. The columns need to be the same number and data types must be compatible: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql

    In terms of sorting, what is the issue?

    Sorting by DateTime and Exception_DateTime

    So if the 1st query returns a value on 1-29-2018 @ 8:00AM and then the 2nd query returns a value @ 8:02AM and then back to the 1st and so forth...