Need to generate a file and e-mail it from a SQL stored procedure
Posted on 2008-11-06
Hi, all - we're using a SQL based ERP system and need to generate a file for use with our banks' positive pay system. I'm a bit of a SQL novice - I've been able to put together a decent stored procedure that culls the data I need from our ERP system, but don't have the slightest clue what to do with it next. What I need to do is generate a flat text file (fixed width output - not delimited) with the contents of the SQL query and e-mail that file to the specified recipient.
Any help is appreciated!