Hi,
I need the values in the same line, like:
Cotação Budget
Encomendas
112859.060000
96559.460000
Can anyone help me?
Thanks on advanced.
Paula Rodrigues
select distinct fref as 'Cotação',sum(case when nmdos ='ENC. FORN. MODELO' and fref=' '
then etotaldeb else 0 end) as 'Budget',
sum(case when nmdos ='ENC. A FORNECEDOR' and fref='005/2014 '
then etotaldeb else 0 end) as 'Encomendas'
from bo(nolock)group by nmdos, fref
Cotação Budget
Go to the complete details ...