I have a SQL stored procedure to get asset details with input of two List Values (Exec get asset details 'L1,L2'.where L1 and L2 contains concatenated values like L1=100,101,... and L2 = 1001,1002...) When I use SQL creator I am getting the correct results as similar to MS SQL Server Management studio.(But I used hard coded List Values ) and outputs asset details along with L1,L2 values but I am not able to pass the List values in the same workspace for SQL creator as list values derived from the another system using Http Caller.However these same List values used in SQL Executor in the same workspace runs outputs asset details along with only L1 values but not with L2 values. Please suggest me.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
@ragh can you include a simplified version of your stored procedure or the workspace so community members can see your workflow?