QUERY 1
CREATE PROCEDURE qryEmployeeList 
AS
SELECT [EHOSP#] AS HospNum, ENUM, RTrim([ELNAME]) + ', ' + RTrim([EFNAME]) + ' ' + RTrim([EINIT]) AS EmpName, RTrim([EADDR1]) + ' ' + RTrim([EADDR2]) AS Address, 
	RTrim([ECITY]) + ', ' + [ESTATE] + ' ' + RTrim([EZIP]) AS Address2, 
	'(' + Convert(nvarchar,[EPHACD]) + ') ' + Left([EPHONE],3) + '-' + Left([EPHONE],4) AS Phone,
	Birthdate = 	
	CASE
	  WHEN EDOBY = 0 THEN Null
	  Else CONVERT(Datetime,Convert(nvarchar,[EDOBm]) + '/' + Convert(nvarchar,[EDOBd])
	  + '/' + CONVERT(nvarchar,[EDOBy]))
	END,
ESSNUM, ESEX, EMARST, EDEPT, EDNAME, EBUDHR,[EGL#], ESHIFT, ECHDTM, ECHDTD, 
	MDCurHireDt = 
	CASE
	  WHEN ECHDTY = 0 THEN NULL
	  ELSE CONVERT(nvarchar,[ECHDTm]) + '/' + CONVERT(nvarchar,[ECHDTd])
	End,
	CurHireDt = 
	CASE
	   WHEN ECHDTY = 0 THEN Null
	   ELSE CONVERT(Datetime, CONVERT(nvarchar,[ECHDTm]) + '/' + CONVERT(nvarchar,[ECHDTd])
	   + '/' + CONVERT(nvarchar,[ECHDTy]))
	END, 
EXMPT,
	[LOA-Dt] = 
	CASE
	   WHEN ELOAy = 0 THEN Null
	   ELSE CONVERT(DateTime, CONVERT(nvarchar,[ELOAm]) + '/' + CONVERT(nvarchar,[ELOAd])
	   + '/'+ CONVERT(nvarchar,[ELOAy]))
	END,
ELOARS, 
	LOARtnDt = 
	CASE
           WHEN ELOAry = 0 THEN NULL
	   ELSE CONVERT(Datetime, CONVERT(nvarchar,[ELOArm]) + '/' + CONVERT(nvarchar,[ELOArd])
	   + '/' + CONVERT(nvarchar,[ELOAry]))
	END,
ELTSB AS LongTermSickLeave, EAPLB AS PaidLeave, 	
	SalaryReviewDate = 
	CASE
	   WHEN ESALRY = 0 THEN NuLL
	   ELSE CONVERT(DateTime,CONVERT(nvarchar,[ESALRM]) + '/' + CONVERT(nvarchar,[ESALRD])
	   + '/' + CONVERT(nvarchar,[ESALRY]))
	END,
	BenAccrualDt = 
	CASE
	   WHEN EOHDTy = 0 THEN NULL
	   ELSE CONVERT(Datetime, CONVERT(nvarchar,[EOHDTm]) + '/' + CONVERT(nvarchar,[EOHDTd])
	   + '/' + CONVERT(nvarchar,[EOHDTy]))
	END,
EJOBCD, EJDSRC, EPGRAD, ESTEP, ELEVEL, ERATE, EMIN, EMAX, EOOHRM, EOOHRD,
	PerRvwCmpDt = 
	CASE
	   WHEN EPFMRy = 0 THEN NULL
 	   ELSE CONVERT(Datetime, CONVERT(nvarchar,[EPFMRm]) + '/' + CONVERT(nvarchar,[EPFMRd])
	   + '/' + CONVERT(nvarchar,[EPFMRy]))
	END,
	MDPerRvwDueDt = 
	CASE
	   WHEN EOOHRY = 0 THEN NULL
	   ELSE CONVERT(nvarchar,[EOOHRM]) + '/' + CONVERT(nvarchar,[EOOHRD])
	END,
	PerRvwDueDt = 
	CASE
	   WHEN EOOHRY = 0 THEN NULL
	   ELSE CONVERT(Datetime,CONVERT(nvarchar,[EOOHRM]) + '/' + CONVERT(nvarchar,[EOOHRD]) 
	   + '/' + CONVERT(nvarchar,[EOOHRY]))
	   END
FROM [PP#FILE_PPPEMPM]
WHERE (ESTAT='A') AND (EXCNT= 0)
ORDER BY RTrim([ELNAME]) + ', ' + RTrim([EFNAME]) + ' ' + RTrim([EINIT]);
GO


Query 2
CREATE PROCEDURE ActiveState @inflateSize int AS

SELECT qryEmployeeList.HospNum, qryEmployeeList.ENUM, qryEmployeeList.EmpName, qryEmployeeList.EDEPT, qryEmployeeList.EDNAME,
	LOADays =
	CASE
	WHEN LOARtnDt = Null Then DATEDIFF(day,[Loa-dt],getDate())
	ELSE DATEDIFF(day,[Loa-dt],LOARtnDt)
	END,
qryEmployeeList.[LOA-Dt], qryEmployeeList.LOARtnDt, qryEmployeeList.ELOARS, qryEmployeeList.PerRvwCmpDt, 
qryEmployeeList.PerRvwDueDt, qryEmployeeList.CurHireDt, [WB#MGR_HOSP].EvalPreDueDys, 
	PreDueDate =
	CASE
	WHEN PerRvwDueDt = CurHireDt THEN CurHireDt + EvalNewHireDys - EvalPr