InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 18:08:13 GMT20http://www.sqlservercentral.com/Forums/Topic1408346-3077-1.aspxWorked an absolute treat! Thanks very much!!Thu, 17 Jan 2013 06:16:02 GMTs_osborne2http://www.sqlservercentral.com/Forums/Topic1408346-3077-1.aspxThis is the easiest way, though it may not work for what your actual query is but...[code="sql"]-- Test table with some rubbish dataDECLARE @Test TABLE( Names [varchar](20))INSERT INTO @TestSELECT 'Simon'-- Query returns but with XML_<GUID> aliasSELECT (SELECT NamesFROM @Test t FOR XML PATH ('Test') ) as Test[/code]Thu, 17 Jan 2013 06:13:49 GMTAllen Kinselhttp://www.sqlservercentral.com/Forums/Topic1408346-3077-1.aspx[code="sql"]/* If you're using SQL2005+ you could try something this */;WITH CTE ( Test ) AS ( SELECT Names FROM @Test t FOR XML PATH('Test') ) SELECT Test , CAST(Test AS XML) AS Test FROM CTE[/code]Thu, 17 Jan 2013 06:07:50 GMTrob_dalzellhttp://www.sqlservercentral.com/Forums/Topic1408346-3077-1.aspxHi,I want to alias the output of the following:[code="sql"]-- Test table with some rubbish dataDECLARE @Test TABLE( Names [varchar](20))INSERT INTO @TestSELECT 'Simon'-- Query returns but with XML_<GUID> aliasSELECT NamesFROM @Test t FOR XML PATH ('Test')[/code]So rather than a column header of XML_<GUID> I want to give it an alias of say 'Test' for sake of argument. I can't seem to get it. Anyone know how? I tried following an example from here: [url=http://social.msdn.microsoft.com/Forums/nl/sqlxml/thread/1605c722-6388-40ff-9ab5-a3817a1db81f]http://social.msdn.microsoft.com/Forums/nl/sqlxml/thread/1605c722-6388-40ff-9ab5-a3817a1db81f[/url] but I can't seem to get it to return. I always run into the error that says the is no name for column 1.Any help appreciated.Thanks,SimonThu, 17 Jan 2013 05:03:57 GMTs_osborne2