CREATE TABLE #Products
(ProductId INT, UnitPrice DECIMAL(18,4));

INSERT INTO #Products VALUES
(1,201.75),
(2,33.4),
(3,98.77);

UPDATE p SET
    [UnitPrice] = [UnitPrice] * 1.05
FROM
    products AS p

UPDATE #Products SET UnitPrice = UnitPrice*1.05;

UPDATE #Products SET UnitPrice = UnitPrice*1.05
WHERE ProductId <= 2;

DECLARE @products TABLE (
	[ProductID] INT
	, [UnitCost] MONEY
	)

INSERT @products ([ProductID], [UnitCost]) VALUES
(1,201.75),
(2,33.4),
(3,98.77);


-- Display Products
SELECT * FROM @products

-- Update all prices by 5%
UPDATE p SET [UnitCost] = [UnitCost] * 1.05 FROM @products AS p

SELECT 'After all upped by 5%', * FROM @products

-- Update some list of prices by 5% (Products 1 and 3)
DECLARE @updates TABLE ( [ProductID] INT )
INSERT @updates([ProductID]) VALUES (1), (3)

UPDATE p SET [UnitCost] = [UnitCost] * 1.05
FROM
	@products AS p
	JOIN @updates AS u ON u.[ProductID] = p.[ProductID]
	
SELECT 'After 1 and 3 upped by 5%', * FROM @products

quote:

---

Originally posted by Vishal_sql

It means for solving any problem you have to think that I will solve the problem without using Cursor or while loop and try to do it in single query.( except some cases where should use cursor's eg:- SSRS queries)
Great comments Sunita and Charles.Thanks.
It would definately help me.

---

quote:

---

Originally posted by Vishal_sql

Hi Visakh ,
I Agreed on your comments.One will use the Cursor depending on the scenarios.
And m happy u jumped in between.
We were discussing When can we use Cusror and when can we use Set based approach.
I heard that reporting queries requires cursor as most of calculations cant be done in single queries.

---