Is it possible to call a stored procedure with multi-valued arguments?

Question

There's a stored procedure I'm studying. Would this be a possible call? -

exec [dbo].[prc_RPT_Respondent_Answer] '20121011', '20121017' , 18964 , "3", "30,31,32,33,34,35,36,37,38,39,130"

I'm guessing the "30,31,32,33,34,35,36,37,38,39,130" argument is handled by code like the following(which is from the referenced sproc:

BEGIN
    INSERT 
    INTO #tempClientLK_ResponseStatuses
    SELECT CONVERT(INT, val) FROM dbo.Split(@ClientResponseRange, ',')  
END

score 1 · Answer 1 · edited May 23 '17 at 12:12

1

you can with below url, it might be helps you to resolved your problem

How to split a comma-separated value to columns

edited May 23 '17 at 12:12

Community

1
1

answered Dec 18 '12 at 07:16

Naresh Pansuriya

2,027
12
15

score 1 · Accepted Answer · answered Dec 18 '12 at 07:35

Yes, this should work. I already have used this approach, few times. If you are asking about how to write that table valued function dbo.Split() then you may check this link-

http://blog.logiclabz.com/sql-server/split-function-in-sql-server-to-break-comma-separated-strings-into-table.aspx

Is it possible to call a stored procedure with multi-valued arguments?

2 Answers2