Hi
I have a scenario where I want to update a table for records with date column is null
If I use generated query with date as a key column, job doesn't update anything in the table.
I think custom query doesn't accept Date is null and job fails if I use it.
Could any of you please let me know how to handle this situation?
Thanks,
where condition in update statement issue
Moderators: chulett, rschirm, roy
A bit lost. Why don't we start with you posting the generated SQL? If you are passing in a value of NULL to a where clause that says where your "date column" *equals* that passed in value, then yes it will never work.
What database is this?
What database is this?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers