So after trying to get sample data for you guys to use, it turns out that the data is not organized from the source in a way that even makes...

In response to your comments about better design, I do have reasons for using ANSI standard data types in this case. The rest of my data marts and warehouse are...

Hi, Scott. Thanks for your input. My question isn't so much about how to improve performance of the database but what SQL logic would be most efficient to use given...

Good morning. Just to let you know I am in the process of putting together the DDL and DML and sample data you requested. It will take me a few...

Is it going to be impossible to discuss without sample data? If so, let me know and I will create a spreadsheet. If you have a test data generator I...

Yes please

Thank you everyone for all of your suggestions! I took out the DISTINCT and the ORDER BY and the temp table and it was much simpler and works beautifully. All...

Thanks, Scott. That answered my question. For Mike01, I should have used a better example: SUM(charges) or something like that.

Eric, was this post in response to mine? Not sure if you meant it for something else since performance stats was not an issue for me. BTW, we find SQL...

Just to give an update, I successfully created a flexible stored procedure which creates the denominator data set for each of the 4 measures I have to do first for...

Thank you Subramaniam. I already make heavy use of cubes but in order to do my measures and dashboard I have to first create a data model, which I don't...

LOL, Jonathan! You clearly have walked in my shoes. Yeah, the fact that these change so much over time is problematic. This is really only for internal dashboards and not...

Not sure why that matters. I am using SQL Server 2016 to develop a data mart for these measures which will probably be brought into PowerBI.

Eric, this is exactly what I was thinking... I want to do something "data driven". I just couldn't come up with the term! And thank you for confirming that the...

Thank you Lynn. If I took it the wrong way, I apologize. It is often the case that people on forums like this immediately make judgments about the way things...