Urgent help - Problem with multiple select ROUND statments

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dregier
    #1

    Urgent help - Problem with multiple select ROUND statments

    attached is my full query that I am currently working on:
    Declare @counterday1 int
    Declare @counterday2 int

    set @counterday1 = '20'
    set @counterday2 = '629'

    Declare @CounterMin07_0 1 float
    Declare @CounterMin08_0 1 float
    Declare @CounterMin09_0 1 float
    Declare @CounterMin10_0 1 float
    Declare @CounterMin11_0 1 float
    Declare @CounterMin12_0 1 float
    Declare @CounterMin13_0 1 float
    Declare @CounterMin14_0 1 float
    Declare @CounterMin15_0 1 float
    Declare @CounterMin16_0 1 float
    Declare @CounterMin17_0 1 float
    Declare @CounterMin18_0 1 float

    Declare @CounterMin07_0 2 float
    Declare @CounterMin08_0 2 float
    Declare @CounterMin09_0 2 float
    Declare @CounterMin10_0 2 float
    Declare @CounterMin11_0 2 float
    Declare @CounterMin12_0 2 float
    Declare @CounterMin13_0 2 float
    Declare @CounterMin14_0 2 float
    Declare @CounterMin15_0 2 float
    Declare @CounterMin16_0 2 float
    Declare @CounterMin17_0 2 float
    Declare @CounterMin18_0 2 float

    Declare @CounterMax07_0 1 float
    Declare @CounterMax08_0 1 float
    Declare @CounterMax09_0 1 float
    Declare @CounterMax10_0 1 float
    Declare @CounterMax11_0 1 float
    Declare @CounterMax12_0 1 float
    Declare @CounterMax13_0 1 float
    Declare @CounterMax14_0 1 float
    Declare @CounterMax15_0 1 float
    Declare @CounterMax16_0 1 float
    Declare @CounterMax17_0 1 float
    Declare @CounterMax18_0 1 float

    Declare @CounterMax07_0 2 float
    Declare @CounterMax08_0 2 float
    Declare @CounterMax09_0 2 float
    Declare @CounterMax10_0 2 float
    Declare @CounterMax11_0 2 float
    Declare @CounterMax12_0 2 float
    Declare @CounterMax13_0 2 float
    Declare @CounterMax14_0 2 float
    Declare @CounterMax15_0 2 float
    Declare @CounterMax16_0 2 float
    Declare @CounterMax17_0 2 float
    Declare @CounterMax18_0 2 float

    Declare @CounterAvg07_0 1 float
    Declare @CounterAvg08_0 1 float
    Declare @CounterAvg09_0 1 float
    Declare @CounterAvg10_0 1 float
    Declare @CounterAvg11_0 1 float
    Declare @CounterAvg12_0 1 float
    Declare @CounterAvg13_0 1 float
    Declare @CounterAvg14_0 1 float
    Declare @CounterAvg15_0 1 float
    Declare @CounterAvg16_0 1 float
    Declare @CounterAvg17_0 1 float
    Declare @CounterAvg18_0 1 float

    Declare @CounterAvg07_0 2 float
    Declare @CounterAvg08_0 2 float
    Declare @CounterAvg09_0 2 float
    Declare @CounterAvg10_0 2 float
    Declare @CounterAvg11_0 2 float
    Declare @CounterAvg12_0 2 float
    Declare @CounterAvg13_0 2 float
    Declare @CounterAvg14_0 2 float
    Declare @CounterAvg15_0 2 float
    Declare @CounterAvg16_0 2 float
    Declare @CounterAvg17_0 2 float
    Declare @CounterAvg18_0 2 float

    Select @CounterMin07_0 1 = ROUND(Min(Count erValue),2)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    07:00:00' AND '2003-10-30 07:59:59'

    Select @CounterMin08_0 1 = ROUND(Min(Count erValue),2)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    08:00:00' AND '2003-10-30 08:59:59'

    Select @CounterMin09_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    09:00:00' AND '2003-10-30 09:59:59'

    Select @CounterMin10_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    10:00:00' AND '2003-10-30 10:59:59'

    Select @CounterMin11_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    11:00:00' AND '2003-10-30 11:59:59'

    Select @CounterMin12_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    12:00:00' AND '2003-10-30 12:59:59'

    Select @CounterMin13_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    13:00:00' AND '2003-10-30 13:59:59'

    Select @CounterMin14_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    14:00:00' AND '2003-10-30 14:59:59'

    Select @CounterMin15_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    15:00:00' AND '2003-10-30 15:59:59'

    Select @CounterMin16_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    16:00:00' AND '2003-10-30 16:59:59'

    Select @CounterMin17_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    17:00:00' AND '2003-10-30 17:59:59'

    Select @CounterMin18_0 1 = Min(CounterValu e)
    From counterdata
    where counterid = @counterday1 and counterdatetime BETWEEN '2003-10-30
    18:00:00' AND '2003-10-30 18:59:59'

    Select Min07_01 = @CounterMin07_0 1,
    Min08_01 = @CounterMin08_0 1,
    Min09_01 = @CounterMin09_0 1,
    Min10_01 = @CounterMin10_0 1,
    Min11_01 = @CounterMin11_0 1,
    Min12_01 = @CounterMin12_0 1,
    Min13_01 = @CounterMin13_0 1,
    Min14_01 = @CounterMin14_0 1,
    Min15_01 = @CounterMin15_0 1,
    Min16_01 = @CounterMin16_0 1,
    Min17_01 = @CounterMin17_0 1,
    Min18_01 = @CounterMin18_0 1



    For some reason the @CounterMin07_0 1 does report a value of 0.00 but
    the @CounterMin08_0 1 reports something like 7.9823623372E-11 instead
    of 0.00

    Any Ideas???
    Tags: None
    Previous template Next
    Working...