15 lines
225 B
SQL
15 lines
225 B
SQL
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 |