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 does recursive cte works in sql server?

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

What is database isolation in sql server? : sql server database administration

0 Answers  

---

---

What are cursors stored procedures and triggers?

0 Answers  

---

Is it possible to have clustered index on separate drive from original table location?

0 Answers  

---

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

---

Explain microsoft sql server functions?

0 Answers  

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

Why functions are used in sql server?

0 Answers  

---