select FDate,FTypeCo from (select left(FarcLocationDate,len(@FDateMin)) AS FDate,left(FtypeCo,len(@FTypeCo)+3 ) AS FTypeCo
from archives) c
group by FDateleft,FTypeCo
from archives) c
group by FDateleft,FTypeCo
set @sql_char='left(FarcLocationDate,len(@FDateMin)) AS FDate,left(FtypeCo,len(@FTypeCo)+3 ) AS FTypeCo '
exec('select ' +@sql_char +'from archives group by '+@sql_char)
记住括号是不可以省略的。