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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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