Editing ray

Title / Description

Code
DECLARE @tmp TABLE( nID int ) INSERT INTO @tmp SELECT DISTINCT a.nID FROM tAirportList a, tCSMList b WHERE a.cCode = b.cCode INSERT INTO @tmp SELECT DISTINCT a.nID FROM tAirportList a, tCSMList b WHERE b.cSpokes LIKE '%'+a.cCode+'%' SELECT * FROM tAirportList WHERE nID NOT IN (SELECT DISTINCT nID FROM @tmp)

Author

Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code