Extracting values from a single column

How about something like

SELECT
ORD.Name,OUD.UserDataCode,
    CASE WHEN OUD.UserDataCode  = 'RX_BridgingMedicationName' THEN OUD.Value ELSE NULL END [Medication Name]
    CASE WHEN OUD.UserDataCode = 'RX_Bridgingreason' THEN OUD.Value ELSE NULL END [Bridging Reason]
FROM CV3ORDER ORD
JOIN CV3OrderUserData  OUD ON OUD.OrderGUID = Ord.GUID 
    AND OUD.ClientGUID = Ord.ClientGUID 

1 Like

Thank you - Something I have tried, Here is the output, I have added two more columns, Name and GUID,
I need only one row for each GUID, and dont know where this Bridging qty coming from