PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/13/2018 4:33 PM by  Tyler Bailey
JOINING ActionRequest and ActionReason tables
 0 Replies
You are not authorized to post a reply.
Author Messages
Tyler Bailey
Financial Systems Analyst
New Member
(5 points)
New Member

Send Message:

03/13/2018 4:33 PM

    Are these two tables able to be joined, or is there a table that links them together? I am trying to write a SQL query to show Terminate Action Requests and the Reason for them. Thanks.


    EDIT: I was able to join the ACTIONREQUESTS table to the S$USRA table and find the data I need in the PARAMETERS column, except its in XML. Does anyone have experience parsing information from XML in SQL SERVER 2008?



    You are not authorized to post a reply.