SQL Server - passing a string paramether to a Stored Proc
Posted on 2009-07-11
I pass a string as a parameter to a stored procedure that should get results but does not.. My SP looks like this
ALTER PROCEDURE [dbo].[spMySP]
SELECT dayofWeek, anotherItem
where cast(month(dayofWeek) as nvarchar(20)) in (@items)
I get no results regardless of what I pass as a parameter. For example if i pass '1,2,3' as a parameter, i get nothing. What the heck have i done wrong?