I am getting this error:

A job step received an error at line 83 in a PowerShell script. The corresponding line is 'foreach {'. Correct the script and reschedule the job....

sgmunson (5/27/2015)

---

DBA2015 (5/27/2015)

---

sgmunson (5/26/2015)

---

I suspect that the original poster meant to use FROM in place of WHERE, but given the code, I'm fairly sure that there's a much easier way...

sgmunson (5/26/2015)

---

I suspect that the original poster meant to use FROM in place of WHERE, but given the code, I'm fairly sure that there's a much easier way to code...

Thanks Steve, will give this a go tomorrow!

Basically I am trying to convert the below Select query to an Update query where it updates the field "LightsonLongname" in the CardioStaffClinical using the results from the JOIN query,...

Thank you so much! It works beautifully 🙂

Bump