I need help creating a for xml path that looks like below...I have an outer node and then an inner node...See below for my desired output and regular SQL statement..<promotionInfor
is the outermost node and then <expandedPromotionsInforma
tion> is the inner node..
<expandedPromotionsInformation> <promotionType>UserViewed_Value</promotionType> <listingAddress>AddressLine1</listingAddress> <promotionStartDate>DateStartPromotion</promotionStartDate> <promotionEndDate>DateEndPromotion</promotionEndDate>
<promotionType> UserViewed_Value </promotionType>
<promotionEndDate> DateEndPromotion </promotionEndDate>
Select UserViewed_Value, AddressLine1 DateStartPromotion, DateEndPromotion