Answer Posted / gopi muluka

Using PIVOT operator we can achieve this in SQL 2005

CREATE TABLE CITY (CITYID INT, ContinuationID INT, CITYNAME
VARCHAR(50))
GO
INSERT CITY
SELECT 1 ,1, 'SAN'
UNION ALL
SELECT 1, 2, 'DIEGO'
UNION ALL
SELECT 2, 1, 'SAN'
UNION ALL
SELECT 2, 2, 'FRANCISCO'
UNION ALL
SELECT 3, 1, 'CHICAGO'
UNION ALL
SELECT 4, 1, 'NEW'
UNION ALL
SELECT 4, 2, 'YORK'
UNION ALL
SELECT 4, 3, 'CITY'
GO
SELECT CITYID, [1] AS NAME1,[2] AS NAME2,[3] AS NAME3, [4]
AS NAME4
FROM
(
SELECT CITYID,ContinuationID, CITYNAME
FROM CITY
) P
PIVOT
(
MAX(CITYNAME)
FOR ContinuationID IN
([1],[2],[3],[4])
) AS PVT
ORDER BY CITYID
GO
DROP TABLE CITY

How many tables can be joined in SQL Server?

1045

---

What is a view and what are its advantages?

1095

---

What are the restraints imposed on the table design by a merge replication?

1021

---

How to create indexed view?

1026

---

How to use wildcard characters in like operations in ms sql server?

1111

---

How to provide column names in insert statements in ms sql server?

1130

---

What is sql server transaction log file?

1035

---

What is replace and stuff function in sql server?

1050

---

What is the difference between executequery () and executeupdate ()?

1009

---

What are the underflow and overflow behaviors on float literals?

1098

---

what's sql server? : Sql server database administration

979

---

explain different types of joins? : Sql server database administration

957

---

What is stored in the mssqlsystemresource database? : sql server database administration

1012

---

Explain filtered indexes benefits?

989

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

1030

---