I will try that.  Thanks

BUT

I was able to get it with this as well 

DECLARE @DBServer nvarchar(50)

SELECT @DBServer = name FROM sys.servers

Again thanks for your help.

Phil

Thanks for the reply but here is what I currently have in my SP and is is putting a CRLF after each row.

What I need is either during this bcp...

Thanks.

I guess part of my Post got cut off.

Another question.

With ALTER TABLE, can I change the name of a column?  Like xtable.xcolumn to xtable.zcolumn.

Phil

Thanks everyone for your help. 

I can take it from here.

Phil Krieg

Razvan,

Thank you very much.

Phil

Thanks for your reply Jeff.  It confirmed my 'book' findings.

Phil

Prasad,

Thanks for your input. BUT I have been trying everything to get it to work with no success.  It must be in the syntax.  

Any and all help is greatly appreciated.

Thanks,

Phil

Gary,

Sounds like this would work.  But I don't know how to create a FORMATFILE that would skip column 1 and insert the data into column 2 for each row.  Can...

Thanks for the reply, Steve.

BUT @a is bigint

ALSO what if @a was datetime?

Thanks

Thanks for all your help. I get your idea on the multiple creates. I will give it a shot and let you know. I previous tried doing...

It took some time to get an accurate results from the CASE test. It took twice as long with the CASE.

Phil

Andy,

Another point.

I have tried inserting in the front of this a temp table filtering out by apptdate which then passed only the 1000 - 3000 records to the INNER JOINS...

Andy,

Thanks for your input.

Unfortunately I do need all the data. In your opinion could the WHERE be better constructed? Would it make a difference if I put (...)...