Hi please use this query which give you your required output ie, this query will update rows from productid 1 to 1500 in a loop.
Thanks in advance.
DECLARE @a INT
SET @a = 1
WHILE @a < 1501
BEGIN
exec sp_executesql N'update Products_TBL set Product_Price=(
SELECT sum(rn.Amount) / sum(rn.Quantity) AS Result
FROM Receipt_NoteDetalisTBL as rn
GROUP BY Product_Id
having rn.Product_Id=@a) where Product_Id=@a'
SET @a = @a + 1
END