1. First To create the following table.

Create table NewNew(sno int identity(1,1) primary key,   
names varchar(100))

2. To INsert the record one by one

Insert Into NewNew Values ('A')
Insert Into NewNew Values ('B')
Insert Into NewNew Values ('C')
Insert Into NewNew Values ('D')
Insert Into NewNew Values ('F')

3. To view the records first

Select * From NEwNew

4. To create the following procedure

Create Proc New1	
As
Begin
	Declare @names varchar(100)
	Declare @sQuery  Varchar(7000)
	Declare @sQuery1  Varchar(1000)
	Declare @ans varchar(8000)
	Declare @i int
	Declare  cur cursor for select names from newnew
	Open cur
	Set @i = 1
	Set @sQuery1 = ''
	Set @sQuery = ''
	fetch next from cur into @names
	While @@fetch_status=0
		Begin
			Set @sQuery1 = '(Select Top 1 names 
from newnew where names in (select top '+ convert(varchar
(3),@i) +' names From newnew order by 1 Asc) order by 1 
Desc) As names,' 
			Set @sQuery = @squery + @squery1
			Set @i = @i + 1
			Fetch next from cur into @names
		End	
		Set @ans = Convert(varchar(6),'Select ') + 
Left(@sQuery,Len(@sQuery)-1)	
		Exec (@ans)		
	Close cur
	deallocate cur
End 

5. To execute the procedure 
now to view the output Ok

Exec New1


By
Kumar.T

Select case when 1 then 'A'
when 2 then 'B'
when 3 then 'C' end as Name from tablename

Hello Mr.B 

In my table contain 100 record is there. at present what 
you are doing?

select list(name) from table_name

declare @tst varchar(max)
set @tst=''
select @tst=@tst+col+',' from table
select @tst

there is a twist, if col contains any null value then this
query will return null. use isnull(col,'') in that case

;WITH ABC (no, name) AS
(
    SELECT 1, CAST('' AS VARCHAR(8000)) 
    UNION ALL
    SELECT B.no + 1, B.name +  A.name + ', ' 
    FROM (
SELECT Row_Number() OVER (ORDER BY no) AS no, name FROM 
emp1) A 
    INNER JOIN ABC B ON A.no = B.no 
)
SELECT TOP 1 name FROM ABC ORDER BY no DESC

declare @res varchar(max)

set @res=''

select @res=@res+name+',' from table 

select @res=substring(@res,1,len-1)

print @res