Random Rows in Respect to Their Priorities

I need to build an SQL query, which generates the random rows priority wise.

I found this on following article.

http://articlesdotnet.blogspot.com/2...-to-their.html

Can anyone test it?

In addition, tell me.

Is it good or have a bug?

If anyone have the better query then please tell me.

Heuh? What's up with this? Why don't *you* try it out and tell *us* whether it's good.

You are not an alias for http://p2p.wrox.com/pop_profile.asp?...splay&id=66067, try to promote your articles, are you?

It's quite a coincidence that in both cases (e.g. /Article3378.aspx and /Article3388.aspx) you post within a day of the release of the original article on dotnetspider.com asking us to read it. What's even more odd, is that in this Wrox post, you initially referred to that other article (Article3378), before you edited it ti this new article about random stuff. Quite a coincidence, don't you think?

If I am completely wrong (quite possible), then: please read the article yourself, and tells us if it's good.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004