Re: interesting problem

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 13:30:37 +0530

http://vyaskn.tripod.com/fun_with_numbers_in_t-sql_queries.htm 

-- 
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Lisa Pearlson" <no@spam.plz> wrote in message
news:%23oufRaQgEHA.536@TK2MSFTNGP11.phx.gbl...
> SQL7:
> Let's say I have a record that has the following 2 rows:
>
> N
> 1
> 7
>
> I want to create a VIEW that shows these two and all values in between:
> N
> 1
> 2
> 3
> 4
> 5
> 6
> 7
>
> Or, yet another related problem:
>
> a VIEW that shows the numbers 1 - 100.
> I guess this is not possible because. It would work easily in a stored
> procedure, but not a view.
> Too bad you can't call a stored procedure from within a view.
> It's very hard for me as a programmer to think only in terms of sets and
> selections.
>
> Lisa
>
>

Relevant Pages
Loading