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?