Change all parent contacts without an email address to portal access “” or blank.
UPDATE [DBNAME].[dbo].[CON] SET AP = '' WHERE EM = '' AND AP = 'Y'

Parent email address that is not also located in the contacts table. Good for migrating away from the generic parent email field.
SELECT ID, SC
FROM [DBNAME].[dbo].stu
WHERE TG = '' AND NOT EXISTS

(SELECT *
FROM [DBNAME].[dbo].con
WHERE [DBNAME].[dbo].[STU].PEM = [dst17000cuhsd].[dbo].CON.EM)

Contacts without portal access yes.
SELECT CON.PID,CON.[EM],coN.[OR] FROM [DBNAME].[dbo].[CON],[DBNAME].[dbo].[STU] where CON.em <> '' AND AP ='N' and CON.pid = stu.ID and TG='' AND CON.del = '0' AND STU.del = '0' ORDER BY PID,[OR]