Search results

a bit more sample data 1065 5 24885.00 2006-06-01 10:52:00 1065 5 24885.00 2006-06-12 00:01:00 1065 5 24885.00 2006-06-19 09:00:00 1065 15 22658.10 2006-06-22 09:59:00 1065 30 22658.10 2006-06-29 17:22:00 1066 60 2185.00 2006-06-05 01:00:00 1066 60 2185.00...

^ wont work mate. need the % complete and total cost data in each record aswell. then you need to GROUP BY so you are back at sq 1.

^ exactly mate, earliest date in the range specified and latest date in the range specified. percentage + cost can go up or down, so record 1 could be 100%, £5000 and then change at a later date to say 80% and £6000 (jobs that get finished and then client adds more work on top last min)...

I thought and tried using UNION aswell mate, would still mean trying to get 1 record for each projectid (MIN and MAX) .... again unless ive missed somethin Be very interested to see what a SQL Dev would recommend :) Heres my query in sql which works, not quite finished, however its not...

Im thinking the best way is to loop the select statement using a cursor and dumping the first and last entry for each project in a temp table, then return all the records from the temp table? .... unless ive missed something ?

not complicated, think ive been at a while too long today, bet the answer is staring me in the face. here is the sample data returned from my current query. 1109 83 1897.50 2006-06-05 01:00:00 1109 100 1897.50 2006-06-06 12:20:00 1110 60 5269.90 2006-06-05 00:01:00 1110 75 5269.90...

Its not that i cant find a solution, its just im not happy with the one i have, want to make it more efficient. If anyone is up for it, i will post up the task :D

I like my N80 especially with new firmware. However the slider is a pile of sh*te, whoever designed that wants sacking then shooting.

A few weeks back toysrus had forza + 12 month sub for 19.99, might be worth popping in to see if they have any in.

20-25 quid for 12 month sub off ebay. BTW - Dont buy a US code because they dont work over here.

http://www.linksys.com/servlet/Satellite?c=L_Product_C2&childpagename=US%2FLayout&cid=1134691947479&pagename=Linksys%2FCommon%2FVisitorWrapper We have a few axis cameras at work, I know they can be quite expensive though

There seems to be a lot of demos with frame rate issues. Goin to set this off tonite i think and take a look.

I would have thought Sony would want as many sales as they can get at the present time. I would be selling to any tom, dick and harry who wanted one.

Apparently Sony are trying to stop imports of the PS3 ... http://gaming.hexus.net/content/item.php?item=7069

reckon if ps3 made it over here in time for xmas you would be makin £500 easy. march/april next year, doubt it anything will be made as supply should outstrip demand.

Look at this cheeky fooker .. http://cgi.ebay.com/Sony-Playstation-3-Premium-60gb-PS3-Bundle-No-Reserve_W0QQitemZ290042315447QQihZ019QQcategoryZ62054QQrdZ1QQcmdZViewItem

ebay seems to be gaining speed on pre-order sales now in the US, most are $1500+ http://cgi.ebay.com/Sony-Playstation-3-PS3-System-Console-60GB-Pre-Sale_W0QQitemZ200038956038QQihZ010QQcategoryZ62054QQrdZ1QQcmdZViewItem what would be interesting is to know how many land in the US and how...

Just ordered this :) ... http://www.play-asia.com/paOS-13-71-fc-49-en-70-1o6i.html

http://www.dabs.com/productview.aspx?Quicklinx=42T5&SearchType=1&SearchTerms=sony+vaio&PageMode=3&SearchKey=All&SearchMode=All&NavigationKey=0 A few people i know have these and they are quite smart and will probably be worth twice as much as the acer in 3 years time for resale.

What bluetooth GPS unit are you using with the N80 ?

Installed this handy auto-lock app at wkend and works a treat.. http://www.allaboutsymbian.com/software/item/AutoLock.php I looked and looked but couldnt find the option on the phone (probably under my nose !) .. This looks like a bit of fun aswell ...

http://www.toysrus.co.uk/Product.aspx/TruHome/TruVideoGames/TruVideoGamesXbox360/TruVideoGamesXbox360Consoles/875384 360 Prem + 2 Wireless + 4 Games - £299 ...... .... Out of stock thou but worth keeping your eye on. Think there will be some great deals like this coming up in the next...

I pre-ordered a wii from pcworld and as far as i know they havent charged me yet.

Got the demos for each of these over the wkend. Can't say i was too impressed with NFS, play that and then play PGR3, like taking a step back 3 years. PGR3 + all the modding + nitrous etc would be fun ! Tiger woods seemed ok, will wait for full reviews on this and then might purchase it...

Unless your programming some proper low level sh*t (C++ etc..) VB.Net is fine and will do everything you need. Don't get VS6, its a massive step back from what is available now with VS2005 and .Net 2.0 Ive been developing for around 10 years and either vb.net or c# does everything you will...

sneeks - you have a 360 dont u ? you will be able to stream music, pictures and videos to your 360 with the media center pc (inc xvid movies with a free bit of software - transcode360)

Dont understand what you are going to gain from getting a PS3 over a 360 ?? A few different games maybe but surely no noticeable quality differences in gameplay/graphics for a long long time.

http://www.allaboutsymbian.com Search for diego and phoenix on here for more info. There is a risk with flashing any device so be careful if you decide to go ahead as it could end up 'dead'. Also search on google for n80 update / n80 firmware update. I got 3 different sets of instructions...

think this is about the best deal knocking about at the moment .. http://www.hmv.co.uk/hmvweb/displayProductDetails.do?ctx=280;-1;-1;-1&sku=570323

Well i decided im not waiting any longer for Orange or Nokia to pull their finger out (as it will never happen me thinks) so took the plunge and flashed mine with the generic and luckily it worked fine. Now on ... v. 4.0623.0.41 26-07-2006 RM-92 :D