Hello LinksUp - thanks very much, that seems to be working well!

Well it would seem I thought this code was working. But what is happening is that after it runs, the update occurs. But the change isn't permanent. Some time later,...

Wow Jeff thank you so much for all your valuable insight! I had started with something a little more like this as far as assigning a shortened value to...

Hi Jeff! That's very generous of you. I would love to have you take a look. I only tested this against one record so definitely interested in bad structure...

Please disregard, I think I solved my own problem using the below at the beginning of my update/set area. Thanks!

update work_summary

set work_summary.wrks_submitted='Y'

FROM employee, work_summary, pay_group

Thanks everyone for your help. It was all very helpful and much appreciated. No refunds needed 😉

That worked! Actually I had something like that earlier but didn't realize I still needed the =0 at the end.

Thank you so much both of you, I can't tell...

Thanks Jacob! Here is the whole statement below. This statement throws an error, but if I end it with just "WD.WRKD_WORK_DATE BETWEEN DATEADD(DD, -16, GETDATE()) AND GETDATE()) = 0"...

Hi Alvin - thanks very much. I will try your alternate suggestion as for some reason correcting parens still is throwing an invalid statement failure.

Cheers!

Well I'm such a newbie I thought SSCertifiable was your screen name. Sorry Phil LOL. And thanks again.

Thank you so much SSCertifiable!!!!! That worked 😀