JOINING ActionRequest and ActionReason tables

Sort:
You are not authorized to post a reply.
Author
Messages
Tyler Bailey
New Member
Posts: 3
New Member

    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.