Hi guys thank you for your reply, I created below CURSOR and its work fine,

DECLARE @sidint

Declare InsertSID Cursor For

Select DISTINCT Sid from MDB

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

AND SID NOT IN (SELECT SID FROM MRequest )

OPEN InsertSID

FETCH NEXT FROM InsertSampleID

INTO @sid

WHILE @@FETCH_STATUS = 0

BEGIN

IF (@SID <> 0)

BEGIN

EXEC [INSERT_SP] @sid

END

Fetch Next from InsertSID

into @sid

END

close InsertSID

deallocate InsertSID

IS any one have better idea, Please share with us.

Thank You.