serverName databaseName objectName actualBytes expectedBytes firstDifference actualCharacterCode expectedCharacterCode actualFragment expectedFragment
WIN-5ODCFIGQRP3\SQL2016SQL replTransVas dbo.MTS_AdminReportState_v15 6946 6954 12 100 91 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 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