- IF OBJECT_ID(N'dbo.GenerateRows') IS NOT NULL
- DROP FUNCTION dbo.GenerateRows;
- GO
- CREATE FUNCTION dbo.GenerateRows (@Count INT)
- /*
- https://yabele.blogspot.com/2017/07/mssql-function-to-generate-empty-rows.html
- */
- RETURNS TABLE
- AS
- RETURN
- WITH TenRows AS (
- SELECT * FROM (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10)) AS T(I)
- )
- SELECT TOP(@Count)
- I = ROW_NUMBER() OVER(ORDER BY (SELECT 1))
- FROM
- TenRows T1 CROSS JOIN TenRows T2 CROSS JOIN TenRows T3 CROSS JOIN TenRows T4 CROSS JOIN TenRows T5
- /*
- SELECT * FROM dbo.GenerateRows(100);
- */
- ;
Tuesday, 25 July 2017
MSSQL - Function to generate empty rows
There the text of inline table-value function to generate a specified count of empty rows:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: only a member of this blog may post a comment.