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
