UPDATE m SET m.isPicklist = 1, m.objectName = 'oSurface' 
FROM pal_Module m 
WHERE m.module = 'Surface' 




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



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