SELECT Count(ID) Num,MailLettersID INTO #TempMailNum FROM
dbo.MailHistory
GROUP BY MailLettersID
--SELECT * FROM #TempMailNum
UPDATE MailLetters SET SendNum =
(
SELECT Num FROM #TempMailNum WHERE #TempMailNum.MailLettersID = MailLetters.MailLettersID
)
DROP Table #TempMailNum