Post reply

XML QUERY HELP

  • January 28, 2008 at 3:32 pm

    #93027

    I have a table with XML datatype column having following data (example of one record)

    '

    '

    I need to query this data and get the vehicledata value for each record along with that record string;

    basically I need to explode the data and get all the records individually.

  • January 29, 2008 at 2:05 am

    #772763

    You're example appears to be blank to me?!


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • January 29, 2008 at 7:02 am

    #772839

    Sorry for the inconvenience.

    here is the xml data:

    ......

    ....

  • January 29, 2008 at 7:07 am

    #772841

    Can you attach the data in a txt file please?


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • January 29, 2008 at 7:25 am

    #772855

    I have attached the file. somehow I could n't cut and paste the data inmy earlier reply.

    I need the vehcle key value from all the records and also the complete record as 2 fields.

    thanks.

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

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