  Code
SELECT STCD,RZ FROM ST_RSVR_R WHERE (TM IN (SELECT TOP 1000 TM FROM ST_RSVR_R WHERE RZ IS NOT NULL AND W IS NULL ORDER BY STCD,TM)) AND (TM NOT IN (SELECT TOP 0 TM FROM ST_RSVR_R WHERE RZ IS NOT NULL AND W IS NULL ORDER BY STCD,TM)) ORDER BY STCD,TM
|
