-- Drop stored procedure if it already exists
IF EXISTS (
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE SPECIFIC_SCHEMA = N'dbo'
AND SPECIFIC_NAME = N'ServiceManager_Report_ActivityManagement_SP_GetReviewActivityDetails'
)
DROP PROCEDURE dbo.ServiceManager_Report_ActivityManagement_SP_GetReviewActivityDetails
GO