USP_SIMPLEDATALIST_YEARSWITHVENDORACTIITY

CREATE procedure dbo.USP_SIMPLEDATALIST_YEARSWITHVENDORACTIITY as
    select distinct YEAR(ft.[date]) as VALUE
        from dbo.FINANCIALTRANSACTION as FT
        inner join dbo.FINANCIALTRANSACTION1099DISTRIBUTION as FT1099 
            on FT.ID = FT1099.FINANCIALTRANSACTIONID  
        where FT.TYPECODE in (101,102)
    union 
    select distinct YEAR(V1099.EFFECTIVEDATE) as VALUE
        from dbo.VENDOR1099ADJUSTMENT as V1099