Входные параметры NULL - SQL Server - Ответ 5037496

stt.ID IN (SELECT id FROM @SettlementID_table) AND
      s.ID IN (SELECT id FROM @StreetsID_table) AND
      hs.ID IN (SELECT id FROM @HousesID_table) AND
      rs.ID IN (SELECT id FROM @ServiceID_table)

SELECT stt.Name +' '+ s.Name +' '+ hs.Number AS 'Адрес', d.name AS 'Участок', rs.Name AS 'Услуга', mu.Name AS 'Ед.Измерения', ast.cost AS 'Тариф', sf.Specific AS 'Норматив', sup.Name AS 'Поставщик', COUNT(r.id) AS 'Количество ЛС'
FROM cpay.reciever r
    JOIN cpay.access ass ON r.id = ass.[owner]
        LEFT JOIN Auxiliary.TariffesTypes att ON ass.ID_TariffesTypes = att.ID_ServiceSubtypes
                LEFT JOIN [REFERENCES].Suppliers sup ON att.ID_Suppliers = sup.ID
        LEFT JOIN Auxiliary.ServiceTariffes ast ON att.ID = ast.ID_TariffesTypes
          JOIN [REFERENCES].[Services] rs ON ass.ID_Service = rs.ID
             JOIN Auxiliary.ServiceSubtypes asbt ON rs.ID = asbt.ID_Service
                JOIN [REFERENCES].Specifications sf ON asbt.id = sf.ID_Subtype
             JOIN [REFERENCES].[MeasureUnits] mu ON rs.ID_MeasureUnits = mu.id
    LEFT JOIN [REFERENCES].[Districts] d ON r.id_district = d.ID
    JOIN Common.Flats f ON r.ID_Flat = f.ID
    JOIN Common.Entrances e ON f.[OWNER] = e.ID 
    JOIN Common.Houses hs ON e.[OWNER] = hs.ID
    JOIN Common.Buildings b ON hs.[OWNER] = b.ID
    JOIN Common.Streets s ON b.[OWNER] = s.ID
    JOIN Common.Settlements stt ON s.[OWNER] = stt.ID