Firstly, I would recommend a quick read of the below as a refresher:
http://technet.microsoft.com/en-us/library/ms186992(v=sql.105).aspx
I would change your code to the below:
WHERE
( ct.AlertedDate between @startdate and @enddate OR ct.[Dispo] = @STdrp )
AND
isnull(QC.Class,'BB') = @class
AND
ct.[AcceptStatus] = @STdrp
ORDER BY ct.[AlertedDate]
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn