Handly snippets to create user-defined Tables, Views, Procedures, and Functions to support Data Warehousing and Data Lake Architecture processing.
-
A large propotion of the snippets were developed when the author's primary working environment was SQL Server 2008R2. As a result, handy system in-built functions introduced in later versions of SQL Server, such as STRING_AGG(), LEAD(), LAG(), are not being used in the development