Thanks for that chaps, Neither seem to work and still chuck back the same error in query analyser.
Thanks, Rawlins -----Original Message----- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: 23 April 2007 16:43 To: CF-Talk Subject: Re: Bulk Insert try puttind an alias on the sub-select in the where clause eg WHERE DeviceStaging.MacAddress NOT IN ( SELECT ma2.MacAddress FROM MacAddress ma2) On 4/23/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > > Thanks AJ, That's all sorted now. :-D > > Next part of my query is now causing problems (again with no CF error, > Doh!) > I'm trying to move all mac address's that don't currently exists in the > MacAddress table from the DeviceStaging table. > > INSERT INTO MacAddresses (MacAddress, Port) > SELECT DeviceStaging.MacAddress, DeviceStaging.Port > FROM DeviceStaging > WHERE DeviceStaging.MacAddress NOT IN (SELECT MacAddress > FROM MacAddress) > > Any ideas why this won't run? When placing it through query analyzer it > tells me: > > Msg 208, Level 16, State 1, Line 1 > Invalid object name 'DeviceStaging'. > > But I defiantly have a table called DeviceStaging as that's where the > import > happens. > > Thanks, > > Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
