X-Received: by 10.129.104.87 with SMTP id d84mr16955948ywc.55.1439600053161; Fri, 14 Aug 2015 17:54:13 -0700 (PDT) X-Received: by 10.182.24.35 with SMTP id r3mr231330obf.38.1439600052951; Fri, 14 Aug 2015 17:54:12 -0700 (PDT) Path: csiph.com!xmission!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!69no1107039qgi.0!news-out.google.com!o13ni15831igw.0!nntp.google.com!se8no3999902igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-sqlserver Date: Fri, 14 Aug 2015 17:54:12 -0700 (PDT) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=2602:306:bcf4:c240:3db8:1364:efe6:a019; posting-account=eTE9_AoAAAD1dS9O9Ccywd_vfKFzS40A NNTP-Posting-Host: 2602:306:bcf4:c240:3db8:1364:efe6:a019 References: User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: WHILE LOOP AS FOR LOOP From: --CELKO-- Injection-Date: Sat, 15 Aug 2015 00:54:12 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Received-Bytes: 1489 X-Received-Body-CRC: 3026320270 Xref: csiph.com comp.databases.ms-sqlserver:1937 Your mindset is wrong. SQL is a declarative language and does not use proce= dural constructs. Things happen "all at once" in whole sets, not in sequent= ial steps. This means we have no loops. A classic book on this topic is Pet= er Henderson's FUNCTIONAL PROGRAMMING.