asked on

What is the syntax to merge together two different stored procedures (pulling similar data from 1 database(SQL)) with a function in (Visual Studio) in a batch application

Basically the output needs to look as follows in excel

header1 header2 header3 header4 header5 header6 header7 header8 header9
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx

Then have 2 lines blank and now show the second stored procedure underneath the information from the first stored procedure all in the same excel file

header1 header2 header3 header4 header5 header6 header7 header8 header9
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx xxxxx xxxxxx xxxx xxxxx xxxxx xxxxxx

ASKER CERTIFIED SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeremy Gohman

ASKER

thanks it worked!