[lev]

может:

while select tmpTable
     group by ItemId
     {
        select  sum(Qty)from tmpTable_1
        where  tmpTable_1.Normal==noyes::Yes &&
                  tmpTable_1.ItemId  == tmpTable.ItemId;

        select sum (Qty) from tmpTable_2
        where tmpTable_2.Normal==noYes::No &&
                 tmpTable_2.ItemId  == tmpTable.ItemId;