sql语句id拼接（备用）

select count (*) as a  from (
  select 
    (convert(varchar(8),FMID,112)+'_'+convert(varchar(8),depotid,112)+'_'+convert(varchar(8),typeid,112)+'_'
    +convert(varchar(8),FState,112)+'_'+convert(varchar(8),FCID,112)+'_' + convert(varchar(8),FNo,112)) as keyid,
    sum (FNum) as FNum,
    depotid,
    FState,
    FMID,
    typeid,
    FCID,
    FUID,
    fsno,
    FNo,
    SUBSTRING(CONVERT(VARCHAR,[FDATE],121),1,11) as FDATE 
  from depot_detail 
  group by depotid,FState,FMID,typeid,FCID,FUID,fsno,FNo,
	SUBSTRING(CONVERT(VARCHAR,[FDATE],121),1,11)
) as aaa 

where depotid >0