Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-28 : 09:15:57
|
| Fred writes "Call me Lame, i'm having trouble extracting data from multipule tables from mulitpule databases and joining them to create a temp table(in a stored proc.).Can you help me ?" |
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2001-11-28 : 09:26:45
|
| just a quick point.make sure you are using fully qualified names like CATALOG.OWNER.TABLE or if running across multiple SQL Servers maked sure you have the approriate linked servers and then user SERVER.CATALOG.OWNER.TABLE.Hope that helps, otherwise post your tables and you current query. |
 |
|
|
|
|
|
sql across databases (SPROC)