CREATE PROCEDURE [dbo].[AdvancedSearch_SELECT]
(
@From INT,
@To INT,
@Source NVARCHAR(300)
)
AS
SELECT DISTINCT
Comp_ID AS CompID,
Comp_Name AS CompName,
FROM TBL_Company WHERE
(Weekly BETWEEN @From AND @To)
AND DataSource IN (@Source)
ORDER BY Comp_Name
I want to execute my stored procedure like below but its not working
EXEC @return_value = [dbo].[AdvancedSearch_SELECT]
@SMFrom = 0,
@SMTo = 100,
@Source = N'''CB'',''INC'''
Can anyone help me how to pass values to @Source parameters