Insert Multiple Column based on existing table aggregated
INSERT [fd_movements_dates](Date, Cnt)
SELECT (CONVERT(date, MsgTimestamp)) as Date
    ,COUNT(1) AS Cnt
FROM [fd_movements]
GROUP BY (CONVERT(date, MsgTimestamp))