Thank you.

Ok to close. Answer is on Target.

You are on fire today...2 for 2. That worked.

Is there better performance with the second way?

Awesome...this was the key I was looking for. Many thankx.

I adjusted it with convert to get into YYYYMMDD:

Select convert(varchar(8),dateadd(day,(substring(HBEFFDTE,2,7) % 1000) -1,convert(datetime,'01/01/' + LEFT(substring(HBEFFDTE,2,7),4) )),112)

Again thank you.

I tried [Year] and it didn't work. I did get it to work. I put in 'Year' and it went through. For some reason it would not work originally but...

Thanks for the information. I will review it.

I be interested in seeing this a liitle closer. Where did you dig up the research? How do you handle parm data (parameters passed into the script)?

The thing I...

Hello,

I got it to work with the Free ware: SaveDelimitedColumns. Works pretty nice. I can put it on the network drive and the client pick it up.

I tried the...

Hello,

As anyone used SaveDelimitedColumns or SaveDelimitedColumnsNullQuoted?

These are some stored procedures that can to exactly what I am looking for but I am having a hard time getting fields...

Where could I find more information on 'BoL'?

Also, Besides the ways discussed previously; Could I do this through report manager?

Just curious, then the client could run a label when...

Sounds like a good plan.

Good luck.

What error messages in the log's do you see? That would be a place to start. Also, look at performance monitor, Are there net work issues: I/O, batch locks. Error...

For what it is worth: We just had a similar issue. Take a look at your logs. Are you getting a lot of batch type error messages?

If so, we...

Changing the AWE seemed to work. (knock on the wood in my noggin). We have gone through monthly reporting with out any issues.

Thank you to everyone for the...

Hey, Can I ask you? Does the error look to be part of this:

When you run SQL Server with the awe enabled option, SQL Server may hold a latch while...

Hello,

We turned on server tracing and I see that I am getting buffer latch type 2 errors on Spid's 70,67, 64.

I cross refereded in the trace that:

64 is...