rocky_498 (9/20/2012)

---

Once again thanks and i understand what you saying, Here is the PROBLEM.

I can't convert or paste my store procedure here (8 Pages S.P) lot of logic involve....

If i run this query

Select DISTINCT Sid from MDB

where ADate = dateadd(day,datediff(day,1,GETDATE()),0)

AND SID NOT IN (SELECT SID FROM MRequest )

and i get SID > 0

THEN run this S.P

EXEC [INSERT_SP] @sid

When you are saying you do NOT need Cursor, Ok. Could you please tell me what else should i use to

accomplish this task. I know cursor is dam slow if i get more SID in my first query.

I know i have to provide Sample data/Sample code with insert statment and everything, but in this case

i am sorry i am not providing all information that you need.