Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
create table Catch22(rowid int identity(1,1), data varchar(80)) GO insert into Catch22 select 'abc' insert into Catch22 select 'yyz' insert into Catch22 select 'pdq' insert into Catch22 select 'xyz' insert into Catch22 select 'cat' GO create view vCatch22 as select top 100 rowid, data from Catch22 order by data GO select * from vCatch22 GO ------ The above works as expected, but using top PERCENT below does not ... why? ------- alter view vCatch22 as select top 100 PERCENT rowid, data from Catch22 order by data GO select * from vCatch22 GO -- create unique clustered index x1 on Catch22(data,rowid) -- this works, but is not applicable in my real scenario drop view vCatch22 truncate table Catch22 drop table Catch22 --
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.