Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aspivey

    Recordset return with hierarchial XML Tags

    Thanks for the advice John. I'll give that a try.
  2. aspivey

    Recordset return with hierarchial XML Tags

    Using SQL Server 2000, I am using a 'for xml auto,elements' to return a single recordset properly tagged and it is working as advertised. The problem is that I need the recordset tagged in a hierarchial fashion such as: <GroceryItems> <DairyItems> <Items> <ItemName>Sharp...
  3. aspivey

    For XML Auto and Nulls

    Thanks Terry, Spot on with that advice. Archie
  4. aspivey

    For XML Auto and Nulls

    If I execute a 'Select * from XYZ for XML Auto', the result set doesn't contain any fields that had nulls. I need those fields also even if they are null value. Can someone provide any help?

Part and Inventory Search

Back
Top