Possible Duplicate:
T-SQL stored procedure that accepts multiple Id values
how to add Multiple values for a single parameter while using 'in' Operator in SQL Server 'Stored Procedure'
for example:
create procedure ProcEmployee ( @DeptID int )
as
begin
select* from employee where **DeptID in (@DeptID)**
end
from the above example, i need to pass multiple values for the parameter '@DeptID'