Home Forums Reporting Services Reporting Services SQL Merge 2 Databases RE: SQL Merge 2 Databases
Ant-Green
SSC Guru
Points: 113445
More actions
October 1, 2012 at 1:59 am
#1543807
What it looks like you need is a UNION clause, either in a stored proc on direct in the data set.
SELECT
1,2,3
FROM
DB1.dbo.Table2
UNION / UNION ALL
DB2.dbo.Table1