Groups > microsoft.public.sqlserver.programming > #31283

Re: Assigning Display Lines to Date Ranges

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Michael Cole <invalid@invalid.com>
Newsgroups	microsoft.public.sqlserver.programming
Subject	Re: Assigning Display Lines to Date Ranges
Date	Mon, 16 Nov 2015 11:34:15 +1100
Organization	A noiseless patient Spider
Lines	13
Message-ID	<n2b87i$onu$1@dont-email.me> (permalink)
References	<n20m6u$kn7$1@dont-email.me> <XnsA550E759DB2DYazorman@127.0.0.1> <n2325h$ror$1@dont-email.me> <XnsA5519079CD9EYazorman@127.0.0.1> <XnsA551ED2F46FBAYazorman@127.0.0.1>
Mime-Version	1.0
Content-Type	text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding	8bit
Injection-Date	Mon, 16 Nov 2015 00:32:50 -0000 (UTC)
Injection-Info	mx02.eternal-september.org; posting-host="5ab04e74274105c4a6c81eb9c3e4dc06"; logging-data="25342"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18Zbm/nOpnYZp9tO56UIjHD"
X-Newsreader	MesNews/1.08.06.00-gb
Cancel-Lock	sha1:NoP/mFCq/E2X9qc/V7phxExQX/U=
X-ICQ	1701145376
Xref	csiph.com microsoft.public.sqlserver.programming:31283

Show key headers only | View raw

Erland Sommarskog submitted this idea :
> Here is a solution that uses set-based iteration. That is, it first 
> computes row numbers house. Then I iterate over the row numbers, so 
> that I can handle the first row for all houses in a single go, and
> then move on the second row.

Erland,

Thank you very much.  Works brilliantly and very quickly.  Much 
appreciated, and I also learnt a great deal from it.

-- 
Michael Cole

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Assigning Display Lines to Date Ranges Michael Cole <invalid@invalid.com> - 2015-11-12 11:25 +1100
  Re: Assigning Display Lines to Date Ranges Erland Sommarskog <esquel@sommarskog.se> - 2015-11-12 22:44 +0100
    Re: Assigning Display Lines to Date Ranges Michael Cole <invalid@invalid.com> - 2015-11-13 09:01 +1100
      Re: Assigning Display Lines to Date Ranges Erland Sommarskog <esquel@sommarskog.se> - 2015-11-13 14:12 +0100
        Re: Assigning Display Lines to Date Ranges Erland Sommarskog <esquel@sommarskog.se> - 2015-11-13 23:18 +0100
          Re: Assigning Display Lines to Date Ranges Michael Cole <invalid@invalid.com> - 2015-11-16 11:34 +1100
  Re: Assigning Display Lines to Date Ranges --CELKO-- <jcelko212@earthlink.net> - 2015-11-12 18:47 -0800

csiph-web