Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 12029 Views
- tdfc, vsworx, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is dirty page?
How to replace the Query Result 'Null Value' with a text ?
What do you understand by replication in sql server?
How to make remote connection in database?
How to drop an existing stored procedure in ms sql server?
What is a schema in ms sql server 2005?
What is the need for group functions in sql?
What is ems sql management studio? : sql server management studio
What is the dbcc command and why is it used?
Explain candidate key, alternate key, and composite key?
How to identify current user in ssrs report?
How important do you consider cursors or while loops for a transactional database?
What is normalization and what are the advantages of it?
What is hot add cpu in sql server 2008?
What are ddl triggers and types of ddl trigger?
