elham_azizi_62 (10/7/2012)
but i want to write function split inverse and no with cursor,please help me.
I'm a bit confused here. You use a split function that is a slow scalar UDF that uses a While Loop (the guts of a cursor). My recommendation would be to fix that bad boy first.
--Jeff Moden
Change is inevitable... Change for the better is not.