Places to visit in Mumbai

Mumbai is the capital of Maharashtra and one of the metro cities of India but more prominently known as the busiest financial hub since centuries. This is because of its geographic location and consistent weather round the year. Mumbai was also known as the Gateway of India in ancient times.

Mumbai is also a popular tourist destination and thousands of tourists visit Mumbai from all over the world.

There are several interesting places to visit in Mumbai. The most popular places to explore are highlighted in below map that you can carry along with your tour:

Dozens of tourist destinations can be explored in Mumbai that can be categorised into amusement parks, lakes, caves, film studios, forts, hotels, malls, museums, places of worships, etc.

SQL: Using Loop instead of Cursor

Sample 1:
~~~~~~
Declare @temp table
(
row_id int identity (1,1),
product varchar(50)
)

Declare @i int, @max int

Insert into #temp (product) Select product From products

set @max = @@rowcount
set @i = 1

While @i <= @max Begin Select product From #temp Where row_id = @i // Do your Processing here set @i = @i + 1 End Sample 2:
~~~~~~
DECLARE @Product VARCHAR(50)
DECLARE @ProductID INT -- I assume Product ID as primary Key

SELECT * INTO #Products FROM Products

WHILE EXISTS (SELECT * FROM #Products)
BEGIN
SET ROWCOUNT 1
SELECT @ProductID = ProductID, @Product = Product FROM #Products
SET ROWCOUNT 0

// Do your Processing here

DELETE #Products WHERE ProductID = @ProductID
END