Share
ReportHow to pass a list variable as parameter from PAD to SQL stored procedure?
Categories:
You’re offline. This is a read only version of the page.
Hello @Deepthi_Nair
Does that mean you want to use the values stored in the list type variable as parameters for stored procedures?
Such like this:
EXEC [dbo].[uspGetWhereUsedProductID]
@StartProductID = %Parameters[0]%,
@CheckDate = N'%Parameters[1]%'
Or does that mean you want to pass multiple values stored in a list variable together to the single parameter of the stored procedure?
You can use action "Join text" to convert the values of a list variable into a single string separated by a symbol, such as a comma.
Thank you.
All responses (
Answers (
355
