SQL销售日报表分组排序问题，请高手指导，谢谢。。。

表结构如下：
Create Table T_ItemSale(
       Fdate       Char(10),         --销售日期
       FStockID    Int,              --仓库代码
       FItemid     Int,              --商品内码
       FItemNumber Varchar(80),      --商品代码
       FBarCode    Varchar(80),      --商品条码
       FItemName   Varchar(80),      --商品名称
       FSpecID     Varchar(80),      --规格型号代码
       FUnitID     Varchar(80),      --计量单位代码
       FSalePrice  Decimal(23,10),   --销售单价
       FPurPrice   Decimal(23,10),   --采购单价
       FSaleQty    Decimal(23,10),   --销售数量
       FSaleCost   Decimal(23,10),   --销售成本
       FAmount     Decimal(23,10),   --销售金额
       FGain       Decimal(23,10),   --毛利额
       FGainRate   Decimal(23,10),   --毛利率%
       FID         INT IDENTITY) 
测试数据：
/*--2013-01-01---------------------------------------------------------------------------*/
insert into  T_ItemSale(Fdate,FStockID, FItemid,FItemNumber, 
                       FBarCode,FItemName,FSpecID,
                       FUnitID,FSalePrice,FPurPrice,FSaleQty,
                       FSaleCost,FAmount,FGain,FGainRate)
             Values('2013-01-01','365','901001','100010','6900000000123',
                    'SP_AAA','010','310','12.80','9.20','4','36.80',
                    '51.20','14.40','28.12')insert into  T_ItemSale(Fdate,FStockID, FItemid,FItemNumber, 
                       FBarCode,FItemName,FSpecID,
                       FUnitID,FSalePrice,FPurPrice,FSaleQty,
                       FSaleCost,FAmount,FGain,FGainRate)
             Values('2013-01-01','365','901002','100011','6900000000124',
                    'SP_BBB','011','310','14.80','9.90','2','19.80','29.60',
                    '9.80','33.10')insert into  T_ItemSale(Fdate,FStockID, FItemid,FItemNumber,
                       FBarCode,FItemName,FSpecID,
                       FUnitID,FSalePrice,FPurPrice,FSaleQty,
                       FSaleCost,FAmount,FGain,FGainRate)
             Values('2013-01-01','365','901003','100012','6900000000125',
                    'SP_CCC','010','311','24.80','19.60','7','137.20','173.60',
                    '36.40','20.96')insert into  T_ItemSale(Fdate,FStockID, FItemid,FItemNumber, 
                        FBarCode,FItemName,FSpecID,
                        FUnitID,FSalePrice,FPurPrice,FSaleQty,
                        FSaleCost,FAmount,FGain,FGainRate)
             Values('2013-01-01','365','901004','100013','6900000000125',
                    'SP_DDD','012','313','8.80','6.90','56.90','392.61','500.72',
                    '108.11','21.59')
/*--2013-01-02-------------------------------------------------------------------*/
insert into  T_ItemSale(Fdate,FStockID, FItemid,FItemNumber, 
                        FBarCode,FItemName,FSpecID,
                        FUnitID,FSalePrice,FPurPrice,FSaleQty,
                        FSaleCost,FAmount,FGain,FGainRate)
             Values('2013-01-02','365','901002','100011','6900000000124',
                    'SP_BBB','011','310','14.80','9.9','6','59.40','88.80',
                    '29.40','33.10')
insert into  T_ItemSale(Fdate,FStockID, FItemid,FItemNumber, 
                       FBarCode,FItemName,FSpecID,
                FUnitID,FSalePrice,FPurPrice,FSaleQty,
                FSaleCost,FAmount,FGain,FGainRate)
             Values('2013-01-02','365','901001','100010','6900000000123',
                    'SP_AAA','010','310','12.80','9.20','3','27.60','38.40',
                    '10.80','28.12')
insert into  T_ItemSale(Fdate,FStockID, FItemid,FItemNumber, 
                       FBarCode,FItemName,FSpecID,
                       FUnitID,FSalePrice,FPurPrice,FSaleQty,
                       FSaleCost,FAmount,FGain,FGainRate)
             Values('2013-01-02','365','901004','100013','6900000000125',
                    'SP_DDD','012','313','8.80','6.90','86.90','599.61','764.72',
                    '165.11','21.59')
insert into  T_ItemSale(Fdate,FStockID, FItemid,FItemNumber, 
                        FBarCode,FItemName,FSpecID,
                        FUnitID,FSalePrice,FPurPrice,FSaleQty,
                        FSaleCost,FAmount,FGain,FGainRate)
             Values('2013-01-02','365','901005','100014','6900000000126',
                    'SP_EEE','012','313','3.80','2.90','138.76','402.40','527.28',
                    '124.88','23.68')
/*--------------------------------------------------------------------------------*/