[thelist] SQL: Accessing Data in a Stored Procedure
Anthony Baratta
Tony at IdeaSystems.com
Mon Dec 4 17:03:50 CST 2000
> SELECT @SFID = SELECT ID FROM SF WHERE NAME=@SFFileName
Try nesting your Selects....I'm not the SQL guru - but here's my attempt:
DELETE FROM TABLE2 WHERE IDNUMBER IN (SELECT IDNUMBER FRoM TABLE1 WHERE
NAME=@SFFileName)
DELETE FROM TABLE1 WHERE NAME=@SFFileName
Hope that helps, or at least does not hurt.
----
Anthony Baratta
President
Keyboard Jockeys
More information about the thelist
mailing list