Thanks shusilla

what i m doing is i m converting whole ASP page business logic into SQL server programming for performance issue.

as recordsset in asp im  using cursor in sqlserver

for that only...