创建试图问题，高手请进

Question

select 
    nMonth=convert(varchar(6),getdate(),112),
    vcEmployeeId,
    nDays=sum(nDays)
FROM 
    bVacation  
group by convert(varchar(6),getdate(),112),vcEmployeeId

Answer 1

到底是dDate还是dBegin？select convert(varchar(4),datepart(yy,dBegin))+convert(varchar(2),datepart(mm,dBegin)) as nMonth,vcEmployeeId,sum(nDays)
FROM bVacation  
group by convert(varchar(4),datepart(yy,dBegin))+convert(varchar(2),datepart(mm,dBegin)),vcEmployeeId

Answer 2

select convert(varchar(6),dBegin,112) as nMonth,vcEmployeeId,sum(nDays)
FROM bVacation  
group by convert(varchar(6),dBegin,112),vcEmployeeId

Answer 3

select vcEmployeeId,left(convert(nvarchar(8),dDate,112),6) as dDate,sum(nDays) as ndays
from c group by vcEmployeeId, left(convert(nvarchar(8),dDate,112),6)