SQL remove header row from query

[anichols]

Hello all,

Is there a way to remove the header row on my output in a sql query? I just having to manually delete it.

Thanks

 

[Joe4]

Where are you deleting it?
Are you exporting it to somewhere first?
It has been a while since I have used SQL, but I don't know of a way to export the data without a header row.
You could conceivably create a VBScript to remove the first row.

If you are trying to import the data into another system, most systems that I am aware of have the ability to ignore the first row on import.