---
title: "Discussion on \"SQL Server repeat rows for n number of times\" | Hashnode"
description: "Discussion on \"SQL Server repeat rows for n number of times\". To 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"
url: "https://hashnode.com/posts/sql-server-repeat-rows-for-n-number-of-times/6215b6042c936b90065dc521"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [SQL Server repeat rows for n number of times](https://mssqlserver.dev/sql-server-repeat-rows-for-n-number-of-times?utm_source=hashnode&utm_medium=feed)

To 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

Feb 8, 2022 · 2 min read · mssqlserver.dev  
Updated Feb 10, 2023  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#sql-server](https://hashnode.com/tag/sql-server)
-   [#databases](https://hashnode.com/tag/databases)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#mssql](https://hashnode.com/tag/mssql)

## Written by

[kiran sabne](https://hashnode.com/@kiransabne)

@kiransabne

  
[View profile](https://hashnode.com/@kiransabne)

SQL Developer and Backend Developer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
