artsapimp — Tue, 26 Feb 2002 22:26:26 +0000

Ok, that makes sense.

Thank you for your help.

Peter J. Boettcher — Tue, 26 Feb 2002 22:12:40 +0000

For selecting data you can create a view, for example:

CREATE VIEW ViewName
AS
SELECT a.ColumnName1, a.ColumnName2, b.ColumnName1, b.ColumnName2
FROM database1.owner.table1 a, database2.owner.table2 b
WHERE a.ColumnName1 = b.ColumnName1

artsapimp — Tue, 26 Feb 2002 18:13:17 +0000

This works great. Thank you.

Now I am having another problem. I know it has a simple resolution but I don't know what that is. How do I link to a table in a different database? Both databases are on the same SQL server.

Thanks for your help.

Peter J. Boettcher — Mon, 25 Feb 2002 13:55:28 +0000

Convert your query to a stored procedure and then use @@identity to get the new record id.

For an example check out http://www.aspfaq.com/show.asp?id=2174