SELECT yymm, total, uid, uname, hrs, ot, UserProcess, holyot, ot2, holyot2, otPMS, holyotPMS FROM vUserWorkTimeList WHERE (SUBSTRING(yymm, 1, 4) = @yyyy) AND (gcode = @gcode) AND (ISNULL(UserProcess, '') LIKE @userprocess) ORDER BY yymm SELECT UserProcess, holyot, holyot2, holyotPMS, hrs, ot, ot2, otPMS, total, uid, uname, yymm FROM vUserWorkTimeList WHERE (gcode = @gcode) AND (ISNULL(UserProcess, '') LIKE @userprocess) AND (ISNULL(ot2, 0) > 0 OR ISNULL(holyot2, 0) > 0) AND (SUBSTRING(yymm, 1, 7) BETWEEN @startM AND @endM) ORDER BY yymm SELECT UserProcess, holyot, holyot2, holyotPMS, hrs, ot, ot2, otPMS, total, uid, uname, yymm FROM vUserWorkTimeList WHERE (gcode = @gcode) AND (ISNULL(UserProcess, '') LIKE @userprocess) AND (ISNULL(otPMS, 0) > 0 OR ISNULL(holyotPMS, 0) > 0 OR ISNULL(ot2, 0) > 0 OR ISNULL(holyot2, 0) > 0) AND (SUBSTRING(yymm, 1, 7) BETWEEN @startM AND @endM) ORDER BY yymm SELECT UserProcess, holyot, holyot2, holyotPMS, hrs, ot, ot2, otPMS, total, uid, uname, yymm FROM vUserWorkTimeList WHERE (gcode = @gcode) AND (ISNULL(UserProcess, '') LIKE @userprocess) AND (ISNULL(otPMS, 0) > 0 OR ISNULL(holyotPMS, 0) > 0) AND (SUBSTRING(yymm, 1, 7) BETWEEN @startM AND @endM) ORDER BY yymm SELECT UserProcess, holyot, holyot2, holyotPMS, hrs, ot, ot2, otPMS, total, uid, uname, yymm FROM vUserWorkTimeList WHERE (gcode = @gcode) AND (ISNULL(UserProcess, '') LIKE @userprocess) AND (ISNULL(ot, 0) > 0 OR ISNULL(holyot, 0) > 0) AND (ISNULL(ot2, 0) = 0) AND (ISNULL(holyot2, 0) = 0) AND (ISNULL(otPMS, 0) = 0) AND (ISNULL(holyotPMS, 0) = 0) AND (SUBSTRING(yymm, 1, 7) BETWEEN @startM AND @endM) ORDER BY yymm SELECT ISNULL(EETGW_GroupUser.Process, '') AS processs, JobReport.uid, Users.name AS uname, JobReport.pdate, SUM(JobReport.hrs) AS hrs, SUM(JobReport.ot) AS ot, MAX(JobReport.type) AS jobtype FROM JobReport WITH (nolock) INNER JOIN EETGW_GroupUser WITH (nolock) ON JobReport.gcode = EETGW_GroupUser.gcode AND JobReport.uid = EETGW_GroupUser.uid LEFT OUTER JOIN Users WITH (nolock) ON JobReport.uid = Users.id WHERE (SUBSTRING(JobReport.pdate, 1, 7) = @yymm) AND (JobReport.uid <> '') AND (JobReport.gcode = @gcode) AND (ISNULL(EETGW_GroupUser.Process, '') LIKE @userprocess) GROUP BY JobReport.uid, JobReport.pdate, Users.name, EETGW_GroupUser.Process ORDER BY processs, JobReport.pdate, uname DELETE FROM [Users] WHERE (((@IsNull_id = 1 AND [id] IS NULL) OR ([id] = @Original_id)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode))) SELECT Users.id, Users.name, JobReport.gcode, Users.indate, Users.outdate FROM EETGW_GroupUser WITH (nolock) INNER JOIN JobReport WITH (nolock) ON EETGW_GroupUser.gcode = JobReport.gcode AND EETGW_GroupUser.uid = JobReport.uid LEFT OUTER JOIN Users WITH (nolock) ON JobReport.uid = Users.id WHERE (Users.id <> 'dev') AND (Users.id <> 'test') AND (EETGW_GroupUser.Process LIKE @process) AND (JobReport.gcode = @gcode) GROUP BY Users.id, Users.name, JobReport.gcode, Users.indate, Users.outdate ORDER BY Users.name UPDATE [Users] SET [id] = @id, [name] = @name, [gcode] = @gcode WHERE (((@IsNull_id = 1 AND [id] IS NULL) OR ([id] = @Original_id)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gcode = 1 AND [gcode] IS NULL) OR ([gcode] = @Original_gcode))); SELECT Users.id, Users.name, Users.gcode FROM Users RIGHT OUTER JOIN JobReport ON Users.id = JobReport.uid WHERE (JobReport.idx = @idx) AND (Users.id = @id) GROUP BY Users.id, Users.name, Users.gcode ORDER BY Users.name DELETE FROM [HolidayLIst] WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_free = 1 AND [free] IS NULL) OR ([free] = @Original_free)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)) INSERT INTO [HolidayLIst] ([pdate], [free], [memo], [wuid], [wdate]) VALUES (@pdate, @free, @memo, @wuid, @wdate); SELECT idx, pdate, free, memo, wuid, wdate FROM HolidayLIst WHERE (idx = SCOPE_IDENTITY()) ORDER BY pdate SELECT idx, pdate, free, memo, wuid, wdate FROM HolidayLIst WITH (nolock) WHERE (pdate LIKE @pdate) ORDER BY pdate UPDATE [HolidayLIst] SET [pdate] = @pdate, [free] = @free, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_free = 1 AND [free] IS NULL) OR ([free] = @Original_free)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate)); SELECT idx, pdate, free, memo, wuid, wdate FROM HolidayLIst WHERE (idx = @idx) ORDER BY pdate SELECT idx, pdate, gcode, id, name, process, type, svalue, hrs, ot, requestpart, package, userProcess, status, projectName, description, ww, otStart, otEnd, ot2, otReason, otPMS FROM vJobReportForUser WITH (nolock) WHERE (gcode = @gcode) AND (pdate BETWEEN @sd AND @ed) AND (id LIKE @uid) ORDER BY pdate SELECT description, gcode, hrs, id, idx, name, ot, ot2, otEnd, otPMS, otReason, otStart, package, pdate, process, projectName, requestpart, status, svalue, type, userProcess, ww FROM vJobReportForUser WITH (nolock) WHERE (gcode = @gcode) AND (pdate BETWEEN @sd AND @ed) ORDER BY pdate SELECT description, gcode, hrs, id, idx, name, ot, ot2, otEnd, otPMS, otReason, otStart, package, pdate, process, projectName, requestpart, status, svalue, type, userProcess, ww FROM vJobReportForUser WITH (nolock) WHERE (gcode = @gcode) AND (pdate BETWEEN @sd AND @ed) AND (userProcess = @userprocess) ORDER BY pdate SELECT idx, pdate, gcode, id, name, process, type, svalue, hrs, ot, requestpart, package, userProcess, status, projectName, description, ww, otStart, otEnd, ot2, otReason, otPMS FROM vJobReportForUser_New WITH (nolock) WHERE (gcode = @gcode) AND (pdate BETWEEN @sd AND @ed) AND (userProcess = @userprocess) ORDER BY pdate SELECT idx, pdate, gcode, id, name, process, type, svalue, hrs, ot, requestpart, package, userProcess, status, projectName, description, ww, otStart, otEnd, ot2, otReason, otPMS FROM vJobReportForUser_New WITH (nolock) WHERE (gcode = @gcode) AND (pdate BETWEEN @sd AND @ed) AND (id LIKE @uid) ORDER BY pdate SELECT MAX(JobReport.idx) AS idx, dbo.getWorkWeek(JobReport.pdate) AS ww, ISNULL(JobReport.pidx, 0) AS pidx, MAX(JobReport.projectName) AS title, ISNULL(SUM(JobReport.hrs), 0) AS hrs, Projects.status AS PrjStatus, ISNULL(Projects.name, (CASE WHEN jobreport.[type] = '휴가' THEN '휴가' WHEN jobreport.[type] LIKE '%미팅%' THEN '미팅' ELSE Projects.name END)) AS PrjName FROM JobReport WITH (nolock) LEFT OUTER JOIN Projects WITH (nolock) ON JobReport.pidx = Projects.idx AND JobReport.gcode = Projects.gcode WHERE (JobReport.gcode = @gcode) AND (JobReport.pdate BETWEEN @sd AND @ed) AND (JobReport.uid = @uid) AND (ISNULL(JobReport.hrs, 0) > 0) GROUP BY dbo.getWorkWeek(JobReport.pdate), ISNULL(JobReport.pidx, 0), ISNULL(Projects.name, (CASE WHEN jobreport.[type] = '휴가' THEN '휴가' WHEN jobreport.[type] LIKE '%미팅%' THEN '미팅' ELSE Projects.name END)), Projects.status ORDER BY title, ww SELECT Projects.idx, dbo.getLastProjectScheduleNo(Projects.gcode, Projects.idx) AS ScheduleNo, Projects.gcode, Projects.name, EETGW_ProjectsSchedule.idx AS SubIDX, EETGW_ProjectsSchedule.no, EETGW_ProjectsSchedule.seq, EETGW_ProjectsSchedule.title, EETGW_ProjectsSchedule.uid, EETGW_ProjectsSchedule.sw, EETGW_ProjectsSchedule.ew, EETGW_ProjectsSchedule.swa, EETGW_ProjectsSchedule.ewa, Projects.sdate, Projects.ddate, EETGW_ProjectsSchedule.complete, EETGW_ProjectsSchedule.uidname, EETGW_ProjectsSchedule.progress, Projects.userprocess, Projects.status FROM Projects WITH (nolock) LEFT OUTER JOIN EETGW_ProjectsSchedule WITH (nolock) ON Projects.gcode = EETGW_ProjectsSchedule.gcode AND Projects.idx = EETGW_ProjectsSchedule.project WHERE (Projects.gcode = @gcode) AND (Projects.status = '검토' OR Projects.status = '진행') AND (ISNULL(Projects.isdel, 0) = 0) AND (dbo.getLastProjectScheduleNo(Projects.gcode, Projects.idx) = EETGW_ProjectsSchedule.no) AND (EETGW_ProjectsSchedule.uid LIKE @uidlike) ORDER BY Projects.idx DESC, subidx, EETGW_ProjectsSchedule.no, EETGW_ProjectsSchedule.seq