Home Forums SQL Server 2008 SQL Server Newbies Abbreviated SELECT FROM output RE: Abbreviated SELECT FROM output

  • August 28, 2014 at 12:44 pm

    #1741725

    SELECT distinct jNMBR, sNMBR FROM #myTable

    except (select jNMBR, sNMBR from #myTable where cDate is null)