quote:

---

Originally posted by visakh16

will it be always 3 Warehouses max?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by visakh16

see

http://www.sqlteam.com/article/parsing-csv-values-into-multiple-rows

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

SELECT Date,PARSENAME(REPLACE(Warehouse,',','.'),1) AS WareHouse,PARSENAME(REPLACE(BegBalance,'/','.'),1) AS BegBalance
FROM table

UNION ALL

SELECT Date,PARSENAME(REPLACE(Warehouse,',','.'),2),PARSENAME(REPLACE(BegBalance,'/','.'),2)
FROM table
WHERE PARSENAME(REPLACE(Warehouse,',','.'),2) IS NOT NULL
OR PARSENAME(REPLACE(BegBalance,'/','.'),2) IS NOT NULL

UNION ALL

SELECT Date,PARSENAME(REPLACE(Warehouse,',','.'),3),PARSENAME(REPLACE(BegBalance,'/','.'),3)
FROM table
WHERE PARSENAME(REPLACE(Warehouse,',','.'),3) IS NOT NULL
OR PARSENAME(REPLACE(BegBalance,'/','.'),3) IS NOT NULL