TOP 100 PERCENT doesn’t work within a VIEW

(Vadivel) Way back in 2003, I wrote a blog post titled “Is sorting possible in views?”. I came to know that by using TOP 100 PERCENT in our SELECT query we can make use of ORDER BY clause within a VIEW. I tested that out in a SQL Server 2000 machine. But till date I have never used that in any of th

Read More - Register for Free Membership