How to concat sql query with pipeline parameter?

[MartinGeschke]

@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 need to be Sting in ''  quotation marks it dosn't work.

Is there a alternative text qualifier?

[ManasiL]

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?

[v-yilong-msft · Accepted solution]

Hi @MartinGeschke ,

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.

[MartinGeschke]

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

[NandanHegde]

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