Extracting values from a single column

Transact-SQL
21

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
22

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

Pasted image1219×321 10.6 KB