Greetings -
Each month at end of month - we run a customized HARTB SQL stored procedure. It's essentially same SQL stored procedure (rmHistoricalAgedTrialBalance) used by the GP interface but customized (additional customer fields, customized aging buckets, etc.).
Currently we have an excel file that we use power query to run the customized SQL Stored procedure.
I would like to populate a customized SQL table with the output of the procedure (rather than populate an excel file). I've got the SQL Table already and I currently use smart connect to upload the data to the customized SQL table - where we can analyze - power BI etc. around the data. The output is critical to reconciling the GL accounts to AR subledger, data analyzing AR balance trends, etc.
Typical monthly output is 15,000 to 16,000 rows of data.
What is my best course of action? I'm a SQL beginner at best - I can look at the script and I can tell it essentially populates temp tables (multiple-4) with data from the core stored procedure and our additional data (collectors, UDF fields) then at end uses a select statement to return the data.
Can I simply change the select part (at end) and replace with insert into values syntax?
It's a long script I didn't want to post it but happy to post it if it facilitates a conversation and some knowledge sharing.
Thanks in advance.