Multiple Options Issue

Hi,

The variable @Item can contain multiple values separated by a comma.
e.g. ItemA, ItemB

But the STORED PROCEDURE query sees it as one string instead of 2 separate ones.

How do I solve this?
Thanks.




Code SnippetWHILE(@StartDate < @EndDate)
BEGIN
IF LEFT(DATENAME(dw,@StartDate),3) NOT IN ('SAT','SUN')
INSERT INTO @temp(myDate) VALUES(@StartDate);
SET @StartDate = DATEADD(d,1,@StartDate);
END





Code SnippetSELECT LEFT(DATENAME(dw, te.myDate), 3) + ' ' + CONVERT(char(11), te.myDate, 106) AS 'NewsDate'
FROM @temp AS te
LEFT OUTER JOIN
NewsItemTable AS t
ON t.NewsDate = te.myDate
AND t.Item IN(@Item)
WHERE t.NewsDate IS NULL