so you have to do it all in sql server logic? well, then, SQL Experts mount up....
tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 12:40 PM To: CF-Talk Subject: Re: update query That is what I would normally do but it has to be part of a DTS package and will be ran everyday :( Phillip B. www.LoungeRoyale.com www.FillWorks.com ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 11:25 AM Subject: RE: update query > I would do a cfquery of all columns in b. > > then loop through that, for each iteration, update > a with the value of some b query column value. > > make sense? > > tony weeg > uncertified advanced cold fusion developer > tony at navtrak dot net > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 12:21 PM > To: CF-Talk > Subject: OT: update query > > > I have two tables. > > tableA > id > name > region > > tableB > id > name > region > > I need to update tableA's region colum with tableB's region colum. The > region colum has changed for some and not for others. With that said, > does this look right? > > UPDATE > tableA > SET > region = (SELECT region > FROM > tableB WHERE tableB.id = tableA.id) > > > Its been a while since I have done this and I cant remeber the best > way to do it. :| > > Phillip B. > > www.LoungeRoyale.com > www.FillWorks.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
