Answer Posted / sandeep modapathi

Hi all
Gopi Muluka is right... but here I'm posting one different
thing.. ie the out put will be like this

Only two columns

It uses a function for concatination

CityID CityName
1 SAN DIEGO
2 SAN FRANCISCO
3 CHICAGO
4 NEW YORK CITY


CREATE FUNCTION DBO.GROUP_CONCAT(@CITYID VARCHAR(100))
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @STRING VARCHAR(8000)
SET @STRING=''
SELECT @STRING=@STRING+' ' +CITYNAME FROM CITY
WHERE CITYID=@CITYID ORDER BY CONTINUATIONID
RETURN LTRIM(@STRING)
END

select distinct CITYID,dbo.GROUP_CONCAT(CITYID)as CityName
from city

How can you stop stored procedures from recompiling?

948

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1260

---

What is the cartesian product of the table?

1004

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1155

---

What is blocking?

1133

---

What is the simplest way to create a new database in ms sql server?

1051

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

1052

---

What is the purpose of data source?

1092

---

What is save transaction and save point?

1256

---

Do you know nested transaction?

1002

---

What is the difference between a stored procedure and a user defined function?

1066

---

State a few properties of relational databases?

1181

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

127

---

What are the key configuration files for sql server reporting services ?

171

---

How can I change procedure name in sql server?

1114

---