Thursday, August 28, 2014

How to create Percentile Table format


declare @val int=10

;with mycte as (

select 1 as i, 1 as i2, @val as i3
union All
select i+1, i3+1 as i2, i3+ @val i3 from mycte where i3<100

)
select * from mycte


No comments:

Post a Comment