Export Column of text into individual files

exporttotext.sql

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'xp_cmdshell',1;
RECONFIGURE
GO

CREATE TABLE TempProcessStore ([RowNo] [smallint] identity (1, 1)
								,[name]		nvarchar(128)
								,[ProcessType]	nvarchar(50) 
								,[processxml]	nvarchar(MAX))
INSERT INTO TempProcessStore ([name], [ProcessType], [processxml])
SELECT	name
		--,ProcessType
		,CASE 
			WHEN ProcessType = 'O' THEN 'BPA Object - '
			WHEN ProcessType = 'P' THEN 'BPA Process - '
		 END
		,processxml 
FROM BPAProcess
DECLARE  @First				[smallint]
		,@Last				[smallint]
		,@FileName			nvarchar(128)
		,@SQLCommand		[varchar](500)
		,@ProcessType		[nvarchar](50)
SELECT @First = MIN([RowNo]) FROM TempProcessStore
SELECT @Last = MAX([RowNo]) FROM TempProcessStore
WHILE @First <= @Last
BEGIN
	SELECT @FileName = [name] FROM TempProcessStore WHERE [RowNo] = @First
	SELECT @ProcessType = [ProcessType] FROM TempProcessStore WHERE [RowNo] = @First
	SET @SQLCommand = 'EXEC xp_cmdshell ''bcp "SELECT processxml FROM dbR2D2_BP_Testing.dbo.TempProcessStore WHERE [name] = ''''' 
					+ @FileName + '''''" queryout "C:\tmp\' + @ProcessType + @FileName + '.xml" -T -c -t,''' 
	PRINT @SQLCommand
	EXEC (@SQLCommand)
	SET @First = @First + 1
END

DROP TABLE TempProcessStore
EXEC sp_configure 'xp_cmdshell',0;
RECONFIGURE
GO