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,

---

How to find the date and time of last updated table?

3 Answers  

---

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

---

What do we have to check in database testing?

0 Answers  

---

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

Is the primary key column of a table an index in ms sql server?

0 Answers  

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  

---

What is Covering Indexes? Plz explain with example

3 Answers  

---

What is merge replication?

0 Answers  

---