Here's one that we recently did in the real world:

CREATE PROCEDURE spGMSRMRemovePODetailDupes

AS

select count(*) as NumberOfDupes,

max(grsinterfacePODetailsID) as MaxIDNumber,

RequestNo as ReqNo,

StatusCode as StatCode,

StatusDate as StatDate

into #TempFindDupes

from GRSInterfacePODetails...