SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Round robin select query
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Rafiq-rafiq
Starting Member

India
2 Posts

Posted - 04/12/2013 :  05:57:35  Show Profile  Reply with Quote
Hi friends ,
I have a table dbo.test
with columns sno and name
SNO NAME
1 A
2 B
3 C
4 D

when i refresh the page or press f5 in sql server the last record should come first like below
when page is refreshed
SNO NAME
4 D
1 A
2 B
3 C

again when f5 is pressed then
when page is refreshed
SNO NAME
3 C
4 D
1 A
2 B

again when f5 is pressed then
SNO NAME
2 B
3 C
4 D
1 A
again when f5 is pressed then
1 A
2 B
3 C
4 D

i tried my best but not geting any solution yet..could u help me out in this ?

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 04/12/2013 :  07:14:51  Show Profile  Reply with Quote
when i refresh the page or press f5 in sql server..

which page? do you mean ssms query window?


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Rafiq-rafiq
Starting Member

India
2 Posts

Posted - 04/12/2013 :  09:22:19  Show Profile  Reply with Quote
when i press f5 in sql server to run the query .i should get the data in round robin logic way..
Go to Top of Page

MIK_2008
Flowing Fount of Yak Knowledge

Pakistan
1050 Posts

Posted - 04/12/2013 :  11:03:02  Show Profile  Reply with Quote
Do you need this for any application? If yes, why don't you handle it on front end?

Cheers
MIK
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 04/12/2013 :  14:23:18  Show Profile  Reply with Quote
it should done at front end by means of parameter.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000