+1 on the link Matthew sent. If the databases are on two different
servers (or two different instances of SQL Server on the same box),
you'll need to create a linked server on one of the servers to connect
to the other one.
Carl
On 11/10/2010 11:30 AM, Matthew Woodward wrote:
On Wed, Nov 10, 2010 at 11:25 AM, Jason King <[email protected]
<mailto:[email protected]>> wrote:
MS SQL
http://chrisshaw.wordpress.com/2008/07/07/cross-database-joins/
--
Matthew Woodward
[email protected] <mailto:[email protected]>
http://blog.mattwoodward.com
identi.ca <http://identi.ca> / Twitter: @mpwoodward
Please do not send me proprietary file formats such as Word,
PowerPoint, etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
official manual: http://www.openbluedragon.org/manual/
Ready2Run CFML http://www.openbluedragon.org/openbdjam/
mailing list - http://groups.google.com/group/openbd?hl=en
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
official manual: http://www.openbluedragon.org/manual/
Ready2Run CFML http://www.openbluedragon.org/openbdjam/
mailing list - http://groups.google.com/group/openbd?hl=en
