<div>
Insert Into Table2 (Fruitname,Qty)<br />
Select FruitName, 1 From YourTable t<br />
inner join <br />
(<br />
Select Distinct &nbsp;Number From Master..spt_values <br />
Where Number &gt;0 <br />
) as &nbsp;i<br />
on t.qty &gt;= i.number 
</div>


Insert Into Table2 (Fruitname,Qty)
Select FruitName, 1 From YourTable t
inner join
(
Select Distinct  Number From Master..spt_values
Where Number >0
) as  i
on t.qty >= i.number

<div>
<div class="content wysiwyg-content">
I have table1 with 2 columns (FruitName, Qty) see the sample data.<br />
<br />
FruitName &nbsp; &nbsp; &nbsp;Qty<br />
Apple &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4<br />
Orange &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<br />
<br />
I need a way to insert the above data into table2 (FruitName, Qty) so that the quantity equates to a record. &nbsp;So, in the case of Apple with the quantity of 4, I need table2 to have 4 records for apple, with the updated qty of 1.<br />
<br />
FruitName &nbsp; &nbsp; &nbsp;Qty<br />
Apple &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
Apple &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
Apple &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
Apple &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
Orange &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
Orange &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
<br />
thanks,<br />
sopheak<br />
<br />
<br />
<br />
<br />

</div>
</div>


I have table1 with 2 columns (FruitName, Qty) see the sample data.

FruitName      Qty
Apple             4
Orange          2

I need a way to insert the above data into table2 (FruitName, Qty) so that the quantity equates to a record.  So, in the case of Apple with the quantity of 4, I need table2 to have 4 records for apple, with the updated qty of 1.

FruitName      Qty
Apple             1
Apple             1
Apple             1
Apple             1
Orange          1
Orange          1

thanks,
sopheak






Multiply a record based on a field?

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.