Thank you Raymond..Your code helped me build mine.Hope this helps:

SET NOCOUNT ON

IF OBJECT_ID(N'tempdb..#drive_space') IS NOT NULL DROP TABLE #drive_space

CREATE TABLE #drive_space

(name varchar(5)

, available_mb int)

INSERT #drive_space(name,available_mb)

EXEC master..xp_fixeddrives

DECLARE

@drive VARCHAR(5)

,...