UFN_MKTCOMMON_NUMBERS
Returns [A] table of numbers within [A] given range.
Return
Return Type |
---|
table |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@MIN | bigint | IN | |
@MAX | bigint | IN |
Definition
Copy
create function dbo.[UFN_MKTCOMMON_NUMBERS]
(
@MIN bigint,
@MAX bigint
)
returns table
as
return (
with
[A] as (select convert(bigint, 0) as [N] union all select 0),
[B] as (select 0 as [N] from [A] as [A] cross join [A] as [B]),
[C] as (select 0 as [N] from [B] as [A] cross join [B] as [B]),
[D] as (select 0 as [N] from [C] as [A] cross join [C] as [B]),
[E] as (select 0 as [N] from [D] as [A] cross join [D] as [B]),
[F] as (select 0 as [N] from [E] as [A] cross join [E] as [B]),
[NUMBERS] as (select row_number() over (order by (select 1)) as [NUMBER] from [F] as [A] cross join [F] as [B])
select @MIN + [NUMBER] - 1 as [NUMBER]
from [NUMBERS]
where [NUMBER] <= @MAX - @MIN + 1)