Adding a header and footer row

[jdgonzalez]

I'm hoping someone can help me out with an issue I'm having. I have to create a file populated with data from a stored proc I have written. The problem is that the requirements state there must be a header row with information about the file being sent and a footer row with summed information about the data within the header and footer. How do you write something like this? At first I figured I could just write sql code using a union clause. But I ran into issues getting the format I needed due to a fixed width requirement. Any help provided would be greatly appreciated.

Thanks

 

[donutman]

Can you give us an example of the Header Row, Row data, Footer Row? Unless all of the data in each row is the same type you will have trouble with trying to put it into a single rowset. Are you outputting this to a text file?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]