<div>
Hello Aparanjit<br />
<br />
Please refer to this sample...Is this the sort of thing you are after. &nbsp;How many rows are in your data now? &nbsp;3? or was that just for the question. &nbsp;<br />
<br />
<a href="http://www.sqlfiddle.com/#!3/3d7d7/1" rel="ugc">SQL Example for increment</a><br />
<br />
else if your table is empty but planned, maybe you could also do it in excel and then just import the 100 records to the table?
</div>


Hello Aparanjit

Please refer to this sample...Is this the sort of thing you are after.  How many rows are in your data now?  3? or was that just for the question.  

SQL Example for increment [http://www.sqlfiddle.com/#!3/3d7d7/1]

else if your table is empty but planned, maybe you could also do it in excel and then just import the 100 records to the table?

<div>
Thank you for the solution acceptance - but I'm curious why did you award only a B grading?
</div>


Thank you for the solution acceptance - but I'm curious why did you award only a B grading?

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I have a table with three columns say ID with identity, name and location and for this columns say I have values as (1,'RAM','CA'), (2,'SAM','IA'),(3,'PAM','M<wbr />I') etc.... Now want to get 100 rows, say after 3rd row, the 4th row should again start with same name and same location but adding one value to it, say 4th row will be values (4,'RAM1','CA1'), similarly 5th row will be (5,'SAM1','IA1') and 6th row will be (6,'PAM1','MI1'). Again for 7th row it should give values as (7,'RAM2','CA2') and so on. So it should continue like this till 100th row, for that I need to write the code, I could not able to figure it out, can you please help me in this.<br />
<br />
Thanks,<br />
Aparanjit
</div>
</div>


Hi all,

         I have a table with three columns say ID with identity, name and location and for this columns say I have values as (1,'RAM','CA'), (2,'SAM','IA'),(3,'PAM','MI') etc.... Now want to get 100 rows, say after 3rd row, the 4th row should again start with same name and same location but adding one value to it, say 4th row will be values (4,'RAM1','CA1'), similarly 5th row will be (5,'SAM1','IA1') and 6th row will be (6,'PAM1','MI1'). Again for 7th row it should give values as (7,'RAM2','CA2') and so on. So it should continue like this till 100th row, for that I need to write the code, I could not able to figure it out, can you please help me in this.

Thanks,
Aparanjit

I need to write a query which repeats the rows by incrementing the values

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.