---

INSERT INTO [ElectionsArch_paip].[dbo].[TT_PresenceStatistic]
(
    [ObjectID]
   ,[ts]
   ,[MembersOfECon8Count]
   ,[MembersOfECon8Percent]
   ,[MembersOfUIKWithPSG15]
   ,[MembersOfUIKWithPSG20]
   ,[ObserverCount15]
   ,[ObserverCount20]
   ,[Commission]
   ,[NonResidentTotal]
   ,[NonResidentVoted]
   ,[ArmyTotal]
   ,[ArmyVoted]
   ,[SpecialRequests]
   ,[VotersCount18DayBefore]
   ,[BulletinsGotByAct]
   ,[ClosedUik]
   ,[ExternalUik]
   ,[HomeVotersTotal]
   ,[HomeVotersVoted]
   ,[TempLocationTotal]
   ,[TempLocationVoted]
)
SELECT
    [ObjectID]
   ,[ts]
   ,NULL AS [MembersOfECon8Count]     -- нет в источнике, NULL или 0
   ,NULL AS [MembersOfECon8Percent]   -- нет в источнике, NULL или 0
   ,NULL AS [MembersOfUIKWithPSG15]
   ,NULL AS [MembersOfUIKWithPSG20]
   ,NULL AS [ObserverCount15]
   ,NULL AS [ObserverCount20]
   ,[ShortName] AS [Commission]       -- 'краткое название комиссии'
   ,NULL AS [NonResidentTotal]
   ,NULL AS [NonResidentVoted]
   ,1    AS [ArmyTotal]               -- везде 1
   ,NULL AS [ArmyVoted]
   ,NULL AS [SpecialRequests]
   ,NULL AS [VotersCount18DayBefore]
   ,NULL AS [BulletinsGotByAct]
   ,NULL AS [ClosedUik]
   ,NULL AS [ExternalUik]
   ,NULL AS [HomeVotersTotal]
   ,NULL AS [HomeVotersVoted]
   ,NULL AS [TempLocationTotal]
   ,NULL AS [TempLocationVoted]
FROM [ElectionsArch_paip].[dbo].[Commission];