kiran sabneforSQL Developer Blogmssqlserver.devยทFeb 8, 2022SQL Server repeat rows for n number of timesTo repeat each row or record n number of times, based on some column value in a table, we could do it in two ways either by using CTE or if n is less than 2048 then you can do a simple inner join on master.dbo.spt_values table with a condition where ...798 readsSQLAdd a thoughtful commentNo comments yetBe the first to start the conversation.
