SELECT        x.sale_id,  SUM(x.price_ru) AS price_ru
FROM            (SELECT        s.sale_id, SUM(sd.price_ru) AS price_ru
                          FROM            Tab.Sale AS s INNER JOIN
                                                    Tab.SaleDetail AS sd ON s.sale_id = sd.sale_id INNER JOIN
                                                    Tab.Shk AS ss ON ss.shk_id = sd.shk_id
                          WHERE        (s.is_deleted = 0) AND (s.is_duplicate = 0) and CAST(CONVERT(VARCHAR(8), s.create_dt, 112) as int)=20171111 and s.sale_id=57690473
                          GROUP BY CAST(s.create_dt AS DATE),s.sale_id
                        ) x
GROUP BY x.sale_id

select * from facts.vw_sales where pk_date=20171111 and doc_number=57690473


select * from olap.bo.sale s
join olap.bo.saledetail sd ON s.sale_id=sd.sale_id
where s.sale_id=57690473