Also Tried

DECLARE @TBLXML TABLE (COL1 XML NOT NULL);

INSERT INTO @TBLXML(COL1)

EXEC [dbo].[bofa_sp_esb_sel_acc]

@SearchType = N'A',

@SearchInputList = N'57575757',

@FAsInputList = null

Error :-

Msg 6819, Level 16, State 5, Procedure rj_sp_esb_sel_acc, Line 712

The...

DECLARE @XMLT XML = '<AccountDetail>

<Account>

<AccountNumber>12345678</AccountNumber>

<ShortName>john</ShortName>

.........................

here i need

Declare @XMLT XML = (Result XML column from storedprocedure)

i,e

Declare @XMLT...

The storedprocedure returns just 1 column and its xml

so this is what i was trying to do

create a temp table

CREATE TABLE #XMLwithOpenXML

(

Id INT IDENTITY PRIMARY KEY,

XMLData xml...

Thanks for the inputs

this is what i am trytig to do

Exec stored proc

result = Col1 (XML)

now how do i capture this into a variable and...

i cant pivot it , the same parameters that go into the storedproc also go into a webservice which returns a response and i have to validate the storedprocedure response...

good question mister.magoo

i would if i could , i do not have permissions to create or alter the procedure

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 =...

did try

DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX)

SELECT @XML = XMLData

FROM #XMLwithOpenXML

EXEC sp_xml_preparedocument @hDoc OUTPUT, @XML

SELECT AccountNumber,ShortName

FROM OPENXML(@hDoc,'//Account')WITH

(

AccountNumber [varchar](50) '@AccountNumber',

ShortName [varchar](100) '@ShortName'

)

EXEC sp_xml_removedocument @hDoc

GO

but...

Thanks for the response Guys , i guess i was posting in an inappropriate thread.

i did try other methods but no luck

i guess i shall try posting in the...

Never mind i just got it worked

sorry i forgot to mention the data types

col1 is varchar

col2 is int

col3 is varchar

i did try in some ways ... but was having trouble achieving it

thanks for all the help guys , i figured it out ,

i took all the distinct values of one column and put them in a temp table and added...

thanks for all the help guys , i finally figured it out

regards

greg

i have 75 guids that are distinct and the records associated to that 75 records are also distinct and the rest 85 are not distinct (assuming there are total...