>>322
再帰やストアドなんて要らんでしょ
>>318 の結果を得たいだけなら

select
　T1.NO, T1.A,
　(
　　select min(T3.NO) as NO
　　from T as T3
　　where T1.NO < T3.NO and T1.A <> T3.A
　) - T1.NO as [連続数]
from T as T1
inner join T as T2 on T1.NO - 1 = T2.NO and T1.a <> T2.a
where T1.A = 1

で十分でしょ (わかると思うけど表名は T ね)