Create CSV from column (SQL2K only)

if object_ID('sp_ReturnCSV') is null drop procsp_ReturnCSV  

create PROCEDURE sp_ReturnCSV  
@ColumnName varchar(25), @TableName varchar(8000)  OUTPUT 

AS  


BEGIN 

   DECLARE @newSQL nvarchar(4000)
Set @NewSQL = 
'declare @SQL varchar(8000)
Select @SQL =  isnull(@SQL + '','','''') + ' + @ColumnName + ' From ' + @TableName + ' (nolock)

select @SQL'

exec( @NewSQL)


   

END



exec sp_ReturnCSV @ColumnName = 'au_id', @TableName = 'pubs.dbo.authors'