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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lfcmd

  1. lfcmd

    Generate A AutoNumber

    Thansk for that Denis
  2. lfcmd

    Generate A AutoNumber

    You cant create a Temp Table when using a view in sql server 2005 ?, The reason i need this is, i am running one view against another, and need to be able to check a record against the next record in sequence
  3. lfcmd

    Generate A AutoNumber

    HI All When i run a view from sqlserver i would like for it to return a autonumber against each item selected How would i go about this Simple Example Table setup Name Age M 18 C 19 D 18 F 21 G 18 Code: Select * from table where age ='18' Result i would like...
  4. lfcmd

    Difference Between Two Times

    cheers guys
  5. lfcmd

    Difference Between Two Times

    If i have two time fields stored as type nvarchar how can i find the differnce in time between the 2 time 12:02 12:38 returning 0:36
  6. lfcmd

    Time Tracking

    the average speed excluding all zero speeds cheers George
  7. lfcmd

    Time Tracking

    Cheers George, look good should be able to tweak it to what i need would there be much involved in getting the average speed for each journy ?
  8. lfcmd

    Time Tracking

    Yes sorry shoudl have read as follows Name Time Locat Speed Unit1 10:00 Mallow 40 Unit1 10:01 Yail 40 Unit1 10:02 Yail 40 Unit1 10:03 Yail 40 Unit1 10:04 Yail 0 Unit1 10:05 Yail 0 Unit1...
  9. lfcmd

    Time Tracking

    Hi Group, I have a tracker device and need generate a report which shows the start time, stop time and resume time. the veicle is classed as stoped when the speed is returned three tiems with a speed of zero Name Time Locat Speed Unit1 10:00 Mallow 40 Unit1 10:01...
  10. lfcmd

    Duplicate area problem

    cheers for that lovely stuff
  11. lfcmd

    Duplicate area problem

    no not case - sesitive "area" column is integer no trailing spaces after the names
  12. lfcmd

    Duplicate area problem

    ye had tried somethin along those lines and just tried your example there now but getting no records returned when i run the query
  13. lfcmd

    Duplicate area problem

    Hi All Quick Query, i have table that basically looks like CName Id Area Dunnes 10 11 Dunnes 10 12 Quinn 11 13 Quinn 11 14 Quinn 11 11 Tesco 12 12 Tesco 12 13 From the example above i want to find all CName whos name is...
  14. lfcmd

    Idle Time

    Hi Group, I have a database which gets a record wriiten to it once every minute for each indvidual fone on are system but only if the fone is in use, if the fone is not in use no record is written to the database What i am trying to do is Select the overally time, between set dates, that a...
See more

Part and Inventory Search

Back
Top