On Wed, May 21, 2014 at 12:05 PM, Judah McAuley <[email protected]>wrote:
> It *should* always be able to be done with sets, but it will also depend on > your db and what it supports. > This is all happening on a SQL 2005 machine. Will have to use the script two more times for certain... don't know if I want to publish the capability to folks like sales. Basically we have two types of clients and the system/business rules (internally) do not allow one to be changed without assigning a new code. In most cases this happens at the end of the year and there's no history to worry about. In this circumstance a solution had to be found that would move the client while maintaining all history under the new code. Thanks for the advice folks! Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:370356 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
