Is there any way to pass list of parameter in store procedure .
I have procedure call sp_GetPOinfo
Exce sp_GetPOinfo @POnbr= (List of POs)
Procedure contains
Select * from POHeader where PO Nbr in (@POnbr)
Is there any way to pass list of parameter in store procedure .
I have procedure call sp_GetPOinfo
Exce sp_GetPOinfo @POnbr= (List of POs)
Procedure contains
Select * from POHeader where PO Nbr in (@POnbr)
i dont believe you can pass a list.
The best you can do is to pass a string that has delimited data. Like XML or comma, etc.
Even if you could pass an array or some other type of list, the IN() operation can't use it.