[thelist] SQL: Accessing Data in a Stored Procedure

[MILLER David R.]

>CREATE PROC spSFDelete
>	@SFFileName nvarchar(255)
>AS
>	DECLARE @SFID int
>	SELECT @SFID = SELECT ID FROM SF WHERE NAME=@SFFileName
>	...
>And it blows up right on that last line.  

Since @SFFileName is character, you need quotes.
SELECT @SFID = SELECT ID FROM SF WHERE NAME='@SFFileName'

Ensure that SELECT ID returns only a single row or it won't work.
HTH

---------------FROM-------------------
David R. Miller
Manager, Computer-Based Testing
Medical Council of Canada
dmiller at mcc.ca
(613) 521-6012
(613) 521-9722 (fax)
-----------------------------------------