thanks Eirikur Eiriksson
here is what i am looking for
my Storedprocedure returns an XML
Stored procedure
EXEC [dbo].[bofa_sp_esb_sel_acc]
@SearchType = N'A',
@SearchInputList = N'57575757',
@FAsInputList = null
Result is an xml
<AccountDetail>
<Account>
<AccountNumber>57575757</AccountNumber>
<ShortName>Grammer IRA</ShortName>
<CategoryCode>ret</CategoryCode>
<CategoryDescription>Retirement Account - RJ Custodian</CategoryDescription>
<CategorySequenceNumber>1</CategorySequenceNumber>
<Holder>
<FirstName>Delores</FirstName>
<MiddleName>M</MiddleName>
<LastName>Grammer</LastName>
</Holder>
</Account>
</AccountDetail>
i need to copy this storedproc results into temp table
and then convert the above xml into table
example
(Col1)accountnumber (Col2) shortname ........& so on and so forth
57575757, Grammer IRA ........& so on and so forth