issue with "Order by" clause

One more doubt, does the query really needs EXCEPT clause?

The below query alone would give the desired results, am I right?

SELECT  [TableName] ,[ColumnName],[RecordId],[ReasonDesc]  
FROM [GlobalIndex].[dbadmin].[DataValidation]
where   CreateDate >= '28-Jun-2013'
and CreateDate < '29-Jun-2013'

Then the query will have only one scan on the table.

---

Thanks

Sarat



Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.