Post reply

XML Explicit

  • April 10, 2003 at 11:50 am

    #65284

    Hi,

    I have 3 stored procs for generating xml using xml explicit. ( i pass parameters case number and ctr nbr) for all the stored procs.

    I would like to merge all 3 stored procs and create one xml file instead of 3.

    can some some give me ideas or pass me sample code to start with

    thank you

    Neel

  • April 14, 2003 at 8:20 am

    #454062

    Each doc has a different format? If they are all the same structure, you could change the individual procs to return a standard resultset, then create the XML in a calling proc by unioning the results.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply