[thelist] SQL: Accessing Data in a Stored Procedure

[Anthony Baratta]

 >	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