"Insert" trigger to insert muliple lines into 2nd table 1

[jtarry]

I have a table which contains a quantity value (say 3)

table 1
Part Qty
AAA 3

I want to insert into table 2 via a trigger

Part Value
AAA 1
AAA 2
AAA 3

thanks

 

[PWise]

Create A digits table

DigitID
1
2
3
4
5
.....
1000000

insert int Table2(Part,Value)
Select Part,Digitid As Value
From Table
inner join Digits
on qty <=Digitid

 

[djj55]

By the way you may want to look at INSTEAD OF triggers

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!