使用distinct group by with rollup应用报错难题

 我在SQL2008里做了个统计报表，其中有这么段代码：
  Insert into #Data(FSupplyNumber,FItemNumber,FTypeEx,FBegQty,FQty,FBaseQty,FAmount,FCommitQty,FBaseCommitQty,FCommitAmount,FUnCommitQty,FUnCommitAmount,FSumSort)   Insert into #D