Recent content by lfcmd

Thansk for that Denis

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

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...

cheers guys

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

the average speed excluding all zero speeds cheers George

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 ?

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...

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...

cheers for that lovely stuff

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

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

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...

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...