--the bbcax query used to get the exchange
SELECT
       NEWEXCH.*,
       OldRefExch.RefExchangeID,
       NewRefExch.RefExchangeID,
       L.CP_NOTES
FROM vendor..tbBBCax_CHG_LIST  L WITH (NOLOCK)
JOIN vendor..tbBBCAX bc (nolock)
     on bc.BBCAXID = L.BBCAXID
LEFT JOIN vendor..tbBBCAXLookup OLDEXCH (NOLOCK)
     ON OLDEXCH.FieldName = 'LU_EQY_PRIM_EXCH'
     AND OLDEXCH.Ykeys = 'Equity'
     AND OLDEXCH.Field2 = L.CP_OLD_EXCH
LEFT JOIN dbo.tbRefExchange OldRefExch WITH (NOLOCK)
     ON OldRefExch.name = OLDEXCH.Field3
     AND OldRefExch.VendorID = 171
LEFT JOIN vendor..tbBBCAXLookup NEWEXCH (NOLOCK)
     ON NEWEXCH.FieldName = 'LU_EQY_PRIM_EXCH'
     AND NEWEXCH.Ykeys = 'Equity'
     AND NEWEXCH.Field2 = L.CP_NEW_EXCH
LEFT JOIN dbo.tbRefExchange NewRefExch WITH (NOLOCK)
     ON NewRefExch.name = NEWEXCH.Field3
     AND NewRefExch.VendorID = 171
WHERE bc.BBCAXID = 191686722

SELECT * FROM vendor..tbBBCAXLookup WHERE BBCAXLookupID = 10912

UPDATE vendor..tbBBCAXLookup SET Field3 = 'SWX Europe' WHERE BBCAXLookupID = 10912 --'SIX Swiss Ex'


SELECT * FROM tbRefExchangeMap WHERE PKID = 1000001192
SELECT * FROM tbRefExchangeMap WHERE HBKPKID = 2634


SELECT * FROM tbRefExchange WHERE ISOMIC = 'XVTX'
SELECT * FROM tbRefExchange WHERE RefExchangeID = 1000000512  --old VX exchange?
SELECT * FROM tbRefExchange WHERE RefExchangeID = 2634 --what should eventually be mapped

SELECT * FROM tbRefExchange WHERE RefExchangeID = 1000001192 -- linked from field3 in tbBBCAXLookup to name
SELECT * FROM tbRefExchange WHERE RefExchangeID = 153 --what is getting mapped