IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_GetSalesDataWithQuotes]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[sp_GetSalesDataWithQuotes]

IF EXISTS ( SELECT * 
        FROM   sysobjects 
        WHERE  id = object_id(N'[dbo].[sp_GetQuoteItemsFinal]') 
                and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
	DROP PROCEDURE [dbo].[sp_GetQuoteItemsFinal]

IF EXISTS ( SELECT * 
        FROM   sysobjects 
        WHERE  id = object_id(N'[dbo].[sp_GetCustomerFromTradingName]') 
                and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
	DROP PROCEDURE [dbo].[sp_GetCustomerFromTradingName]