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.