SQL programming quesion

What logic do you use when you have a column that says there are X items and I want to insert the information on those X items into another table. If I did it in another programming language I would program it as follows:

If "X items" > 1 Then
{

    For i = 1 to "X items"
    {

        Insert A
    }
}

What I need to do is find all the columns of this table where X is greater than 1 and when I find those coulumns I would like to insert the information from that record X number of times into another table. How can I do the above using SQL? If you respond to this post could you also please reply to my email address at
julie15ann_at_aol.com

Thanks

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Aug 08 1999 - 17:59:30 CDT