Select Status Report Responses

D

Dean Beckley

I'm trying to write a select statement in TSQL to return the Status report
responses:

select WRESP_TEXT from MSP_WEB_STATUS_RESPONSES

It returns text with the XML tags in place. Can anyone help me with a good
approach to selecting the data so it can be viewed without the xml tags?

The bigger picture is that I'm putting together a status report that
contains data from 2 other databases and I'd like to include the PWA status
reports. I'm able to select the data from my other DB's, but this xml text
is giving me some trouble. I'm obviously not a programmer but am fairly
capable with TSQL.

Thanks,
Dean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accessing Status Report data 0
Get Project Indicators by Status Date 1
Status Report Requests (2007) 0
Status Report Function in 2007 PWA - part II 3
REPOST:Access 2007&XML: import, change, write back to XML? 16
Access 2007 and XML: import, change, write back to XML? 0
Trying to get just part of an XML file? 5
Status Report 1

Top