Link to home
Create AccountLog in
Avatar of TMPSupport
TMPSupport

asked on

Passing integer value in Multi-value parameter

Hi,

How do I modify my query so I can pass a list of integers? Currently my query clause looks like:

WHERE            c.ContractStatusID IN (@ContractStatusID)

and when i look in sql profiler this is what the procedure look like:

exec ReturnLicensingGeneralReport @ContractStatusTypeID = N'1,2,3'

The data type of the parameter is 'Integer' in SRS and i've tried to make it an int and a varchar in the stored procedure. The error i'm getting in SRS is :Error converting data type nvarchar to int.

Please let me know how I can fix this.

Thanks
Arun
ASKER CERTIFIED SOLUTION
Avatar of Chris McGuigan
Chris McGuigan
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of TMPSupport
TMPSupport

ASKER

Thanks a lot Chris.
I got it working.

=SPLIT(Fields!Material_Price.Value,";").GetValue(Fields!Quantity_Number.Value-1)
ooops.  posted on wrong topic.