Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
The databases and views are identical in terms of fields, tables etc - only the data changes.
Can anyone advise on how to create a large recordset containing all the records in View C + all the records in View D.
I'm not sure how to do the sql that links two seperate MSSQL databases (on same server), and don't know how to append all records together (as they aren't really being "joined" to each other on a key as such as far as I can tell?).
joined:Dec 10, 2005
The naming convention is DatabaseName.[owner].TableName (and TableName can also be ViewName).
Similarly, if you have setup a linked server, the naming convention would be:
Is there a way to identify which database (e.g. A or B) a given record came from (I can't add a new field to the databases as they are overwritten daily)?
Just add a different literal to each select.
select *, 'A'
from table A
select *, 'B'
from table B