File Creation or BCP utility

[alwinSCH]

Helo, Can anybody help me! I have 3 tables first 1 have a header table with one row the second table are all the data records and the third is a trailer table! So now i want to create 1 file with all the fields of the header table separated through ; then new line, the data table with the fields separated through ; and finally the trailer table with fields separated through ; i think i can do this with Bcp utility or something like this, but i don't know how! Please help! Thank you

[Wendelius]

You can create a SQL statement giving you correct result set and then save the result to a file. Use UNION and concatenate all fields from a table to a single field using desired separator Mika

[alwinSCH]

Ok, thank you but i want to put this in a stored Procedure... So i can call it from out of a program! A.

[Ashfield]

Well, you have several options You can use BCP (with a stored proc or a select) and a format file to create an output file, but this relies on ALL rows having the same number of fields You can use the idea of concatonating the fields together with your delimiter and use this query in your bcp with effectively a single field per rocord You can just read the data into your program and write the file yourself. Try Goggling for format files in bcp There are probably other ways too, but I can't be bothered to do your job any more...

Bob Ashfield Consultants Ltd

[Wendelius]

It doesn't matter. You can return the result set from procedure almost like you can return it from SELECT statement so wrapping the statement into procedure is ok.