The new vs the old product needs to be chosen based on the "flag" .

If the product_ID or the product_ID_Group appears twice or 2 rows with 2 different flags...

Based on the help with the query I was trying to create a procedure/function as given below

Before I started to write the procedure or a function, I started doing...

Thank You!

The Students and grades was just an example to explain it.

Yes, the no. grades for a student are consistent.  I needed to take  the end result and then insert it...

Thank you! Ken that worked .

I am sorry, I did not look that this section was for SQL Server 2005 and posted this question.

I appreciate it if anyone can still help me

Is this the way it should be done?

DECLARE @x int

SET ROWCOUNT 1000

SET @x = 1

WHILE @x > 0

   EXEC sp_dboption 'EJ','Trunc. Log On Chkpt','TRUE'EGIN  

 DELETE FROM table WHERE conditions

 SET @x...