loganforand
New Member
I have an XML query in SSMS 2008 R2 that is based on a stored proc. I just learned about this cool way to run XML code like the following in SSMS. I didn't realize it was this simple! However, is there an easy way to modify this XML query so that it reorders the results based on whichever column I choose? I tried replacing line 12 with a different column, but this didn't change the order.\[code\]rpt_vacancy '<parameter_set><parameter name="AGENCYID" type_code="FK" value="http://stackoverflow.com/questions/11230450/{B233233B-6CB1-4C45-99E8-B99CB4FF8C74}" scrnval_id="" show="false"></parameter><parameter name="AGENCYNAME" type_code="FK" value="http://stackoverflow.com/questions/11230450/Youth Villages" scrnval_id="" show="false"></parameter><parameter name="ISMULTIAGENCY" type_code="L" value="http://stackoverflow.com/questions/11230450/0" scrnval_id="" show="false"></parameter><parameter name="WORKERID" type_code="FK" value="http://stackoverflow.com/questions/11230450/A10EF9F9-DCF6-4B84-87F3-9988C66F2423" scrnval_id="" show="false"></parameter><parameter name="REPORT_CODE" type_code="FK" value="http://stackoverflow.com/questions/11230450/VACANCY" scrnval_id="" show="false"></parameter><parameter scrnval_id="" name="SUB_TITLE" type_code="S" show="false" value="http://stackoverflow.com/questions/11230450/Order by: Managing Office"/><parameter scrnval_id="" name="agency" type_code="FK" value="http://stackoverflow.com/questions/11230450/{B233233B-6CB1-4C45-99E8-B99CB4FF8C74}" descript="Youth Villages" show="true"/><parameter scrnval_id="" name="min_age" descript="Min Age ( Greater than or Equal to )" type_code="N" report_parameter="1" is_not_in="" value="" show="false"/><parameter scrnval_id="" name="max_age" descript="Max Age ( Less than or Equal to )" type_code="N" report_parameter="1" is_not_in="" value="" show="false"/><parameter scrnval_id="" name="is_suppr_units" descript="Suppress Units Totals" type_code="L" report_parameter="1" is_not_in="" value="" show="false"/><parameter scrnval_id="" name="is_suppr_members" descript="Suppress Printing of Members" type_code="L" report_parameter="1" is_not_in="" value="" show="false"/><parameter scrnval_id="" name="is_suppr_clients" descript="Suppress Printing of Clients Placed" type_code="L" report_parameter="1" is_not_in="" value="" show="false"/><parameter scrnval_id="" name="is_beds_avail" descript="Homes with Available Beds" type_code="L" report_parameter="1" is_not_in="" value="" show="false"/><parameter scrnval_id="" name="is_male_accept" descript="Accepts Male - Entry on Unit" type_code="L" report_parameter="1" is_not_in="" value="" show="false"/><parameter scrnval_id="" name="is_female_accept" descript="Accepts Female - Entry on Unit" type_code="L" report_parameter="1" is_not_in="" value="" show="false"/><parameter scrnval_id="" name="is_accept" descript="Currently Accepting Placements" type_code="L" report_parameter="1" is_not_in="" value="" show="false"/><parameter type_code="FK" show="true" name="Managing Office" scrnval_id="89457190-16A6-428C-9A77-682886169FEF" is_not_in="" value="http://stackoverflow.com/questions/11230450/4053DB39-0777-4BA2-B3D3-5A4170E343C4" descript="Jackson, MS"></parameter><parameter type_code="FK" show="true" name="" scrnval_id="" is_not_in="" value="" descript=""></parameter></parameter_set>'\[/code\]Note that rpt_Vacancy is a stored proc