Why don't you look into Report Services they use a format called Matrix to satify the Pivot Logic.

we created a pivot table stored Procedure as follows :

Hope this helps

/*

Pivot Table stored procedure

Description:

Generates...

I use the following query to findout if my backups have worked :

SELECT  B.name as Database_Name, ISNULL(STR(ABS(DATEDIFF(day, GetDate(),MAX(Backup_finish_date)))), 'NEVER') as DaysSinceLastBackup,

ISNULL(Convert(char(10), MAX(backup_finish_date), 101), 'NEVER') as LastBackupDate

FROM master.dbo.sysdatabases B LEFT OUTER...

I use the following code for this situation :

USE master

EXEC sp_addumpdevice 'disk', 'BackupDB',

   '\\dbsrv01\f$\Testdatabase\BackupDB'

BACKUP DATABASE Take2 TO BackupDB

-- Restore the files for MyNwind2_Test.

RESTORE DATABASE Test

   FROM BackupDB

   WITH RECOVERY,

   MOVE 'LogicalFilename'...

Have you tried using Report Servises. Thats if you can afford .net 2003. I have read it is possible to interact with excel.

we use the following sp to

accomplish this :