SELECT lq.* ,t.* FROM rlarp.live_quotes lq OUTER APPLY pricing.fn_single_price_call( lq.billto, lq.shipto, lq.part, substring(lq.part,1,8), lq.v1ds, lq.units_each ) t --WHERE -- qid = 112794