We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
select t1.quan as Qty, case when t1.prodtype in (0,1, 101) then t3.descript when t1.prodtype = 100 then t2.descript else 'no desc avail' end as Description, t1.costeach as 'Cost Each', (t1.quan * t1.costeach) as 'Extended Cost' from dba.posdetail as t1 left join dba.promo as t2 on t1.prodnum = t2.promonum left join dba.product as t3 on t1.prodnum = t3.prodnum where t1.transact = 899330
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL - format decimal in a string||5||51|
|SQL Server syntax||11||41|
|SP inserts data with order number, then push the rest one order up||11||19|
|SQL Query - Multiple match on field with no extras||7||15|