Naomi,

thank you for the help

Agnes
>>Why - this works
>>
>>

>>	create cursor xx (Id I )
>>	insert into xx values(0)
>>	
>>	
>>	select b0+b1+b2+b3+b4+b5+b6+b7 as seq ;
>>		from (	select cast( 0 as int) As b0 from xx ;
>>			union select cast( 1 as int) from xx  ) B0, ;
>>			(	select cast( 0 as int) As b1 from xx ;
>>			union select cast( 2 as int) from xx  ) B1, ;
>>			(	select cast( 0 as int) As b2 from xx ;
>>			union select cast( 4 as int) from xx  ) B2, ;
>>			(	select cast( 0 as int) As b3 from xx ;
>>			union select cast( 8 as int) from xx  ) B3, ;
>>			(	select cast( 0 as int) As b4 from xx ;
>>			union select cast( 16 as int) from xx  ) B4, ;
>>			(	select cast( 0 as int) As b5 from xx ;
>>			union select cast( 32 as int) from xx  ) B5, ;
>>			(	select cast( 0 as int) As b6 from xx ;
>>			union select cast( 64 as int) from xx  ) B6, ;
>>			(	select cast( 0 as int) As b7 from xx ;
>>			union select cast( 128 as int) from xx  ) B7 ;
>>		order by 1
>>

>
>Your table is much smaller, than Boris' <g>