Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bj1
  • Order by date
  1. bj1

    finding absolute maximum value

    Sounds fair enough to me... Thank you for all your help. I'll let you know how i go. BJ
  2. bj1

    finding absolute maximum value

    Thanks Mufasa! This looks great... but... now i lose finding the max absolute values for each date. Is it possible to work this aspect into the query as well? Thanks so much for your help.
  3. bj1

    coverting rows to columns

    sorry for my ignorance, but i'm not sure i understand where this sub query fits into the query i already have... can you provide more assistance? thank you :)
  4. bj1

    coverting rows to columns

    How would i go about converting this: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000 -9.0 37 2003-12-13 00:56:44.000 117.0 to this: xddatetime tilt54 pitch55 2003-12-13 00:56:43.000 -199.0 -9.0 2003-12-13 00:56:44.000 117.0 where...
  5. bj1

    finding absolute maximum value

    sorry... i have another question! How would i go about converting this: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000 -9.0 37 2003-12-13 00:56:44.000 117.0 to this: xddatetime tilt54 pitch55 2003-12-13 00:56:43.000 -199.0 -9.0...
  6. bj1

    finding absolute maximum value

    This works!!! Thank you so much for your help... Keep up the good work. Thanks heaps, B
  7. bj1

    finding absolute maximum value

    i would like to find the max absolute value for each distinct sensorid and datetime. And then i want to be able to show these values in their original form, i.e whether they are positive or negative. there will be many entries for sensor id 54 and 55, but at different times throughout the day...
  8. bj1

    finding absolute maximum value

    hi mufasa, i tried your suggestion and came up with this query: select xdsensorid, xddatetime, xdvalue, xdlongitude, xdlatitude from his_externaldata where abs(xdvalue) = (select max(abs(xdvalue)) from ((vmi_vehicles inner join ext_sensors on vunitid = sunitid) inner join...
  9. bj1

    finding absolute maximum value

    Hi This is the original data: 37 2003-12-13 00:56:43.000 -199.0 37 2003-12-13 00:56:43.000 -156.0 38 2003-12-13 00:56:43.000 -9.0 38 2003-12-13 00:56:43.000 3.0 37 2003-12-13 00:56:44.000 117.0 What i would like to see some how is: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000...
  10. bj1

    graphing time

    hi there! i have a bar chart which graphs the time a vehicle has spent at a specified location. At the moment i can only figure out how to display the data values as 20.45 (20 hours and 45 minutes) - i would like to display it as 20:45. Is this possible??? Thanks, B
  11. bj1

    want to combine 2 different reports into 1

    Hi All, This is what i have got so far: declare @ThisDate datetime create table #DayList (FakeDate datetime) set @ThisDate = '08/17/2003 14:00:00' while not( (round(convert(float,@ThisDate),0,1) )> (round(convert(float, convert(datetime,'08/19/2003 13:59:59')),0,1)) ) begin insert #DayList...
  12. bj1

    join 2 tables - problem with dates

    Hi All, This is what i have got so far: declare @ThisDate datetime create table #DayList (FakeDate datetime) set @ThisDate = '08/17/2003 14:00:00' while not( (round(convert(float,@ThisDate),0,1) )> (round(convert(float, convert(datetime,'08/19/2003 13:59:59')),0,1)) ) begin insert #DayList...
  13. bj1

    Parameters and Formula's

    i have solved this by using this formula in the suppress section. whileprintingrecords; Local numbervar ONE_MIN := 1 / (60 * 24); if {@VisitLength} < ONE_MIN * ({?Visitminimum} - 0.01)then true thank for all your help :)
  14. bj1

    Problem displaying times over midnight

    hi all, this is what i want to achieve: (Location) (From) (To) (Visit Length) 1/5/03 XXXXXX 00:00 07:30 07:30 XXXXXX 08:16 17:31 09:15 XXXXXX 18:02 00:00 05:58 2/5/03 XXXXXX 00:00 07:00 07:00 XXXXXX 08:37 17:31...
  15. bj1

    Parameters and Formula's

    if i use this formula in the suppress section: Whileprintingrecords; if {@DisplayVisitLength} <= totext(truncate({?VisitMinimum}),&quot;00&quot;)&&quot;:&quot;& totext(val(right(totext({?VisitMinimum},2),3))*60,0) then true it says 'a time is required here' - the cursor is in front of...
  16. bj1

    Parameters and Formula's

    this is what i am puting in the suppress section (it didn't work in the group select): Whileprintingrecords; if {@VisitLength} <= totext(truncate({?VisitMinimum}),&quot;00&quot;)&&quot;:&quot;& totext(val(right(totext({?VisitMinimum},2),3))*60,0) then true and it says 'a number is required...
  17. bj1

    Parameters and Formula's

    i tried the above suggestion - but it asked for a number??? this is what i have tried and works for some cases and not others. Local numbervar ONE_MIN := 1 / (60 * 24); if {@VisitLength} < ONE_MIN * {?Visitmin} then //suppress visit length less than minimum true the only time it doesn't...
  18. bj1

    Parameters and Formula's

    i tried this: {@BreakDuration} > {@DisplayVisitMinimum} where {@DisplayVisitMinimum} is ToText({?MinVisitLength},0) + &quot; min&quot; + iif({?MinVisitLength}<>1,&quot;s&quot;,&quot;&quot;) and it came up with this error: 'This formula cannot be used because it must be evaluated later' Any...
  19. bj1

    Parameters and Formula's

    Here is the contents of VisitDuration: @VisitDuration is available in the group selection - do i need to add the formula there? Shared numbervar TotalBreaks; local Stringvar HoursText; local StringVar MinsText; local StringVar SecsText; local numbervar nHours; local numbervar nMinutes; local...
  20. bj1

    Parameters and Formula's

    I don't seem to be able to do this because the @VisitDuration isn't in the selection formula list. Why would it not be in there? Thanks, B

Part and Inventory Search

Back
Top