the result was

<Empl ID="1"><Name><Fname>john</Fname><Lname>smith</Lname></Name></Empl><Empl ID="2"><Name><Fname>Paul</Fname><Lname>Jackson</Lname></Name></Empl>

and i seek the next format

<table>

<row>

<id>1</id>

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

......

</row>

</table>

the update find the register and then blockes or block the table while is trying to find it ??? if  that is the first  i dont need to use the...

thanks friend , i need to maintenance a report which is built with a store procedure, if a caption changes on the web interface, (those captions are stored into a system...

Sorry my bad english well, i want to the first option, i am looking to name the result column with the caption which is defined into field from a Table,

Thanks friends i have resolved my problem,finally i did a Excel Macros, with a userform which one inputs the parameters, then using the next code to update my pivottable

ActiveSheet.PivotTables(1).TableRange2.Select

     Workbooks(1).ActiveSheet.PivotTableWizard...

Yes, you understood my problem, thanks friend i will try your wise, although the export external data needs to configure a sql driver, for me is not very optimal, because...

well but the name of table variable appears like a name of pointer to memory in my tempbd when it is declared, or my server's memory is not avaible or...

well nothing because you uses '@' for the create table , so fixed that i saw the var temp name #7F16D496 , yes i...

In my sql your query not appears the name of var temp into list and in my query appears the name of temporal table #temp into list

My query :

select...

Run this

select * from tempdb..sysobjects

create table #temp ( a int)

select * from tempdb..sysobjects

what do you see?

i refered to a temporal table and not to var temp table

Thanks

i have done a test and when i created a temp table i watched the table's name appears into tempbd, but then the temp tables always write into...

interesting i dont know that sql server implicitly converts it into a temporary table anyway when the table variable gets too large, but what do you call too large? millons...

very interesting , thank you for your tips, i will try to do my operation using variable table, but now i have the next question, i know that variable table...

because is better than write code to evaluate the output variable of my system

example

sp_responsesclient @icode1 out put,

...

if you can give me a example i will be grateful meanwhile i will see it thank you very much