Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.
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
|How to send multiple emails at the same time in PHP||12||57|
|Get Duration of last Status Update||4||34|
|SQL Server 2012 rs - Sum each category by month||4||32|
|Count with a subquery showing details||10||42|