--When do we have a building?
CASE WHEN [Building_2_1] IS NULL
      AND [Building_3_1] IS NULL
      AND [Building_3_2] IS NULL
      AND [Building_3_3] IS NULL
      AND [Building_3_4] IS NULL
      AND [Building_Local_2_1] IS NULL
      AND [Building_Local_3_1] IS NULL
      AND [Building_Local_3_2] IS NULL
      AND [Unit_3_1] IS NULL
      AND [Unit_3_2] IS NULL
      AND [Unit_3_3] IS NULL
      AND [Unit_3_4] IS NULL
      AND [Unit_Local_3_1] IS NULL
      AND [Unit_Local_3_2] IS NULL
      AND [Unit_Local_3_3] IS NULL
      AND [Unit_Local_3_4] IS NULL
      AND [Building_3_1] IS NULL
      AND [Building_3_1] IS NULL
      AND [Building_3_1] IS NULL
      AND [Unit_From_3_1] IS NULL
      AND [Unit_To_3_1] IS NULL
      AND [Building_Alpha_From_3_1] IS NULL
      AND [Building_Alpha_To_3_1] IS NULL
      AND [Building_Number_From_3_1] IS NULL
      AND [Building_Number_To _3_1] IS NULL
      AND [Building_Number_Evenodd_3_1] IS NULL
     THEN 0
     ELSE 1
      END AS Has_Building