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!

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

Recent content by aspivey

  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?
See more

Part and Inventory Search

Back
Top