Open query - incorrect syntax next to passed in variable

Asked Feb 09 '17 at 03:04

Active Feb 09 '17 at 03:04

Viewed 263 times

I'm running this query

      SET @Qry = ' SELECT [MLSTQT] INTO ##DISPENSED_LOCATION' 
              +' FROM OPENQUERY(MA,''SELECT MLSTQT FROM ES3.MD.MOC   WHERE MLWHSL='''+    @ProcessOrder+''' '')'
        EXEC (@Qry)

And I'm getting an error saying that there is incorrect syntax next to the value @ProcessOrder.

What's wrong with my query?

Seems it would be WHERE MLWHSL='10000' which is correct.

asked Feb 09 '17 at 03:04

Jack Reilly

1

apostrophe inception.... Use this: `MLWHSL=''''+ @ProcessOrder+'''''')'` – cha Feb 09 '17 at 03:06
Thank you Cha! That worked! – Jack Reilly Feb 09 '17 at 03:50
2

a small advice from me: Use `PRINT @Qry` to see what is getting passed to the `EXEC` function if you encounter these problems in future – cha Feb 09 '17 at 03:53
Thanks that's actually really useful, I didn't think of that. Thanks Cha. – Jack Reilly Feb 09 '17 at 04:04

Open query - incorrect syntax next to passed in variable

0 Answers0