Xref: alice comp.databases.oracle.misc:37986
Path: alice!news-feed.fnsi.net!news.idt.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: julie15ann@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: SQL programming quesion
Date: Sun, 08 Aug 1999 22:59:30 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 28
Message-ID: <7ol24f$av2$1@nnrp1.deja.com>
X-Article-Creation-Date: Sun Aug 08 22:36:24 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)
X-Http-Proxy: 1.1 x42.deja.com:80 (Squid/1.1.22) for client 171.212.188.242

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@aol.com

Thanks


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.