Groups > comp.databases.ms-sqlserver > #1927

WHILE LOOP AS FOR LOOP

X-Received	by 10.66.250.201 with SMTP id ze9mr31447321pac.20.1438178287980; Wed, 29 Jul 2015 06:58:07 -0700 (PDT)
X-Received	by 10.140.104.147 with SMTP id a19mr573425qgf.2.1438178287894; Wed, 29 Jul 2015 06:58:07 -0700 (PDT)
Path	csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!f3no4471509igg.0!news-out.google.com!b31ni1108qge.0!nntp.google.com!69no2619209qgl.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Wed, 29 Jul 2015 06:58:07 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=190.104.153.107; posting-account=VrDeogoAAACDgQd3w0z6TPAA82cnrCLk
NNTP-Posting-Host	190.104.153.107
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<d5581480-cb05-4b19-8f82-995f7bfe01e3@googlegroups.com> (permalink)
Subject	WHILE LOOP AS FOR LOOP
From	Jessica González <jess.rgm@gmail.com>
Injection-Date	Wed, 29 Jul 2015 13:58:07 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1927

Show key headers only | View raw

its possible? 

For each id in (SELECT * FROM table)
     INSERT INTO table2(id,fk,nombre)
        values(1,id,'xxx');

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

WHILE LOOP AS FOR LOOP Jessica González <jess.rgm@gmail.com> - 2015-07-29 06:58 -0700
  Re: WHILE LOOP AS FOR LOOP Erland Sommarskog <esquel@sommarskog.se> - 2015-07-29 14:04 +0000
    Re: WHILE LOOP AS FOR LOOP Jessica González <jess.rgm@gmail.com> - 2015-07-29 07:31 -0700
      Re: WHILE LOOP AS FOR LOOP Erland Sommarskog <esquel@sommarskog.se> - 2015-07-29 15:44 +0000
        Re: WHILE LOOP AS FOR LOOP rja.carnegie@gmail.com - 2015-07-29 10:03 -0700
  Re: WHILE LOOP AS FOR LOOP --CELKO-- <jcelko212@earthlink.net> - 2015-08-14 17:54 -0700

csiph-web