In this blog post, you will get the query to "Split data into N equal groups" using SQL Server and you will also see the practical implementation of the following important topics of SQL Server. Happy learning ! 1) Ranking Functions (ROW_NUMBER() and NTILE()) 2) Local scoped temporary/hash table 3) CTE (Common Table Expression) 4) … Continue reading Split data into N equal groups
Category: Queries
Generic scalar function to check the tolerance – SQL Server
Generic trigger for audit log – SQL Server
Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.
SQL Server Carpenter 