Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMSSqlSP Passing Parameter

Hello,
I am trying to pass a simple parameter using component tMSSqlSP.
Here's exactly what I type in the "SP Name"
"usp_UpdateStatus 'PASS'"
Error Message - "Incorrect syntax near ')'
I tested usp_UpdateStatus 'PASS' works, so I am not sure if SP Name takes a different syntax.
Your help is appreciated!
Labels (2)
3 Replies
Anonymous
Not applicable
Author

:cool:
Anonymous
Not applicable
Author

Hello,
Can someone provide me example or screenshot of how to pass parameters to tMSSqlSP?
I have context variables that I would like to pass to, but not sure where to place them when calling the SPROC.
Your help is appreciated!
Anonymous
Not applicable
Author

Hello
I have replied you on 10047.
Best regards
shong