Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

there is a table having two columns no and name
and the data is
1 A
2 B
3 C

write a query that will result a horizontal output
A,B,C

Question Posted / kumar_kisna

Answers were Sorted based on User's Feedback



there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / utsav

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

Is This Answer Correct ?    5 Yes 1 No

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / kumar.t

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

Is This Answer Correct ?    2 Yes 1 No

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / miller

try using Pivot. for details follow the link
http://msdn.microsoft.com/en-us/library/ms177410.aspx link

Is This Answer Correct ?    1 Yes 0 No

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / rajesh.a

declare @res varchar(max)

set @res=''

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

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

print @res

Is This Answer Correct ?    1 Yes 1 No

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / piyush sachan

DECLARE @List VARCHAR(8000)
SELECT @List = ISNULL(@List + ',', '') +names
FROM NewNew

SELECT @List

Orrrrrr

DECLARE @List VARCHAR(8000)
SELECT @List = COALESCE(@List + ',', '') +names
FROM NewNew

SELECT @List

Is This Answer Correct ?    0 Yes 0 No

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / senthil kumar murugan

;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

Is This Answer Correct ?    1 Yes 2 No

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / kumar.t

Hello Mr.B

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

Is This Answer Correct ?    0 Yes 2 No

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / b

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

Is This Answer Correct ?    0 Yes 3 No

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query t..

Answer / narendra biyani

select list(name) from table_name

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL Server Interview Questions

What is bit data type?

0 Answers  

what is hash nonclustered index

0 Answers  

What is tcl in sql server?

0 Answers  

How secure is sql server database?

0 Answers  

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

What is sleeping status in sql server?

0 Answers  

How many clustered indexes there can be on table ?

0 Answers  

How to add additional conditions in SQL?

0 Answers   Amdocs,

Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers  

What is the xml datatype?

0 Answers  

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories