It took the addition of a row of one column, depending on the date. As a result, wrote this:

SELECT sum(_Fld19180) as [SumID], _Fld19184 As [UserNameID], _Description As [GeneralOperationID], convert(date,_Fld19178,112) FROM rlt17.dbo._InfoRg19176 INNER JOIN rlt17.dbo._Reference144 on rlt17.dbo._InfoRg19176._Fld19177RRef = rlt17.dbo._Reference144._IDRRef GROUP BY _Fld19178,_Description,_Fld19184

In this case, all the operations are simply displayed and how much time is spent on them, the addition does not occur. Where do i think wrong?

  • four
    GROUP BY must repeat fields completely! those. GROUP BY _Fld19178, _Description, convert (date, _Fld19178,112) - santavital
  • @santavital, thanks a lot, helped! - Hee Hoo
  • @santavital fill in the answer, there is nothing to be shy. - AK ♦
  • @santavital, but did not want to steal your answer, I waited because. - Hee Hoo

1 answer 1

GROUP BY must repeat fields completely! those. GROUP BY _Fld19178,_Description,convert(date,_Fld19178,112)