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.

ManasiL's avatar
ManasiL
Frequent Visitor
2 years ago

I am trying to insert the activity error in a table in fabric datawarehouse. But because of special characters like *, ' I am unable to insert that error message into table. Any solution for this?