T-Sql result set unioning and pumping into a Table

  • 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.

  • May I suggest that you read the first article I have linked in my signature block below? If you follow the guidelines presented in the article when asking for assistance, you will get much better responses.

    Based on your original post, I really have no idea where to even start to help you.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply