sql server programming: As far as I know, you cannot use a view for this; you'll have to use
some sort of dynamic SQL in a stored procedure (assuming that your SQL
statement is short enough). Your only other option is to create a
UNION ALL view that contains the SQL statement for each database, and
include the source database as a varchar value, eg:

CREATE VIEW masterdata AS

SELECT columnlist, 'database1' as SrcDB
FROM database1.dbo.table
UNION ALL
SELECT columnlist, 'database2' as SrcDB
FROM database2.dbo.table


You could then pass your database name as a criteria to limit the
results. Of course, you'll have to figure out some form of maintenance
protocol whenever you add a new client, and performance will probably
be less than optimal.

Stu

[quoted text, click to view]