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.

Anonymous's avatar
Anonymous
Not applicable
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Many thanks that works!!!  ''text'' double single quotes.