--Task Meeting
SELECT     dbo.FilteredNew_taskmeeteng.new_startdate AS startdate,
           dbo.FilteredNew_taskmeeteng.new_name AS Task_Meeting,
           NULL AS Task_Call,
           NULL AS Pidpus_Agreem,
           NULL AS Vidmov_Agreem,
           NULL AS Test_Drive

FROM         dbo.FilteredNew_taskmeeteng
WHERE     (new_meeting =  1 ) AND (new_taskstate =  2 )

--Task Call
UNION ALL

SELECT  FilteredNew_taskcall.new_name AS Task_Call, 
        FilteredNew_taskcall.new_startdate AS startdate, 
        NULL AS Task_Meeting,
        NULL AS Pidpus_Agreem,
        NULL AS Vidmov_Agreem,
        NULL AS Test_Drive
FROM         FilteredNew_taskcall
WHERE     (FilteredNew_taskcall.new_taskstatename =  2 )


--Pidpus Agreement
UNION ALL
SELECT     (dbo.FilteredNew_agreement.new_name) AS Pidpus_Agreem,
           dbo.FilteredNew_agreement.new_startwork AS startdate,
           NULL AS Task_Call,
           NULL AS Task_Meeting,
           NULL AS Vidmov_Agreem,
           NULL AS Test_Drive 

FROM         dbo.FilteredNew_vehicle LEFT OUTER JOIN
                      dbo.FilteredNew_agreement ON dbo.FilteredNew_vehicle.new_vehicleid = dbo.FilteredNew_agreement.new_vehicleid
WHERE     (dbo.FilteredNew_agreement.new_stateagreement = N'4')


-- Vidmov Agreemment
UNION ALL
SELECT     (dbo.FilteredNew_agreement.new_name) AS Vidmov_Agreem,
           dbo.FilteredNew_agreement.new_startwork AS StartDate,
           NULL AS Task_Meeting,
           NULL AS Task_Call,
           NULL AS Pidpus_Agreem,
           NULL AS Test_Drive 

FROM         dbo.FilteredNew_vehicle LEFT OUTER JOIN
                      dbo.FilteredNew_agreement ON dbo.FilteredNew_vehicle.new_vehicleid = dbo.FilteredNew_agreement.new_vehicleid
WHERE     (dbo.FilteredNew_agreement.new_stateagreement = N'6')


--Test Drive
UNION ALL
SELECT dbo.New_tasktestdriveExtensionBase.New_StartDate AS startdate,
       dbo.New_tasktestdriveExtensionBase.New_name AS Test_Drive,
       NULL AS Task_Meeting,
       NULL AS Task_Call,
       NULL AS Pidpus_Agreem,
       NULL AS Vidmov_Agreem

FROM dbo.New_tasktestdriveBase LEFT OUTER JOIN
                      dbo.New_tasktestdriveExtensionBase ON 
                      dbo.New_tasktestdriveBase.New_tasktestdriveId = dbo.New_tasktestdriveExtensionBase.New_tasktestdriveId LEFT OUTER JOIN
                      dbo.new_vehicle_tasktestdriveBase ON 
                      dbo.New_tasktestdriveBase.New_tasktestdriveId = dbo.new_vehicle_tasktestdriveBase.new_tasktestdriveid LEFT OUTER JOIN
                      dbo.New_vehicleExtensionBase ON dbo.new_vehicle_tasktestdriveBase.new_vehicleid = dbo.New_vehicleExtensionBase.New_vehicleId
WHERE     (dbo.New_tasktestdriveExtensionBase.New_ResultTaskCode = N'5') AND 
          (dbo.New_tasktestdriveExtensionBase.New_TaskState = N'2')
Group By dbo.New_tasktestdriveExtensionBase.New_StartDate,
         dbo.New_tasktestdriveExtensionBase.New_name;