/****** Сценарий для команды SelectTopNRows среды SSMS  ******/
select POK.CustomerCode As N,
       POK.SerialNo As N_ch,
       POK.Data As data,
       sum(POK.Value0)-sum(POK.Value1) As day_p,
       sum(POK.Value1) As night_p,
       SUM(POK.Value4) As sh_p      
from (SELECT [cp_EISPoints].[CustomerCode]
      ,[dm_Devices].[SerialNo]
      ,min(CAST([RW_ReceivedData].[Time] AS date)) as Data
      ,CASE [RW_ReceivedData].[LogicalName]
          WHEN 0x01000F0800FF THEN cast(max([RW_ReceivedData].[NormValue])as bigint)
       ELSE 0
       END as Value0  
      ,CASE [RW_ReceivedData].[LogicalName]
          WHEN 0x01000F0801FF THEN cast(max([RW_ReceivedData].[NormValue])as bigint)
       ELSE 0
       END as Value1
      ,CASE [RW_ReceivedData].[LogicalName]
          WHEN 0x01000F0802FF THEN cast(max([RW_ReceivedData].[NormValue])as bigint)
       ELSE 0
       END as Value2
       ,CASE [RW_ReceivedData].[LogicalName]
          WHEN 0x01000F0804FF THEN cast(max([RW_ReceivedData].[NormValue])as bigint)
       ELSE 0
       END as Value4      
      FROM [ADDAXDB_APPSERVER].[dbo].[dm_Devices]
          ,[ADDAXDB_APPSERVER].[dbo].[RW_ReceivedData]
          ,[ADDAXDB_APPSERVER].[dbo].[cp_EISPoints]
          ,[ADDAXDB_APPSERVER].[dbo].[cp_ControlPoints]
   where [dm_Devices].[Id]=[RW_ReceivedData].[DeviceId]
      and [RW_ReceivedData].[DeviceId] = [cp_ControlPoints].[DevId]
      and [cp_ControlPoints].[CPID]=[cp_EISPoints].[CPID]
      and( [RW_ReceivedData].[Time]>='01.11.2013' and [RW_ReceivedData].[Time]<='01.12.2013')
      and( [RW_ReceivedData].[LogicalName]=0x01000F0800FF
        or [RW_ReceivedData].[LogicalName]=0x01000F0801FF
        or [RW_ReceivedData].[LogicalName]=0x01000F0802FF
        or [RW_ReceivedData].[LogicalName]=0x01000F0804FF)
   group by [cp_EISPoints].CustomerCode
           ,[dm_Devices].[SerialNo]
           ,CAST([RW_ReceivedData].[Time] AS date)
           ,[RW_ReceivedData].[LogicalName]) POK
group by POK.CustomerCode,POK.SerialNo,POK.Data
order by POK.CustomerCode,POK.Data