USP_DATALIST_VENDOR1099ADJUSTMENTS

create procedure dbo.USP_DATALIST_VENDOR1099ADJUSTMENTS(
  @VENDORID uniqueidentifier,
  @TAXYEAR nvarchar(5) = null
)
as
    set nocount on;

    select A.ID,
           A.EFFECTIVEDATE,
           (B.BOXNUMBER + ' - ' + B.DESCRIPTION) as [BOXNUMBER1099],
           S.ABBREVIATION 'STATE',
       A.AMOUNT,
       A.REFERENCE
    from dbo.VENDOR1099ADJUSTMENT as A
    left outer join dbo.STATE as S on S.ID = A.STATEID
    left outer join dbo.FINANCIALTRANSACTION1099BOXNUMBER as B on B.ID = A.BOXNUMBER1099ID
    where A.VENDOR1099SETTINGID = @VENDORID AND
        ((@TAXYEAR is null) or (YEAR(A.EFFECTIVEDATE) = @TAXYEAR))
  order by A.EFFECTIVEDATE desc