DECLARE @FromDate DATETIME
DECLARE @EndDate DATETIME
SET @FromDate = '2013-01-01 00:00:00.000'
SET @EndDate = '2013-02-13 00:00:00.000'
SELECT year(sd.FKDAT) As YEARWISE_DATA,
sg.KUNNR As PARTY,
sg.NAME1 As NAME,
SUM(sd.FKIMG) As QUANTITY,
SUM(sd.NETWR) As VALUE_IN_FC,
SUM(sd.NTGEW) As WEIGHT
FROM
Sales_group sg WITH(NOLOCK)
INNER JOIN
SALES_DATA sd WITH(NOLOCK)
ON
sg.KUNNR = sd.KUNAG
WHERE
sd.FKDAT >= @FromDate
AND
sd.FKDAT <= @EndDate
GROUP By
YEAR(sd.FKDAT),
sg.KUNNR,
sg.NAME1
ORDER By
1,
sg.KUNNR ASC
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/