need help resolving error in custom sp

[brainfuelmedia_]

Hello, I've created the following stored procedure: CREATE PROCEDURE SOM_RO_ISVALIDPRJID @strProjectID varchar(32) AS BEGIN DECLARE @intPrjID int SET NOCOUNT ON; @intPrjID = (SELECT COUNT(*) FROM dbo.tbl_projects_main WHERE prj_custom_id = @strProjectID) END IF (@intPrjID = 0) RETURN 0 ELSE RETURN 1 GO I keep getting the error: Incorrect syntax near '@intPrjID' at line 8. The line it is referring to is where I have @intPrjID = (SELECT ...) Ryan

[WoutL]

replace it with: SELECT @intPrjID = COUNT(*) FROM dbo.tbl_projects_main WHERE prj_custom_id = @strProjectID or with Set @intPrjID = (SELECT COUNT(*) FROM dbo.tbl_projects_main WHERE prj_custom_id = @strProjectID)

Wout Louwers

[Krish KP]

along with the two methods specified by Wout Louwers also this can be used SELECT @intPrjID = (SELECT COUNT(*) FROM dbo.tbl_projects_main WHERE prj_custom_id = @strProjectID) (i.e. instead of SET, SELECT can be used.)