I spent the day digging through the logic of a c# web application.
In attempts of converting the business logic to SQL.
It's not as simple as it seems.
The SQL is built on the fly depending on rules.
And it loops and calls queries from time to time.
The goal is to get the Business Logic into a Stored Procedure.
Which will either go in an SSIS package.
Or a standard SQL Agent job.
To run every hour or so.
And pull the new data.
Add it to some local tables used for reporting.
To be queried from SSRS and the Dashboard.
Can blast SSRS email subscriptions possibly.
And perhaps create a Tabular Model from it.
For now just trying to understand the flow of the web app.
Tomorrow can dive into the logic a bit more.