By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE user_case_answer
(userid bigint,
pvisitid bigint);
INSERT INTO user_case_answer
(userid,
pvisitid)
VALUES (26, 5);
1 rows affected
CREATE PROCEDURE [dbo].[SP_User_Case_Answer_Found]
@userID BIGINT,
@visitID BIGINT
AS
return (SELECT count (*)
FROM User_Case_Answer
WHERE userID = @userID
AND pvisitID = @visitID)
DECLARE @return_value int
EXEC @return_value = [dbo].[SP_User_Case_Answer_Found]
@userID = 26,
@visitID = 5
SELECT 'Return Value' = @return_value
| Return Value |
|---|
| 1 |