perkov

--USE [HrPortal]
USE [SUP_SUPOK2]
--USE [ACCPAC]
go

SELECT
--m.definition
DISTINCT  o.schema_id, s.name, o.name AS Object_Name, o.type_desc, o.create_date, o.modify_date
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id = o.object_id
LEFT JOIN sys.schemas s ON o.schema_id = s.schema_id
--WHERE m.definition Like '%Latest modification date: 05-05-2016%'
--WHERE m.definition Like '%EmployeeGrade%'
--WHERE m.definition Like '%_TS_BW_DayWorkload%'
--WHERE m.definition Like '%prc_Update_Report_BW_DayCost%'
--WHERE m.definition Like '%UPDATE dbo.Project SET TPExecutors = @s WHERE ProjectID = @projectId%'  -- and m.definition not Like '%GetFirstDayOpenWeek%'
WHERE m.definition Like '%BaseEducation%'
--WHERE m.definition Like '%UpdateAllProjectRoles2005%'  -- and m.definition not Like '%GetFirstDayOpenWeek%'
--WHERE m.definition Like '%f_RepGetProjectCostByDivisions%'  -- and m.definition not Like '%GetFirstDayOpenWeek%'







LJ Video