Greg,

No - you are correct in that the UNION causes the duplicates to be removed. This is true even if all the results come from a single result set....

I suppose, since bcp allows a query, all of this could be done as the query argument for the bcp command. (In case it is important to keep unchanged...

Thanks for the feedback.

Guarddata-

Which version of SQL are you running? Assuming it is Enterprise (since standard won't recognize beyond 2GB), remember there is also and /awe switch needed (I just don't remember...

DTS is pretty powerful if you have time to learn it. I haven't produced XML for export, but, depending on what you are doing with the result, this might...

We did have a similar problem once - many moons ago. Seems that our interface had somehow cached the call...but I cannot remember much about it. I've never...

Wish I could help on that score, iakar. I played with this for quite a while before deciding that it would take a better understanding of the internals than...

This will give you the column names from the view. I am not quite happy with it yet - I cannot get the view column name and the table...

Interesting question David. Rachel, I just assumed that the columns were defined as CHAR instead of VARCHAR. VARCHAR data will come out without trailing spaces.

Guarddata-

Of course, if you have been careful in the creation of the text file, ExCel can read it directly.

Is DTS an option here?

Guarddata-

Thanks for the input. Any preferences regarding the lookup tables? I have generally worked on projects where they were in the same database but have had some cases...

Perhaps you are looking for something like this:

SELECT sv.name 'View', svc.name 'Column'

FROM sysobjects so (NOLOCK)

INNER JOIN sysdepends sd (NOLOCK) ON sd.depid = so.id

INNER JOIN syscolumns...

I am unaware of a bcp command that will trim the fields. I would recommend using a view that is created like

CREATE VIEW exportMyTable AS

SELECT RTRIM( column1 )...

You could try this - I didn't take time to add error checking or anything and just use the same routines as sp_spaceused to get database allocation.

This procedure should exist...

ewilson10,

We have four main tables:

MessageHeader: Holds subject, priority, "From", Date to Send, Status

MessageBody: Series of Text fields that combine to complete the message.

MessageTo: Recipient list (To, CC, BC, etc.)

MessageAttach:...