Låna skarpa anläggningar och personnummer från D365 PROD som ännu ej finns i UAT - till tester i UAT
Uppdaterad
SELECT TOP 10 D.METERINGPOINT
FROM XLN_EXU_DELPOINT D
WHERE D.METERINGPOINT LIKE '735999242%'
AND D.METERINGPOINT NOT IN (
SELECT S.METERINGPOINT
FROM [BIREPORT_UAT].[dbo].[XLN_EXU_DELPOINT] S
)
ORDER BY D.CREATEDDATETIME desc
---
SELECT TOP 10 C.EXU_ALTERNATIVECUSTOMERNUMBER
FROM XLN_CUSTCUSTOMER_VIEW C
WHERE C.EXU_ALTERNATIVECUSTOMERNUMBER LIKE '19%'
AND C.EXU_ALTERNATIVECUSTOMERNUMBER NOT IN (
SELECT C.EXU_ALTERNATIVECUSTOMERNUMBER
FROM [BIREPORT_UAT].[dbo].[XLN_CUSTCUSTOMER_VIEW] C
)
ORDER BY C.CREATEDDATETIME desc