>What would the syntax for this be that I could use in a stored procedure?
>

>=StrToFile( @TextList, ‘c:\temp\List.Txt’)
>

There's no simple way to write to text file in SQL Server. Take a look at http://www.umachandar.com/technical/SQL2000Scripts/UtilitySPs/Main7.htm and http://mysite.freeserve.com/nigelrivett/WriteTextFile.html.