Forum Discussion
Need Dynamic SQL stored procedure
Hi Team
I have config table below
fact)Transaction is fact table and remaining are dim tables , i want to joijn all of the with fact table and need to get a single table and mapping columns also i mentioned in config table,Now i am taking this config table into lookup activity and reading all the values.
in foreach i have taken copy data activity and used dynamic sql stored proc like below
imported parameters also in stored proc.
Now my question is, if i run it, 5 different tables are forming in destination instead of 1 single table, I want 1 single table as result,is there any dynamic stored proc to addition that using for loop or any help in this.
TIA
3 Replies
Hi sudhav ,
Thanks for using Fabric Community.
Can you please provide me with more information regarding what are you trying to acheive here? What is the stored procedure query used in the source actually doing? What is the destination given for the copy data activity? It would be more helpful if you can provide the screenshots.Thank you
Hi sudhav ,
We haven’t heard from you on the last response and was just checking back to see if you can provide the details asked in the above comment. Please let us know if you have any further queries.
Hi sudhav ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Please let us know if you have any other queries.
