The install went fine without any hitches. But now we're trying to connect back to our MSSQL 2000 server with the query noted at the top of this thread and...

Yeah basically same case as me. We need upgrade this server but in the interim need to get this up and working. Looks like I need to update SQL Server...

Thanks Gazareth. Host OS on the MSSQL 2000 server is Windows 2003 Standard Edition SP2. So I'm assuming I'm OK with the latest SQL 2008 NC install?

Thanks Dev. So it *must* have SP4 installed before putting 2008 Native Client on it?

Moderator - did I post this in the wrong forum? Should I have put this in the SQL Server 2008 Administration

forum? Just want to make sure it's in the...

Happy Monday to everyone! Was hoping there was someone out there that can review this thread and provide a solution. Any help would be greatly appreciated!

I attached an img for ease of reading.

Absolulety..and I should have done this to begin with. Apologies.

Here's the result set I'm looking to achieve.

ystMTDYTD ystphrMTDphrYTDphr*ystGRANDTOTAL**MTDGRANDTOTAL**YTDGRANDTOTAL*

--------- ------------------ --------------- ...

Unfortunately Wayne that did not work. If you look at the query in my original post, how could we structure the syntax in a way to get your suggestion working...

Thanks for the feedback. What I'm ultimately looking for is to create new columns for the "Grand Totals" and then pull the single value from that column via SP to...