Skip to content

Instantly share code, notes, and snippets.

@daniel-woods

daniel-woods/cursor.sql

Created December 1, 2015 12:41
Show Gist options
  • Save daniel-woods/10e65c1baf25bb892a62 to your computer and use it in GitHub Desktop.
Save daniel-woods/10e65c1baf25bb892a62 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cursor.sql
DECLARE
CURSOR retUnassigned IS
SELECT FaultSheet.fault_no FROM FAULTSHEET
FULL OUTER JOIN Repairs ON FaultSheet.fault_no=Repairs.fault_no
WHERE FaultSheet.fault_no NOT IN(SELECT fault_no FROM Repairs);
BEGIN
OPEN retUnassigned;
FETCH retUnassigned INTO var1;
--print Var1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment