with fibo as (
select cast(0 as numeric(28,0)) as fibA, cast(0 as numeric(28,0)) as fibB, cast(1 as numeric(28,0)) as seed, cast(1 as numeric(28,0)) as num
union all
select cast(seed+fibA as numeric(28,0)), cast(fibA+fibB as numeric(28,0)), cast(fibA as numeric(28,0)), cast(num+1 as numeric(28,0))
from fibo
where num<100)
select fibA
from fibo
I will link a you tube video here in the next few days explaining what everything being done is.