Hello,

I'm trying to do the following SQL query :

SELECT
SCORECARDSID,
DATEPART(MONTH, STARTDATE) SDFS ,
(SELECT SUM(ACTUALVALUE) FROM PERIODICENTRIES
WHERE SCORECARDSID = PE.SCORECARDSID
AND DATEPART(MONTH,STARTDATE) = DATEPART(MONTH, PE.STARTDATE)) AS COUNTCOL

FROM PERIODICENTRIES PE
WHERE
SCORECARDSID = 15
GROUP BY SCORECARDSID, DATEPART(MONTH, PE.STARTDATE)


... SQL Server returns the following error
Server: Msg 8624, Level 16, State 21, Line 1
Internal SQL Server error.


What's wrong with my query? The message doesn't say much about what is going on...

Thank you,
Alex