SQL Server Nuggets

https://www.red-gate.com/simple-talk/databases/theory-and-design/values-clause-building-tables-out-nothing   SELECT      EXCEL_LEVEL1_ROLLUP,      GROUP_NUMBER FROM (     VALUES          ('Fuel Sales', 1),          ('Conv Store Sales', 1),         ('Gift Shop Sales', 1),         ('Other Sales', 1),         ('Vending/Gift Cost', 2)     ) AS v (EXCEL_LEVEL1_ROLLUP, GROUP_NUMBER);

https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/summarizing-data-using-group-by-and-having-clauses  

https://www.mssqltips.com/sqlservertip/7358/document-data-store-data-models-and-proximity-queries/   Check Materialized Paths

  https://www.mssqltips.com/sqlservertip/7372/sql-server-function-generateseries-expand-date-range-into-rows/

  https://www.sqlservercentral.com/articles/the-numbers-or-tally-table-what-it-is-and-how-it-replaces-a-loop-1

https://www.mssqltips.com/sqlservertip/7372/sql-server-function-generateseries-expand-date-range-into-rows/  

https://www.sqlservercentral.com/articles/manage-your-business-rules-in-t-sql-query