It has obviously been a long day for me, the code below is failing to run and I have no idea why.
Incorrect syntax near ')'
UID as Whenfresh_URN,
MP_URN as CallCredit_URN,
INTO UserListTransfer..ContactCentre33_PO0188_MatchedData -- SELECT COUNT(*)
FROM UserListTransfer..ContactCentre33_CallCredit_PO0188 WITH(NOLOCK)
LEFT JOIN UserListTransfer..Whenfresh_20160116 WITH(NOLOCK)
ON POSTCODE = Postcode
AND FAMILY_NAME = Surname
UserListTransfer..Whenfresh_20160116.POSTCODE is not null
and UserListTransfer..Whenfresh_20160116.FAMILY_NAME is not null