Create Number Table on the flye (CTE)


;with mycte

as

(

select

0 as n

UNION ALL

select

n+1 from mycte WHERE n<100

)

,

mycte2 AS

(select CAST (a.n as nvarchar(3)) as n1, CAST (b.n as nvarchar(3)) as n2 from mycte a cross join mycte b)

SELECT

ROW_NUMBER()OVER(order by CAST(n1+n2 as int) ) as num from mycte2

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s