Home Forums SQL Server 2008 T-SQL (SS2K8) How to use"Union ALL" to join sql queries each containing order by clause RE: How to use"Union ALL" to join sql queries each containing order by clause
Kingston Dhasian
SSCoach
Points: 19799
More actions
March 3, 2010 at 9:28 pm
#1128232
Remove the Order By Clause from the first statement and put it only in the last statement
How to post data/code on a forum to get the best help - Jeff Modenhttp://www.sqlservercentral.com/articles/Best+Practices/61537/