Cacher is the code snippet organizer for pro developers

CREATE TABLE #TestTable ( 
		spID			VARCHAR(100),
		hostName		VARCHAR(100), 
		blkBy			VARCHAR(100),
		activeSeconds	VARCHAR(100),
		programName		VARCHAR(100),
		cpuTime			VARCHAR(100),
		diskIO			VARCHAR(100),
		query			VARCHAR(MAX)
	);
	INSERT INTO #TestTable
	EXEC sp_who3;