thanks for your help Lynn

thanks for your time and sorry for my incomplete question,
here is sample data and desired result

DECLARE @test-2 TABLE
(
docdate  datetime
docID VARCHAR(1)
docno int
invno int

thanks for your reply.
is there any way to achieve this in SQL Server or any other tool to covert encoding of xmls grammatically.,
 some guys  advised me to upgrade...

62 views but no one have answer ?