Re: SQL Range of numbers in steps

On 31 mar, 15:52, "Larry D" <rhodyma..._at_yahoo.com> wrote:
> I need to run a report on numbers in a range of numbers.
> Each one increments 8 from the last.
>
> For example:
>
> 10000
> 10008
> 10016
> etc.
>
> There are thousands of these numbers and it would not
> be worth my time to enter each of these individually.
>
> How do I do a search in SQL with this?
>
> I have programmed with other computer languages, so
> I know about for, next, step. . .
>
> I am using Viewpoint SQL and Microsoft Windows 2000.
>
> Thank you in advance for your help.

Seems to me as a presentation issue. I suggest you use tools such as Analysis Services to get your OLAP cubes set up first. The primary purpose is not to present data a certin way but to extract the precise data you seek. Received on Sat Mar 31 2007 - 18:10:57 CEST