WHERE clause of a SQL as Parameter ?

kaps · Post by **kaps** » Mon Jun 23, 2014 8:33 am

Has anyone used the whole Where clause of a SQL as a PArameter to the job ? What I am finding is that it's not recognizing values within quotes... I am trying to do this so that I can make a job a multi instance job...

Thanks

chulett · Post by **chulett** » Mon Jun 23, 2014 9:28 am

If "not recognizing values" means you are losing the quotes, check here. Otherwise, please explain.

kaps · Post by **kaps** » Mon Jun 23, 2014 1:48 pm

Found the issue. It's weird... When you have part of where clause as parm and part in the sql statement it fails...see below...

Fails with the following:
-------------------------
Select Col1 from Table1
where #Wherecluase# And Cond2

Runs with the following:
--------------------------
Select Col1 from Table1
where #Wherecluase# Cond2

If I move the AND inside the parmatere it runs otherwise it throws unexpected token error...

chulett · Post by **chulett** » Mon Jun 23, 2014 1:55 pm

Not totally surprising. Since the parameter is optional the SQL should be crafted such that it can stand alone if a value is not provided.