IF NOT EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND OBJECT_ID = OBJECT_ID('Sp_H_TimeCard_GetReportTimecard'))
begin
   exec('CREATE PROCEDURE [dbo].[Sp_H_TimeCard_GetReportTimecard] AS BEGIN SET NOCOUNT ON; END')
end