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

Re: Assigning Display Lines to Date Ranges

From	Michael Cole <invalid@invalid.com>
Newsgroups	microsoft.public.sqlserver.programming
Subject	Re: Assigning Display Lines to Date Ranges
Date	2015-11-16 11:34 +1100
Organization	A noiseless patient Spider
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>

Show all headers | 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