Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Pass multiple values in single parameter -Procedure

Home
Forums

Pass multiple values in single parameter -Procedure

Sai Reddy

Sai Reddy

8yAsked Oct 12, 2018, 10:25 PM890

Hi, Please help me to achieve this.

The ID values are as follows.

100

101

102

103

104

105

106

CREATE PROCedure Survey

@id INT

AS

BEGIN

SELECT * FROM SOUTH WHERE Surveyid=@id

end

How to call procedure with two values like as

EXECUTE Survey '100,101'

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

sasi kumar7y ago
Hi,

Please try the below

CREATE PROCedure Survey
@id varchar(max)
AS
BEGIN
declare @qry varchar(max)
set @qry='SELECT * FROM SOUTH WHERE Surveyid in ('+@id+')'
exec(@qry)
end
Jayesh Vaghasiya8y ago
create FUNCTION [dbo].[Split]
(@List varchar(MAX),@SplitOn Nvarchar(5))
RETURNS @RtnValue table
(Id int identity(1,1),Value nvarchar(4000))
AS
BEGIN
Set @List = Replace(@List,'''','')
While (Charindex(@SplitOn,@List)>0)
Begin
Insert Into @RtnValue (value)
Select
Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1)))
Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitOn),len(@List))
End
Insert Into @RtnValue (Value)
Select Value = ltrim(rtrim(@List))
Return
END
CREATE PROCedure [dbo].[Survey]
@id varchar(max)=''
AS
BEGIN
SELECT * FROM SOUTH WHERE Surveyid in (select value from dbo.split(@id,',') )
end
--call sp
--[dbo].[Survey]'100,200,300,400,500,600'
Abhishek Mishra8y ago
Pass it as comma separated string/varchar. Split it in Stored Process and use.