Thank you for your response.

It is exactly what I was looking for.

I forgot that MAX can actually help with grouping.

Gary

I had the same issue and the resolution for me was to apply service pack 2 for SQL 2005 and select the Reporting Services choice.

Gary

I also get this message: There is no upgrade script available for this database version." It try to generate upgrade script for database version C.0.8.40

I read the link greg...

Hi all,

this topic is almost what I am in need of. I have looked at Jeff's Code and I see the potential but I am a bit confused as to...

Thank you for the reply.

I checked with the new network people and Active Directory is not installed and according to them Active Directory will not be installed.

I ran a test...

I already tried that and it return 1.5 gb.

I am open to any ideas.

Thanks

I just found this thread, a lot of good information.

Matt, I too am interested in receiving a copy. My address is GaryF@mcgix.com

Good Job with this plan.

Thanks

By setting options one does not understand offeres the opportunity to learn about them!

The trace I am referring to is not on a production machine but a machine on...

Yes, the variable names match exactly.

Gary

I am sorry I did not mention that. I am using the filesystemobject through an activex task.

Gary

Do you have the latest service pak installed?

You didn't say which version of SQL you are using.

Gary

"Can you explain why inserting in a temp table does not works for you? "

I am trying to find ways of speeding up a stored procedure.

Inside the stored procedure I...

Aunt Kathi,

I have been looking in the MSDB and at the tables you mentioned.  If I can create a query that gives me what I want I will post it...

Thanks to all for your responses, they all show merit. I am researching each of the suggestions to see if they are acceptable to our sys admins and our customers.

Thanks...

Mr. Moden, thank you for the quick reply.

I am not entirely clear on how the work is being done.

In the function it looks like the "COALESCE" function is doing the...