Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ursunshine66
Starting Member
3 Posts |
 Posted - 2011-10-03 : 02:06:31
|
| Hi I have a sql script with header on and it generates output in text file with the header repeating after every 20000 records. how do I make the header only appear once? pls help a.s.a.p. tq!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-03 : 02:22:54
|
| how is it doing the export? is it using bcp? Can you post part where header comes?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ursunshine66
Starting Member
3 Posts |
Posted - 2011-10-03 : 02:44:19
|
| Hi...this is how the top part of the sql script looks like...set term offset linesize 9999set head onset pagesize 9999set feedback offset verify offset echo offset colsep '|'--col "CLIENT" format a3 col "/BA1/CR0GROUP" format a62col "/BA1/CR0TSTMP" format a21col "/BA1/CR0LEAFID" format a32col "/BA1/C92SCEN" format a10col "/BA1/CR0ROOTID" format a32col "VERSION_GUID" format a32col "/BA1/CR0NDTP00" format a14col "/B20C/S_R0CREL0" format S9999999999999990.00 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-03 : 02:52:29
|
| it looks like oracle code. This is MS SQL Server forum and solutions given here are sql server specific. If you're using oracle please try posting it in oracle forum like www.orafaq.com------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ursunshine66
Starting Member
3 Posts |
Posted - 2011-10-03 : 02:58:07
|
| ok tq |
|
|
|
|
|
|
sql script query