declare @x table (ContactId int, FirstName varchar(50), LastName varchar(50), EmailAddress varchar(50))
insert into @x
	select 1, 'Gustavo', 'Achong', 'gustavo0@adventure-works.com' union
	select 2, 'Catherine', 'Abel', 'catherine0@adventure-works.com' union
	select 3, 'Kim', 'Abercrombie', 'kim2@adventure-works.com' 

select	(	select	name	[@Name], 
					value	[*]
			from	(	select	ContactId					[PK],
							cast(ContactID as varchar(50))	[ContactId], 
							FirstName					[FirstName], 
							LastName					[LastName], 
							EmailAddress				[EmailAddress]
						from	@x
					) d
			unpivot	(value for name in (ContactId, FirstName, LastName, EmailAddress)) t
			where PK = x.ContactId
			for xml path('Column'), type
		)
from	@x x
for xml path('Row'), root('File'), type

			where PK = x.ContactId
			order by case name
					when 'contactid' then 1
					when 'firstname' then 2
					when 'lastname' then 3
					when 'emailaddress' then 4
				end
			for xml path('Column'), type