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,

---

Do you know clustered and non-clustered index?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  

---

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

---

How to recompile stored procedure at run time?

0 Answers  

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

What is key set driven?

0 Answers  

---

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

---

What is difference between joins and subqueries?

0 Answers  

---

What is the use of sign function?

0 Answers  

---

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---