Create table #temp

(C1 varchar(20) Not null,
C2 varchar(20) not null,
C3 varchar(20) not null,
C4 varchar(20) ,
C5 varchar(20), 
C6 varchar(20),
C7  varchar(20)
 )


Insert into #Temp values
(C1,
 C2,
 C3,
 C4,
c5,
c6,
C7)
EXEC [dbo].[spgetOrders]
	@StartDate,
	@EndDate,
	@Item ,
 @Item_type = @Item_type  --- gives results.
--,@Item_type                   --- does not give result

select * from #temp values
drop table #temp