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
WHERE clause of a SQL as Parameter ?
Moderators: chulett, rschirm, roy
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...
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...