|
|
#10 |
|
Ищу людей. Дорого.
|
в продолжении этой темы след вопрос
имеем запрос X++: while select itemId from inventSum // + spp DOMO 06.03.07 sppSet_001_Optimization_Inventsum //index hint closedItemDimIdx // - spp DOMO 06.03.07 sppSet_001_Optimization_Inventsum group by ItemId where inventSum.Closed == noYes::No && inventSum.physicalInvent != 0 X++: SELECT A.ITEMID FROM INVENTSUM A(INDEX(I_174CLOSEDITEMDIMIDX)) WHERE ((DATAAREAID=?) AND ((CLOSED=?) AND (PHYSICALINVENT<>?))) GROUP BY A.ITEMID ORDER BY A.ITEMID OPTION(FAST 20) |
|
|