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
Sort:
You are not authorized to post a reply.
Author Messages
Tyler Bailey
Financial Systems Analyst
Private
New Member
(5 points)
New Member
Posts:3


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.