Hi All,
I need a help regarding T-Sql coding.
I need to have a Job which Needs Data to be pulled from one Final table.
What I wanted to get the output of the two Stored Proc(Few col from each Sproc) into a table.
Say Sproc x has five Col as result Set and Sproc Y has Three Col as result.
I need four Col from sproc x and 2 col from sproc y (something like Unioun of result set).
So that my Final Query from which i would select would be from a Single table .
Can T-Sql guru's help me code.
Many Thanks in Advance.