est table ( info_id , seq_no , znachenie (string v varchar )
info_id u seq_no - primary key


naprimer:

info_id seq_no znachenie ( v varchar )
28 1 kaaia-to string...
28 2 chto-to tyt...
28 3 ........

40 1 .....
40 2 ......
etd


(ran"she bilo info_id i znachenie v formate TEXT , ia ego razbil
na neckol'ko znachenii v varchar ( po 200 ) chtobi legche bilo c text rabotat" vot i polychiloc" neckol"ko sequences dlia
kashdogo info_id )
etd

v pole znachenie ia ishy chactoty vxoshdenia kakogo-to clova ( algoritm otrabotan) ,
bydem chitat'- procto summiryu chto-to
dopyctim ia nashel dlia
info_id = 28 u seq_no = 1 - eto 2
info_id = 28 u seq_no = 2 - eto 1 etd



mne nado chtobi eta cymma chitalac" ( summirovalac" po seq_no v ramkax odnogo info_id )

takim obrazom mne nado polychit" dlia kashdogo info_id odno znachenie ( mne nado procymmirovat" chactoty vxoshdenia
po vcem seq_no )

voproc : kak cdelat?
neysheli 2 cursors nado otkrivat" ??

ecli bi instrykcia for i=1 to N rabotala ...



pocobetyite pls !!!!!!!!

Pandre , cpacibo vam bol"shoe !


cozdal UDF , no ne mogy dognat" kak cdelat" :

select info_id , sum(dbo.fcount(@D,@string_2)) from Table1 group by info_id

gde @D eto tekyshaia stroka a @string_2 eto to chto ishem
mne nado proiti po tablice curcorom

znchit kyrcor nado otkrivat" i v cikle vizivat" ety UDF ???

pomogite pls

no y menia 2 parametra :

1 - gde ickat"
2 - chto ickat"