SELECT r.value('@Value','int')
FROM Job
CROSS APPLY JobXml.nodes('/Job/TimeID') AS x(r)

DECLARE @xml XML

SELECT @xml = N'<Employee>
<EMPID>1</EMPID>
<EMPNAME>AAA</EMPNAME>
<EMPSALARY>2000.00</EMPSALARY>
<DEPTID>1</DEPTID>
</Employee>'

SELECT
      T.C.value('(EMPID)[1]', 'int')
      ,T.C.value('(EMPNAME)[1]', 'nvarchar(20)')
      ,T.C.value('(EMPSALARY)[1]', 'decimal(15,5)')
      ,T.C.value('(DEPTID)[1]', 'int')
   FROM @xml.nodes('Employee') T(C)