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 bkrike 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: lfcmd
  • Content: Threads
  • Order by date
  1. 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...
  2. 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
  3. 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...
  4. 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...
  5. 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...

Part and Inventory Search

Back
Top