by Uwe Ricken | Mar 14, 2026 | Level 200, SQL Challenges
Problem Description / Requirement A developer has heard from the new feature “Scalar UDF Inlining” and he wanted to improve a stored procedure [dbo].[get_last_order_months].This stored procedure is called 10 to 100 times per hour by the marketing...
by Uwe Ricken | Feb 2, 2025 | Level 200, SQL Challenges
Problem Description / Requirement The software manufacturer’s database uses the [SQL_Latin1_General_CP1_CI_AS] collation for the application. The development team wrote a custom function that can be used to find customers based on an address search. The...
