cant use XML value in anotehr stored proc

See more:

SQL-server-2000

SQL-Server

hi,

Please help me..

I have 2 SP's. P1 and P2.
P2 is called from P1
P1 also sends an XML variable to P2.
But when I am display the value of XML (which has 5 records), it is just showing the last records..
please tell why. I am gonna loose my job.Frown Frown Frown

here is the code.

alter proc p1
declare @myxml XML
as
begin
select @myxml= firstname from table1
exec p2 @myxml
end

proc 2 goes here :

alter proc p2(@xx XML)
as
begin
select @xx
end