what does the OUTER APPLY means and for what sake it is used in the query u have shared with me

I had tried al the replies what i had sent to u,please help me

create proc sp_DestAsiaHotelList_Temp

as

begin

declare @xml xml

set @xml= '<HOTEL>

<SEQNO>1</SEQNO>

<GRADE>5</GRADE> ...

it is showing errors like this

Msg 102, Level 15, State 1, Procedure sp_DestAsiaHotelList_Temp, Line 63

Incorrect syntax near '('.

Msg 319, Level 15, State 1, Procedure sp_DestAsiaHotelList_Temp, Line 97

Incorrect syntax near the...

i am trying like this with the code u have shared with me but it is getting some errors

create proc sp_DestAsiaHotelList_Temp

as

begin

DECLARE @XML XML = '<HOTEL>

<SEQNO>1</SEQNO>

<GRADE>5</GRADE>

...

Msg 102, Level 15, State 1, Procedure sp_DestAsiaHotelList_Temp, Line 10

Incorrect syntax near ','.

Msg 319, Level 15, State 1, Procedure sp_DestAsiaHotelList_Temp, Line 14

Incorrect syntax near the keyword 'with'. If this statement...

I had tried to write proceedure as below

create proc sp_DestAsiaHotelList_Temp

@xml xml

as

begin

declare @idoc int

exec sp_xml_preparedocument @idoc OUTPUT, @XML

insert into DestAsiaHotelList_Temp(HotelID, HotelName, StarRating, CityLocation, ResortCode, ResortName, HotelCode, Remark, Subservice, T_O, Provider, LeadingFlag,...

Hi,

i am trying it in sql server 2008 is it work in it??what i am trying to do is There are two tables in my database of my server...