L'actualité technique MS SQL Server en France (et ailleurs)

Recursive CTE

Creating a Date Dimension (Calendar Table) in SQL Server
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]

14 avril 2025 dans Sites anglophones étiqueté Analytics / business intelligence / data analysis / Date Calculations / date dimension / Date Formatting / Date Functions / Date Metadata / Date Range / Fiscal Year / Recursive CTE / Reporting / SQL programming / SQL Queries / SQL Server / SQL Server 2022 / SQL Server Development / SQL Tips / t-sql / time intelligence / Time Series Analysis par sqlservercentral.com

Parsing a Pairs of Values in a String While Preserving ...
Introduction In a project I’m currently working on, I need to modify a stored procedure that returns a […]

11 octobre 2023 dans Sites anglophones étiqueté Common Table Expressions (CTE) / Parsing / Recursive CTE / strings parsing par sqlservercentral.com

Calculating Prime Numbers With One Query

Introduction I want to share the solution to the problem of searching for prime numbers using T-SQL. The […]

14 juin 2023 dans Sites anglophones étiqueté Common Table Expressions (CTE) / Recursive CTE par sqlservercentral.com