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

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

978

---

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

994

---

Write a program to fetch first 10 records from a file?

988

---

How to rebuild all indexes on a single table?

1040

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

990

---

Why does sql studio use a single registered database repository? : sql server management studio

982

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

999

---

How to join two tables in a single query in ms sql server?

979

---

What is report snapshot in ssrs?

264

---

How to convert character strings into numeric values?

1078

---

How to create a large table with random data for index testing in ms sql server?

1012

---

What are “lost updates”?

982

---

Explain the difference between HTTP and HTTPS in database?

1014

---

What is the maximum size per database for sql server express?

1025

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1127

---