select  
 DEP.cDepName AS 部门,
 PER.cPersonName AS 业务员,
 inv.cInvStd as 规格型号,
 rds08.cFree1 as 品牌,
 rds08.cFree5 as 客户,
 war.cWhName as 仓库名称,
 rd08.dDate as  货权转移时间,
 rds08.cDefine36 as 库龄日期,
 rds08.iQuantity as 入库数量,
 main.isoutquantity as 出库数量,
rds08.iUnitCost*1.13 as 单价,
rd08.cMemo AS 备注
from MainBatch main 
 inner join rdrecords08 rds08 on rds08.AutoID=main.RdID
 inner join RdRecord08 rd08 on rd08.ID =rds08.ID  
 LEFT join inventory inv on inv.cInvCode=rds08.cInvCode
 LEFT join  Person per on per.cPersonName=rds08.cfree3
 LEFT join  Department dep on dep.cDepCode=per.cDepCode
 LEFT join  Warehouse war on war.cWhCode=rd08.cWhCode

  where   rd08.dDate between '${开始时间}' and '${结束时间}' and
  main.cvouchtype='08' 
  and isnull(main.isoutquantity,0)<isnull(rds08.iQuantity,0)
  and rd08.cMemo is not null
  and rd08.cMemo like 'HZQTCK%' OR rd08.cMemo like 'AHQTCK'
  and (charindex(per.cDepCode,'${部门}')>0 or '${部门}'='') 
  --and per.cDepCode='${部门}'