su.dbms

 
 - SU.DBMS ----------------------------------------------------------------------
 From : SergOp                               2:5020/400     06 Mar 2001  14:15:52
 To : All
 Subject : Re: Подскажите про Select
 -------------------------------------------------------------------------------- 
 

 
 Hi Fatuev Yury !
 
 > Да рыл. Hифига не получилось
 
 рой дальше :
 select l.tg_prod_id,l.tg_invdate as t3id,max(tg_ccs) as t3_ccs,
 sum(l.tg_Qty) as tg_QtyR,
 sum(l.tg_Qty*l.tg_PriceRealTaxVz_bc)*l.tg_ccs as t3_sumPriceRealTaxVz_nc,
 sum(l.tg_Qty*l.tg_PriceFullVz_bc)*l.tg_ccs as t3_sumPriceFullVz_nc,
 sum(l.tg_Qty*l.tg_PriceRealTaxVz_bc) as t3_PriceRealTaxVz_bc,
 sum(l.tg_Qty*l.tg_PriceFullVz_bc) as t3_PriceFullVz_bc into #tgtp from
 AuditorTG as l where l.tg_prod_id = pProd and tg_type_client = '4' and
 l.tgcl = SubCl and l.tg_invdate < fnDtW group by
 l.tg_prod_id,l.tg_invdate,l.tg_ccs
 having (select sum(tg_Qty)-tg_QtyR as sm from AuditorTG where
 tg_prod_id = pProd and tg_type_client = '4' and tgcl = SubCl and tg_invdate
 < fnDtW and tg_invdate >= l.tg_invdate having sm <= pPerc) is not null order
 by l.tg_invdate asc
 Удачи
 --- ifmail v.2.15dev5
  * Origin: navigator Online Internet News Server (2:5020/400)
 
 

Вернуться к списку тем, сортированных по: возрастание даты  уменьшение даты  тема  автор