use DB;
--select '%' + left(internetaddress, PATINDEX('%@%', internetaddress)-1) + '%' from NamesPerson
DECLARE @k smallint;
set @k = (select TOP 1 COUNT(Lastname) FROM NamesPerson Where shortname not like '%' + left(internetaddress, PATINDEX('%@%', internetaddress)-1) + '%' and AltFullName is not null);
if @k > 0
	BEGIN
		EXEC msdb.dbo.sp_send_dbmail
		@profile_name = 'SMTP Mail',
		@recipients = '@mail',
		@query = 'use DB; select Lastname FROM NamesPerson Where shortname not like ''%'' + left(internetaddress, PATINDEX(''%@%'', internetaddress)-1) + ''%'' and AltFullName is not null order by lastname' ,
		@subject = 'Не совпадают ShortName либо присутствует лишний (ShortName)',
		@attach_query_result_as_file = 1;
	END

END TRY
BEGIN CATCH
SELECT
		ERROR_NUMBER() AS ErrorNumber,  
        ERROR_SEVERITY() AS ErrorSeverity,  
        ERROR_STATE() AS ErrorState,  
        ERROR_PROCEDURE() AS ErrorProcedure,  
        ERROR_LINE() AS ErrorLine,  
        ERROR_MESSAGE() AS ErrorMessage; 
END CATCH

select * FROM NamesPerson Where shortname not like '%' + left(internetaddress, PATINDEX('%@%', internetaddress)-1) + '%' and AltFullName is not null;