Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

can an order by clause be used in a creation of a view?

0 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What language is sql server written in?

0 Answers  

---

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

What is the default value of CHAR type?

10 Answers   Bosch,

---

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

---

Can a table be moved to different filegroup?

0 Answers  

---

does physical index sort data

1 Answers  

---

What is Transaction?

2 Answers  

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---