serverName databaseName objectName actualBytes expectedBytes firstDifference actualCharacterCode expectedCharacterCode actualFragment expectedFragment
WIN-5ODCFIGQRP3\SQL2016SQL replTransVas dbo.MTS_AdminReportState_v15 6954 6954 11 91 32 ALTER VIEW[dbo].[MTS_AdminReportState_v15]5 AS WITH Cert AS (SELECT kodReport, kodMember, COUNT(*) AS certificateRows, MAX(mtsCertNumber) AS mtsCertNumber, MAX(manFIO) AS manFIO, MAX(CONVERT(int, formReceived)) AS formReceived, MAX(CASE WHEN NULLIF (LTRIM(RTRIM(c0.mtsCertNumber)), N'') IS NOT NULL THEN 1 ELSE 0 END) AS hasCertificate ALTER VIEW [dbo].[MTS_AdminReportState_v15] AS WITH Cert AS (SELECT kodReport, kodMember, COUNT(*) AS certificateRows, MAX(mtsCertNumber) AS mtsCertNumber, MAX(manFIO) AS manFIO, MAX(CONVERT(int, formReceived)) AS formReceived, MAX(CASE WHEN NULLIF (LTRIM(RTRIM(c0.mtsCertNumber)), N'') IS NOT NULL THEN 1 ELSE 0 END) AS hasCertificate