PT BIA

??ALTER PROCEDURE [dbo].[PRPTPAEMPLOYEECVPA29]

(

	@EmployeeID VARCHAR(8)

	,@CompanyID VARCHAR(20)

)

AS

--DECLARE @EmployeeID VARCHAR(20) = '20030999'

--DECLARE @CompanyID VARCHAR(20) = ''

SELECT * FROM dbo.PHRPA0029

WHERE EmployeeID = @EmployeeID

ORDER BY Period DESC