IF OBJECT_ID('tempdb..#drives') IS NOT NULL
DROP TABLE #drives
CREATE TABLE #drives (
drive char,
[free] int
)
INSERT INTO #drives
EXEC master..xp_fixeddrives
SELECT drive, [free] / 1024 as FreeSpaceGB
FROM #drives
Till Next Time
Past 12 months dynamic
-
{StrToMember("[Kalender].[J4MND].[Jaar 4MND Maand].&["+Format(DATEADD("M"
,-1,now()),"yyyyMM")+ "]").Lag(11):StrToMember("[Kalender].[J4MND].[Jaar
4MND Maan...
No comments:
Post a Comment