查找上一季度的数据

IF ( MONTH ( ' 2008-08-01 ' ) - 3 >= 1 )
select t2.whsname as ' whsname ' ,t3.code as ' code ' ,t3.name as ' name ' ,
    sum (t0.linetotal) as ' linetotal ' from inv1 t0
    inner join OOBR t1 on t1.itemcode = t0.itemcode
    left join OBUI t6 on t0.docentry = t6.docentry
    left join OHID t2 on t2.whscode = t0.whscode
    left join [ @CATEGORYTABLE ] t3 on t3.code = t1.U_CategoryCode
WHERE ( CASE WHEN MONTH (t6.date) IN ( 1 , 2 , 3 ) THEN ' 1 '
            WHEN MONTH (t6.date) IN ( 4 , 5 , 6 ) THEN ' 2 '
            WHEN MONTH (t6.date) IN ( 7 , 8 , 9 ) THEN ' 3 '
            WHEN MONTH (t6.date) IN ( 10 , 11 , 12 ) THEN ' 4 ' END ) =
            ( CASE WHEN MONTH ( ' 2008-08-01 ' ) IN ( 1 , 2 , 3 ) THEN ' 4 '
            WHEN MONTH ( ' 2008-08-01 ' ) IN ( 4 , 5 , 6 ) THEN ' 1 '
            WHEN MONTH ( ' 2008-08-01 ' ) IN ( 7 , 8 , 9 ) THEN ' 2 '
            WHEN MONTH ( ' 2008-08-01 ' ) IN ( 10 , 11 , 12 ) THEN ' 3 ' END )
            AND YEAR (t6.date) = YEAR ( ' 2008-08-01 ' )
group by t2.whsname,t3.code,t3.name,t0.whscode
ELSE
select t2.whsname as ' whsname ' ,t3.code as ' code ' ,t3.name as ' name ' ,
    sum (t0.linetotal) as ' linetotal ' from inv1 t0
    inner join OOBR t1 on t1.itemcode = t0.itemcode
    left join OBUI t6 on t0.docentry = t6.docentry
    left join OHID t2 on t2.whscode = t0.whscode
    left join [ @CATEGORYTABLE ] t3 on t3.code = t1.U_CategoryCode 
where YEAR (t6.date) = YEAR (t6.date) - 1 AND MONTH (t6.date) IN ( 10 , 11 , 12 )
group by t2.whsname,t3.code,t3.name,t0.whscode