Need an example of a Stored Procedure that combines two different databases into one temp table for reporting purposes.
Need some examples or example not too big and overwhelming but a system that shows syntax etc. of the combining of two databases with multiple tables if possible that would show how they are pushed into a temporary table and used for reporting purposes. I got the reporting end just not the stored procedure syntax. Please let me know if you have anything like that. Thank you.
Jim Horn
Give us some more details of exactly why you need this, as so far this smells like homework.
ASKER
I have a client who wants to combine two DBs. A Macola database and a SQL Server database. They seem to think the only way to go is to create a stored procedure that combines the two into a temp table and then it is used to write a Crystal Report off of.
Some problems are the field lengths are different.
Some of the field types are different.
I have written stored procedures but never ones like this.
I am open to alternative solutions as a suggestion to the client but if there is a way to do this or if you have examples I need to try. I am open to either I have never had such difficulty with data ever.
Some problems are the field lengths are different.
Some of the field types are different.
I have written stored procedures but never ones like this.
I am open to alternative solutions as a suggestion to the client but if there is a way to do this or if you have examples I need to try. I am open to either I have never had such difficulty with data ever.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
They are both SQL Server back end Dbs.....
24 reports....
Does SSIS come with SQL Server 2008 R2...? If so where...?
24 reports....
Does SSIS come with SQL Server 2008 R2...? If so where...?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am speaking of the columns and or fields I want to put into a temp table so that when I access the SP the data is already merged from the past system Macola into the New SQL Server DB.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you gentlemen for the advice.