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

How use inner join in sql server?

1102

---

What are secondary xml indexes?

1007

---

Does windows server 2016 come with sql server?

915

---

Can a database be shrunk to 0 bytes, if not, why?

1079

---

Explain go command in sql server?

1008

---

What are the advantages of having an index on the sql server?

910

---

How to create a view with data from multiple tables?

996

---

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

981

---

What are different types of statement?

988

---

What is the difference between a unique key and primary key?

927

---

What is history table in sql server?

940

---

What is merge?

989

---

What are date and time data types in ms sql server?

1072

---

What are different type of Collation Sensitivity?

981

---

What are the character string functions supported by sql server 2005?

987

---