Ooh, here's some from a random proc I just plucked out of Object Explorer (stuff in "<>" is what I removed before posting). Mix of bad code/bad comments; I've stuck...

-- =============================================

-- Author:<Author,,Name>

-- Create date: <Create Date,,>

-- Description:<Description,,>

-- =============================================

-- Add the parameters for the stored procedure here

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT...