Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to concat sql query with pipeline parameter?

@concat("SELECT * FROM [dbo].[MyTable] where SourceSystem ='NAV' and NAV_Mandant='W020' and Entry_No_>",activity('LastRecW020NAV').output)   I'm using a german system. Because the where filter also...
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    One alternative approach is to use double single quotes to escape the single quotes within your string.

    Here is the changed codes that you can have a try.

    @concat("SELECT * FROM [dbo].[MyTable] where SourceSystem =''NAV'' and NAV_Mandant=''W020'' and Entry_No_>", activity('LastRecW020NAV').output)

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

NandanHegde's avatar
NandanHegde
Icon for Super User rankSuper User
2 years ago

Can you please provide the expected SQL otput statement that you are envisioning to be executed in the database meaning Select * from xyz  format.

And also what is your parameter name and a sample value of that.

 

Using that we would help you make it dynamic? There are 2 ways : 1 using conact and other is direct expression