Stored Procedure Parameter

[rvr707]

Please help me with my sproc. I have this code:

ALTER PROCEDURE [dbo].[Sales by CustSummary]
	@code varchar(500),
	@fromdate date,
	@todate date	
AS
BEGIN
	SET NOCOUNT ON;

	SELECT [Sales].[TransDate],[Sales].[StoreCode],[Branch].[Description],
	[Sales].[Product ID], [Sales].[Units],[Sales].[Price]
	FROM [Sales],[ Branch]

	WHERE 	[Sales].[StoreCode]=[Branch].[StoreCode]
	and [Sales].[StoreCode] in (@code)
	and [TransDate] between @fromdate and @todate
END

But then nothing is retrieved. I have read in an article that this is not the right way to pass @code with IN. But I don't know how to correct this.

@code has multiple items thats why i cant use =(equals) or assign.

I hope you can help me. Thnx!

[WingedPanther]

Try this (untested):

ALTER PROCEDURE [dbo].[Sales by CustSummary]
	(@code varchar(500),
	@fromdate date,
	@todate date	)
AS
BEGIN
	SET NOCOUNT ON;

	SELECT [Sales].[TransDate],[Sales].[StoreCode],[Branch].[Description],
	[Sales].[Product ID], [Sales].[Units],[Sales].[Price]
	FROM [Sales],[ Branch]

	WHERE 	[Sales].[StoreCode]=[Branch].[StoreCode]
	and [Sales].[StoreCode] in (@code)
	and [TransDate] between @fromdate and @todate
END

[rvr707]

its not valid in ms sql server declaration...