Declare
@CurrentYear_StartDate As DateTime,
@CurrentYear_EndDate As DateTime,
@TodaysDate As DateTime,
@CurrentYear As int
set @CurrentYear = year(getdate())
set @CurrentYear_StartDate = convert(DateTime, '01/01/' + cast(@CurrentYear As varchar))
set @CurrentYear_EndDate = convert(DateTime, '12/31/' + cast(@CurrentYear As varchar))
Select ITEMNMBR, ITEMDESC, sum(XTNDPRCE) As CurrentYear_Sales
From sop30200 m
Inner Join sop30300 d on d.sopnumbe = m.sopnumbe and m.soptype=3
Where m.DocDate >= @CurrentYear_StartDate and m.DocDate <= @CurrentYear_EndDate and m.voidstts=0
Group by ITEMNMBR, ITEMDESC
Order by CurrentYear_Sales DESC
Wednesday, August 6, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment