I am trying to write a query that does two things. Can select top 1% or top 100% based on a variable. And two does a dirty read.

Right now I am doing dirty read with For Fetch ONLY. I want(Think) to add "fetch first 1% rows only for fetch only".

I was thinking it may be possible to write the query twice as an A and B query with a fetch top 1 and w/o fetch top 1 and having the depending on some variable....