For XML Auto, Elements

[David Brown]

SELECT     DeptName, EntityName, Entity, DeptNumber, EmployeeID, Emp_LName,
Emp_FName, HireDate
FROM         dbo.VP_Employee_Info
WHERE     (EmployeeID NOT IN
                          (SELECT     EMPLOYEEID
                            FROM          dbo.V_TrainingTestsPass
                            WHERE      TESTID = 7))
       and DeptNumber = 8181and HireDate < '4/14/03'

FOR XML AUTO,ELEMENTS

The name of the column that it returns is:
XML_F52E2B61-18A1-11d1-B105-00805F49916B

How do I change the name of the column?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com