Answer Posted / prakash

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'


SELECT cityid,
max(CASE P.ContinuationID WHEN 1 THEN
P.CITYNAME ELSE '' END) AS Name1,
max(CASE P.ContinuationID WHEN 2 THEN
P.CITYNAME ELSE '' END) AS Name2,
max(CASE P.ContinuationID WHEN 3 THEN
P.CITYNAME ELSE '' END) AS Name3
FROM CITY AS P
GROUP BY P.cityid

how to avoid cursors? : Sql server database administration

1013

---

How many types of stored procedures are there in sql server?

1057

---

What is the report model project?

151

---

How to get all stored procedures in sql server?

1059

---

Explain syntax for dropping triggers?

969

---

How to create an index on a view?

1140

---

How to concatenate two binary strings together?

1175

---

what is difference between view and Dip.

2456

---

How to generate create table script on an existing table in ms sql server?

1196

---

How exceptions can be handled in sql server programming?

1075

---

Do you know the policy based administration feature of sql server 2008?

1002

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1104

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1098

---

Tell me in brief how sql server enhances scalability of the database system?

1040

---

How to create function with parameter in sql server?

1158

---