编制动态查询期初人数, sp2 取当月开始日期1号数据 为起初数据,sp2后,取上月末为 下月期初数据,数据来源参考以下sql
SELECT adminrange.fid fid,adminrange.flongnumber, count(*) count FROM T_BD_PersonHis AS PERSON LEFT OUTER JOIN T_HR_EmpOrgRelation AS EMPPOSORGRELA ON PERSON.FhistoryRelateID = EMPPOSORGRELA.FPersonID LEFT OUTER JOIN T_HR_EmpLaborRelationHis AS EMPLABORRELA ON EMPPOSORGRELA.FlaborRelationID = EMPLABORRELA.fhistoryrelateid LEFT OUTER JOIN T_HR_BDEmployeeType AS EMPLOYEETYPE ON EMPLABORRELA.FLaborRelationStateID = EMPLOYEETYPE.FID LEFT OUTER JOIN T_ORG_AdminHis AS ADMINORGUNIT ON EMPPOSORGRELA.FAdminOrgID = ADMINORGUNIT.FhistoryRelateID LEFT OUTER JOIN T_ORG_PositionHis AS POSITION ON EMPPOSORGRELA.FPositionID = POSITION.FhistoryRelateID LEFT OUTER JOIN T_HR_PersonPositionHis AS PP ON PERSON.FhistoryRelateID = PP.FPersonID INNER JOIN T_BD_EmployeeModle AS EMPLOYEEMODLE ON EMPLOYEETYPE.FEmployeeModleID = EMPLOYEEMODLE.FID right join t_org_adminHis adminrange on ADMINORGUNIT.FL
