Thanks peter, this works perfectly.

Thanks Samuel, It works now. Silly me, I should figure out myself.

Hi,

Thanks for all reply. I am working on SQL server 2005. However, Samuel's solution does not work on my SQL server, which returns following error message:

Msg 4104, Level 16, State...

Hi,

Firstly, test table can be prepared as:

IF OBJECT_ID('dbo.TestData') IS NOT NULL

DROP TABLE dbo.TestData

CREATE TABLE dbo.TestData ...

Hello,

I recently had to use curosr to do a function in my work. Although I knew I should try to avoid cursor, but could not find a way. I wonder...