topic Re: How to concat sql query with pipeline parameter? in Pipelines

How to concat sql query with pipeline parameter?

Anonymous — Wed, 10 Jul 2024 12:55:30 GMT

@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?

Re: How to concat sql query with pipeline parameter?

NandanHegde — Wed, 10 Jul 2024 13:52:28 GMT

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

Re: How to concat sql query with pipeline parameter?

Anonymous — Thu, 11 Jul 2024 02:34:52 GMT

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.

Re: How to concat sql query with pipeline parameter?

Anonymous — Thu, 11 Jul 2024 05:21:16 GMT

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

Re: How to concat sql query with pipeline parameter?

ManasiL — Thu, 01 Aug 2024 06:36:50 GMT

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?