If I get this right, that works great for numbers that are either greater or smaller but what about fluctuating numbers?

Sometime the drive space could be less sometimes more!

Here is...

Navin,

Excuse my ignorance! I am new to all of the SQL stuff. Should I assume that the values used in the temporary table come from my sql statement?

Thanks

Sorry about the formatting!

NameDriveVolFSSizePsizeFreeDate

SRV1D:AppsNTFS1735817246172412003-07-15 20:15:53.000

F:LogsNTFS9999990398962003-07-15 20:15:53.000

98932003-07-31 05:18:48.000

SRV2E:DataNTFS1592145415002003-07-14 22:50:59.000

14792003-07-30 18:52:23.000

F:AppsNTFS2046129813382003-07-14 22:50:59.000

13172003-07-30 18:52:23.000

Thanks Mark,

Here is the output:

Name Drive Vol Name FS Disk Size Part Size Free ...

Armed with this, this is the query built!

I was not comfortable enough with your query (rd) so I stuck with the original with the changes Brent mentioned.

Create Procedure usp_SMSR6120 --...

The results.....

Brent, by removing the join in the sub query, I only had to add SMSSite.SiteCode in the Group By but apart from that it works great!

rd, like Brent! thanks....

Thank you very much...both! I will try both solutions tomorrow and will post back the results!

Again, thanks

Rene