Divide Between Select Values

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • japuentem
    New Member
    • Jun 2007
    • 31
    #1

    Divide Between Select Values

    I Don't Know If I Can Divide Values Like This

    Code:
    (select Sum(importe) From Costos, Homolodamaster
Where Costos.cuenta=homologamaster.cuenta
And Fecha='24-07-2007') / (select Sum(ponderacion*noenvios)
From Noenvios1, Homologadet, Homologamaster
Where Noenvios1.origendestino=homologader.origendestino
And Homologadet.idruta=homologamaster.idruta)
    The First Select Returns 129299 And The Second Returns1821623 And I Need To Divide This Two Values, How Can I Do

    Regards
    Tags: None
    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878
      #2
      Originally posted by japuentem
      I Don't Know If I Can Divide Values Like This

      Code:
      (select Sum(importe) From Costos, Homolodamaster
Where Costos.cuenta=homologamaster.cuenta
And Fecha='24-07-2007') / (select Sum(ponderacion*noenvios)
From Noenvios1, Homologadet, Homologamaster
Where Noenvios1.origendestino=homologader.origendestino
And Homologadet.idruta=homologamaster.idruta)
      The First Select Returns 129299 And The Second Returns1821623 And I Need To Divide This Two Values, How Can I Do

      Regards

      why don't you use variable?

        Comment

        • japuentem
          New Member
          • Jun 2007
          • 31
          #3
          Originally posted by ck9663
          why don't you use variable?
          i don't know how to use that?

            Comment

            • leela mn
              New Member
              • May 2007
              • 43
              #4
              chk ths.......
              Code:
                
declare @numerator numeric(18,9)
declare @denominator   numeric(18,9)
select @numerator  = Sum(importe) From Costos, Homolodamaster
Where Costos.cuenta=homologamaster.cuenta
And Fecha='24-07-2007'

select @denominator  = Sum(ponderacion*noenvios)   
From Noenvios1, Homologadet, Homologamaster   
Where Noenvios1.origendestino=homologader.origendestino
And Homologadet.idruta=homologamaster.idruta

declare @res numeric(18,9)
set @res = @numerator /@denominator

                Comment

                • japuentem
                  New Member
                  • Jun 2007
                  • 31
                  #5
                  Originally posted by leela mn
                  chk ths.......
                  Code:
                    
declare @numerator numeric(18,9)
declare @denominator   numeric(18,9)
select @numerator  = Sum(importe) From Costos, Homolodamaster
Where Costos.cuenta=homologamaster.cuenta
And Fecha='24-07-2007'

select @denominator  = Sum(ponderacion*noenvios)   
From Noenvios1, Homologadet, Homologamaster   
Where Noenvios1.origendestino=homologader.origendestino
And Homologadet.idruta=homologamaster.idruta

declare @res numeric(18,9)
set @res = @numerator /@denominator
                  Thank for your help.

                    Comment

                    Previous template Next
                    Working...