>>>I was so used to flip that around in VFP!
>>
>>Hmm, never tried flipping it around in VFP either. BTW, pay attention to other changes I made in your query.
>
>Great, it's working good, and fast. Problem was that originally I had a scan doing the updates in Business objects and posting one by one, and that took too long, so I had to do a direct query to update all at once.
In SQL Server, in 99% of cases you need to implement SET based solution for better performance.
If it's not broken, fix it until it is.
My Blog