Andy,
You are correct. My oversite in that the dbo was included.
Sorry.
--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887
----- Original Message -----
From: "Andy Ewings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 11:37 AM
Subject: RE: SQL Question - Complex
> I don't think this is right......you only need 2 dots if you don't specify
> an owner.
>
> In fact we are all saying .dbo. but it all depends on who owns the table
in
> the db.
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> ------------------------------------------------------------------
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> ------------------------------------------------------------------
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> ------------------------------------------------------------------
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy, distribute,
or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
> -----Original Message-----
> From: Guy M. Saenger [mailto:[EMAIL PROTECTED]]
> Sent: 01 August 2001 17:28
> To: CF-Talk
> Subject: Re: SQL Question - Complex
>
>
> What Stuart says below is correct. However, you need to separate the
> database name from the table name with 2 dots in TSQL. Therefore,
> it becomes ...
>
> INSERT INTO TableOnDB1 (fields...)
> SELECT fields...
> FROM DB2..dbo.TableOnDB1
>
> --
> Guy M. Saenger
> [EMAIL PROTECTED]
> 214.448.8887
>
> ----- Original Message -----
> From: "Stuart Miller" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 9:19 AM
> Subject: RE: SQL Question - Complex
>
>
> > You want to do a cross database join with an INSERT SELECT query:
> >
> > INSERT INTO TableOnDB1 (fields...)
> > SELECT fileds...
> > FROM DB2.dbo.TableOnDB1
> >
> > The "DB2" in the FROM clause needs to be the name of the database (not
the
> > datasource name).
> >
> > -s
> >
> > Stuart Miller
> > Rocom New Media
> > t: 01937 487492
> > e: [EMAIL PROTECTED]
> > w: http://www.rocom.co.uk
> >
> >
> >
> > -----Original Message-----
> > From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 01, 2001 3:01 PM
> > To: CF-Talk
> > Subject: SQL Question - Complex
> >
> >
> > Does anyone know if it is possible to pull from two different databases
in
> a
> > stored procedure?
> > What I have is DB1 and DB2, I need to take values from DB1 and insert
them
> > into DB2...this is
> > just the cut and dry of what I am doing... I am actually doing a lot
more
> > but this is the foundation.
> >
> > Any ideas?
> > T-SQL?
> >
> > mike
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
