just wondering if this is do-able?
Im looking to run sql query and create an xml output but instead of grouping it all in the one "column" I'm looking to return it into multi rows.
so this sql: SELECT top 5 user_id,user_name FROM aaguser FOR XML PATH ('Users'),ROOT ('Employee')
brings back this:
I would like to return the users section of the xml as rows rather than one group like this. so each row would contain the data (users)............(/users)
Any info /help would be great.