EXEC master..xp_cmdshell 'dir c:'
EXEC master..xp_cmdshell 'RENAME E:\"HR Reports"\"Master Sheet"*.xls "Master Sheet".xls'
Aug 8, 2010
T-SQL RollUp
--Sample Script
SELECT CASE WHEN (GROUPING(Data_type) = 1) THEN 'ALL'
ELSE ISNULL(Data_type, 'UNKNOWN')
END AS Data_type,
SUM(Type_id) AS Type_idSum
FROM Staging.Data_Type
GROUP BY Data_type WITH ROLLUP
SELECT CASE WHEN (GROUPING(Data_type) = 1) THEN 'ALL'
ELSE ISNULL(Data_type, 'UNKNOWN')
END AS Data_type,
SUM(Type_id) AS Type_idSum
FROM Staging.Data_Type
GROUP BY Data_type WITH ROLLUP
Subscribe to:
Posts (Atom)