the_b1ackfox
asked on
MSSQL Procedure
Hello Experts!
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.
Thank you!
Fox
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.
Thank you!
Fox
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cyberkiwi, Awesome response. I used the info to build a trigger. total efficiency gained by this endeavor 35%. Annoyance factor removed, my pain is gone. Thank you, thank you
ASKER