Project Detail

Description

MS SQL/XML Expert needed!

Please be available via IM to go over details. So I can provide stored procedure

I have 3 relational tables
categories
products
prices

I have a stored procedure that generates categories and related products. Most of the work is done, I just need to split catalog into monthly and yearly under each category with additional selects.

A bit of a complex query. I'm sure its easy for you!
At the moment data thats generated looks like this
<categories>
<category>
<name>womans interest</name>
<desc></desc>
<magazine>
<name>elle</name>
</magazine>
</category>
</categories>

I need data to be structured like shown below:
After categories, display two types of catalogs, <monthly></monthly> and <yearly></yearly>

Monthly catalog will always be a price of 0 (zero)
Yearly magazines will have multiple prices (one year, two year options)


<categories>
<category>
<name>womans interest</name>
<desc></desc>
<monthly>
<magazine>
<name>womans health</name>
</magazine>
<magazine>
<name>elle</name>
</magazine>
</monthly>
<yearly>
<magazine>
<name>elle</name>
<price yearly="1">
<months>12</months>
<issues>12</issues>
<cover_price>65.00</cover_price>
<subscription_price>24.99</subscription_price>
<percent_savings>50</percent_savings>
<additional_fee>0.00</additional_fee>
<allow_montly_change>0</allow_montly_change>
<active>1</active>
</price>
<price yearly="1">
<months>24</months>
<issues>24</issues>
<cover_price>65.00</cover_price>
<subscription_price>24.99</subscription_price>
<percent_savings>50</percent_savings>
<additional_fee>0.00</additional_fee>
<allow_montly_change>0</allow_montly_change>
<active>1</active>
</price>

</magazine>
</yearly>
</category>
</categories>


Maximum project budjet $35