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)