Export Stored Procedure results to text file

DECLARE @UserId int
 
	DECLARE AllUsers CURSOR FOR
		SELECT usr.UserId
		FROM tbl_user usr
 
	OPEN AllUsers; FETCH AllUsers INTO @UserId
 
	WHILE @@FETCH_STATUS = 0 BEGIN
		DECLARE @T TABLE(UserName nvarchar(100), ID int, Created smalldatetime, Title nvarchar(200), Value int)
 
		INSERT @T
		EXEC	spr_LifeScan_GetScanResultsNew @UserId
 
		INSERT @T
		SELECT UserName, ID, MAX(Created), 'Average', AVG(Value)
		FROM @T
		GROUP BY UserName, ID
 
		SELECT UserName, ID, Created Date, Money, Health, Crime, [Public Spending], Transport, Giving, International, Environment, [Average]
		FROM (
			SELECT *
			FROM @T
		) a
		PIVOT (
			MAX(Value)
			FOR Title IN (Money, Health, Crime, [Public Spending], Transport, Giving, International, Environment, [Average])
		) p
		ORDER BY Date DESC
 
		Delete @T
		FETCH AllUsers INTO @UserId
	END
 
	CLOSE AllUsers; DEALLOCATE AllUsers