row_number() worked very well. guess, I'm becoming rusty. Thanks very much!

Thank you very much Steven. I've been staring at this for the past few hours and to get a very quick answer on a Friday afternoon just made my day....

That guy needs a raise! 😛

this should work:

declare @sql varchar(8000)

set @sql = ' SELECT NAME, ABC AS ' + @Month1 + ', XYZ AS ' + @Month2 + ', MNO AS ' + @Month3 +...

I had something similar to this and what I did was established a linked server and query the table as if it is part of sql server.

e.g. select top...

check out appdev.com. That's where I got my CDs when I started to learn SQL Server 7.

The SQL Server 2000 DVDs are only 500 bucks. And that set will give...

Jeff, thank you very much. This is perfect.

Kindest Regards,

Michael

May I suggest SQL Server 2005 learning CDs/DVDs.

This will get you up to speed fast and you will be posting replies here pretty soon! 🙂

Regards

Thanks, but I was able to resolve the issue by using an openquery() where I put the date rules within.i.e. I cased out all the dates.

Hi Jeff, thank you. I think this will work. But I also need the filesize & filedates. I can store them in a #temp table.

Best Regards,

Michael