Not really. You can use a CASE type expressions as

...

If @item = 'Job'

then

select

JobID = OrderID

from #TblItems

else if @item = 'Order'

select OrderID = OrderID

from #tblItems

...