valeryk2000 (6/6/2014)

---

Sean Lange (6/6/2014)

---

valeryk2000 (6/6/2014)

---

2008

Not big on providing details today I see. What does this query return?

select @@VERSION

The bottom line is that there are hotfixes out there to deal with this. You were told this in this thread and the original place you posted your question. Hit up your favorite search engine and enter the error message you see and will find the Microsoft hotfixes in the top 10 or so results. Or if you don't want to search for it try this link. http://bit.ly/1i90Ukx

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2) (VM)

Interestingly this problem exists ONLY when tblClinicalReview is on the right side of intersect. All other tables that use this field ClinicalReviewID are OK with order by. Anyway it looks that my concern re order by in intersect is not a "intersect" issue, just a peculiarity of my table

Thanks