/********************************************************************************/
/*		              Company Name                    			*/
/********************************************************************************/
/*      Procedure Name  : dbo.ssp_stored_procname			        */
/*      Parameters      :                                                       */
/*      Return Codes    :                                                       */
/*                                                                              */
/*      Description     : Description of what it does, params etc               */
/*                                                                              */
/*                                                                              */
/*                                                                              */
/*                                                                              */
/*                                                                              */
/*      Author          : Authorname                                            */
/*      Date written    : Date                                        		*/
/*      History         : version number                                        */
/*                                                                              */
/********************************************************************************/
 
IF EXISTS (SELECT 1 FROM sysobjects where id = object_id('dbo.ssp_stored_procname') and sysstat & 0xf = 4)
BEGIN
	PRINT 'Dropping old version of dbo.ssp_stored_procname'
	DROP PROCEDURE dbo.ssp_stored_procname
END
GO
 
PRINT 'Creating procedure dbo.ssp_stored_procname - START'
GO
 
CREATE PROCEDURE dbo.ssp_stored_procname
	(@intpassedparam		[datatype])	
AS

Select Fields
from   Table
Where  (Conditions)
	
RETURN @@ERROR
GO

PRINT 'Creating procedure dbo.ssp_stored_procname - END'
GO