Updated Link:

http://www.afcc1.com/Examples/Images/sql/OpenXml/SQL_OpenXml_1.png

Updated Code..

Getting a different error now... i have arranged around with no luck

ALTER PROCEDURE

[dbo].[Users_Update_Phones_2]

@UserName

nvarchar(256) = null ,@SqldocPhone...

The PrimayKey is PhonesID.....

Here is a link to what the error looks like.. No matter what i do i get the same error.. I need to get this figured out...

I have come up with this but still get the same error about the x.Phone can not be used in this context

ALTER PROCEDURE

[dbo].[Users_Update_Phones_2]

@UserName

nvarchar

Thank you for the reply.. sweating over here trying to figure this out..

How do i merge this way into my design that i have now?

with the xml

thanks

erik

Thats nice... will have to give that a shot...

Thanks Wanderer  for the great overview!! THis will help me out alot...

thanks...

erik

Your info is very helpful.... I wasn't judging your answer... i just needed a little better explanation..

Dam again!