En este post te voy a explicar como puedes generar una secuencia numérica sin while, usando CTEs con SQL Server.
Contexto.
Necesito generar una lista de enteros incrementales para una función SQL.
Solución.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE @maxNumber int = 99 | |
DECLARE @nextNumber int | |
;WITH generatedNumbers AS ( | |
SELECT 1 AS Number | |
UNION ALL | |
SELECT Number + 1 | |
FROM generatedNumbers | |
WHERE Number + 1 <= @maxNumber +1) | |
SET @nextNumber = ( | |
SELECT TOP 1 * | |
FROM generatedNumbers) |
Últimas entradas de Gustavo Sánchez (ver todo)
- NVL in SQL Server - 2023-11-01
- ¿Que es Cake Build? - 2023-02-22
- #How to fix error: MSB4019: The imported project «Microsoft.Data.Tools.Schema.SqlTasks.targets» was not found - 2023-02-20