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.