Mr Reddy,

You are in a much better position to determine which solution performs better, as I do not have access to your "millions" of member rows and "thousands" of receipt rows.

What I suggest you do is create a test harness something like this:

DECLARE @StartTime DATETIME;

BEGIN TRANSACTION T1;

SELECT @StartTime = GETDATE();

-- Insert your code

SELECT StartTime=@StartTIme, EndTime=GETDATE()

,ElapsedTimeMS=DATEDIFF(millisecond, @StartTime, GETDATE());

ROLLBACK TRANSACTION T1;

BEGIN TRANSACTION T1;

SELECT @StartTime = GETDATE();

-- Insert my code

SELECT StartTime=@StartTIme, EndTime=GETDATE()

,ElapsedTimeMS=DATEDIFF(millisecond, @StartTime, GETDATE());

ROLLBACK TRANSACTION T1;

And then let us know which did best.

Note that I don't think either solution is going to be particularly swift if you don't have PRIMARY KEYs and/or indexes on your tables.