I need to run a query which will pull data from two tables and append
it as one when it displays the result. The data are in two tables. But
the result set will be identical in terms of number of columns. I want
to display it one set below the other.
This is for pay history. From 2003 we have a new payroll system. Till
2002 we used to have a different system. But I need to run a query
which will pull the data for an employee for the last one year. So the
information is spread out between these two tables. Both these tables
are in SQL Server databases.
I want to write a Stored Procedure. I can use Shape/Append but I think
it doesnt work on QA/Stored Proc. It needs an OLEDB.
How can I write the query. I dont want to use temporary tables and do
inserts.
Thanks
GIRISH