Accessing Status Report data

C

Craig Nicholls

I am trying to return data from the
MSP_WEB_STATUS_RESPONSES table for reporting purposes.
The data contained in the WRESP_TEXT field appears to be
some sort of XML format which I cannot seem to extract in
any useful form. I have tried using OPENXML in transact
SQL to no avail.

Any suggestions greatly appreciated.
 

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

Select Status Report Responses 0
Extract data from XML file and populate them into cells 1
Table Name for Weekly Status 1
Pulling data from WSS via Excel 2
Extracting data from Multiple columns to a Single row 3
Accessing Infopath Form Data for Reporting Purposes 0
ADODB connect string will not function w/login password embedded 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0

Top