declare @JobNumber1 char(12)
declare @ItemNumber1 char(8)
declare @JdeDateFrom int
declare @JdeDateTo int 
set @JobNumber1 = '     3505040'
set @ItemNumber1 = '01010    ' 
set @JdeDateFrom = 108217
set @JdeDateTo = 108217

If Object_ID('tempdb..#JDE_LaborHrsDetailTable1') Is Not Null    Drop Table #JDE_LaborHrsDetailTable1

create table	#JDE_LaborHrsDetailTable1
		(  jde_job_date datetime,
           jde_cost_code char(15),
		   jde_equipment_id char(10),
		   jde_equipment_name char(20),
           jde_employee_name char(15),
           jde_employee_hours decimal(8,2),
           jde_equipment_hours decimal(8,2) 
		                                       )

Set NoCount On

insert into #JDE_LaborHrsDetailTable1(jde_job_date, jde_cost_code, jde_equipment_id, jde_equipment_name,
                                   jde_employee_name, jde_employee_hours, jde_equipment_hours)
Exec ('Call QGPL.get_labdet(?,?,?,?)', @JobNumber1, @ItemNumber1, @JdeDateFrom, @JdeDateTo) AT AS400SRV_MSDASQL

select * from #JDE_LaborHrsDetailTable1 order by jde_job_date

drop table #JDE_LaborHrsDetailTable1