• SELECT distinct jNMBR, sNMBR FROM #myTable

    WHERE cDate IS NOT NULL