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

What are the steps to follow to configure SQL*Net?

990

---

How to provide values to user defined function parameters?

966

---

how to use DTS package in 2000,2005,2008 in sql server

1784

---

what is checksum in sql server.........???

1616

---

Explain mixed authentication mode of sql server?

988

---

How do you delete a data source?

952

---

Explain about system database?

998

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

933

---

Is mysql better than sql server?

1001

---

How each E-R model constructs can be mapped to the relational model?

920

---

Explain linked server in sql?

1146

---

What does it mean to manipulate data?

941

---

What are the components of sql server service broker?

944

---

Explain about merge replications?

963

---

Explain activity monitors

1001

---