I currently have a query which pulls user data...
Fname, lname, dob, userAcct
I also have an application that consumes that query, and writes the data to a text file (which is processed by a vendors application to create a user account in another SQL database (for realtime document management))
I want to skip the middle man by converting this query into a stored procedure... What I am unsure about, is once the query has been run, how can I write the retrieved rows straight to the other DB? Crossing over to the other DB isn't the problem. So if someone can show me how to write query results to a table, that would be great.