Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-31 : 07:19:04
|
| Jaya writes " Hhow to use orderby clause when the result is returned in xml format. I have a nested query which returns xml format." |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-10-31 : 08:04:28
|
| Something like this maybe taken from BOL :SELECT Employees.EmployeeID, LastName, FirstName, OrderID, OrderDate, Orders.EmployeeIDFROM Orders, EmployeesWHERE Orders.EmployeeID = Employees.EmployeeIDORDER BY Employees.EmployeeIDFOR XML AUTO |
 |
|
|
|
|
|
how to use orderby clause when the result is returned in xm