It is likely that the fastest way (other than recreating the table) to do this update will be with a single update statement, probably update of view (where view is your query).
Bulk bind would certainly be an option though.
Post a proper example and get a proper solution.




Reply With Quote