hi Guys,
I writing a stored procedure using a number of cursors. Each cursor gets a specific set of data, cycles through it creates a very specific Text String (for each row) using the data and then outputs that text string to one of three flatfiles...
At least it would if I could figure out how to write to the file.
I think i could get it working using xp_cmdshell but my DBA is somewhat reluctant to give me the permissions.
Is there any other way to append a string from a sproc to a flatfile??