>>>>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.
Yes, I realized that, when it comes to processing lots of records, either SET or Stored Procedure whereever possible. The business objects are mostly for data entry of limited data etc.
There are situations where you have such complicated business logic that you would not want to do that in a stored procedure, unfortunately.
Christian Isberner
Software Consultant