DECLARE @Phrases varchar(5000), @Result varchar(5000), @Weather varchar(5000), @Currency varchar(5000)

SET @Weather = ''+
                                '<options>'+
                                    '<defaults type="command" command="RETURN" priority="0" timeout="3" sms="false" id_order="0"></defaults>'+
                                        '<play>'+
                                            dbo.WGetWeather( getdate() ) +
                                        '</play>'+
                                '</options>'

SET @Currency = '' +
                                '<options>'+
                                    '<defaults type="command" command="RETURN" priority="0" timeout="3" sms="false" id_order="0"></defaults>'+
                                        '<play>'+
                                            dbo.WGetCurrency( getdate() ) +
                                        '</play>'+
                                '</options>'

SET @Result = ''+
      '<content>'+
        '<options>'+
          '<defaults type="command" command="QUIT" priority="0" timeout="7" sms="false" id_order="0" line="NULL"></defaults>'+
          '<play>'+
            '<phrase name="custom">weather/welcome.wav</phrase>'+
            '<phrase name="common">weather/menu.wav</phrase>'+
          '</play>'+
                    '<buttons>'+

                        '<button name="1" type="submenu">'+
                                @Weather+
            '</button>'+

            '<button name="2" type="submenu">'+
                                @Currency+
            '</button>'+

                    '</buttons>'+
        '</options>'+
      '</content>'

SELECT @Result