Union of two tables on different databases on same SQL server (UDF)
Posted on 2004-04-27
I am using a UDF and have a SELECT to union values from two tables that exist on the same SQL Server, but on a different database.
My Problem is, that I would like to pass the table names ([Company2003].[dbo],[Transactions])
as parameters so that I can execute my function for different Database Names.
Any ideas anyone?