DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

CREATE  PROCEDURE [dbo].[TR_REQ_JOB_ByUserName]

	@p_UserName	varchar(100)

AS

	begin -- PAGING

		 -- PAGING BEGIN

		SELECT A.[ID]

			  ,A.[EMP_CODE]

			  ,A.[EMP_NAME]

			  ,A.[BRANCH_CODE]

			  ,A.[DEP_CODE]

			  ,A.[USER_DOMAIN]

			  ,A.[POS_CODE]

			  ,A.[POS_NAME]

			  ,A.[CREATE_DT]

			  ,B.[EMP_PHONE]

		 -- SELECT END

		FROM CM_EMPLOYEE_LOG A

		LEFT JOIN(SELECT TOP(1)* FROM dbo.TR_REQUEST_JOB_FORM WHERE MAKER_ID=@p_UserName AND EMP_PHONE IS NOT NULL ORDER BY CREATE_DT DESC ) B ON A.USER_DOMAIN = B.MAKER_ID

		WHERE  USER_DOMAIN= @p_UserName

		 -- PAGING END

	end -- PAGING