• 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