Once had the great pleasure of having to examine our banks End of Day processor. part of the app had the ability to show the account transaction records, which they used to dump transactions to luvly excel spreadsheets for analysis.... the guy who wrote it obviously had never heard of SQL joins though he used a SQL statement along the lines of "Select * from tran" to retrieve all the records, then entered into a mother loop. for each row in result for each column in the result if the datatype is a int, it must be a foreign key do a whole load of messin to work out the foreign key table so do another sql statement to pull back the foreign key value from another table output the foreign key value else output the value end if next column next row. worked out that each time a new transaction was entered onto the system this loop would have to do another 60 or so new SQL requests. so instead of one sql query using multiple joins to get foreign key values, this numpty wrote over 60 queries, which fired for each and every row output. and considering this was only a weeee bank, We did only have in the region of 5 million transactions with about another 100,000 or so a month getting added.. and they wondered why it could take ages to display only a few hundred thousand records and output them.......... :mad:

Count yer self lucky !! I have a Dell Inspiron 9400 (laptop hingy), with a Duo proc T2400 & Nividia Geforce7800 Vid card. I get GPU temps of about 70 degrees celsius when just doing normal app work, and rockets to about a steady 85 degrees when playing games. Should at least keep me nice and warm this coming winter!!

Ahh yes, its all coming back to me. INK and PAPER. sooo self explanatory!!! so now we can have something a bit more colourful like this: 10 RANDOMIZE 1 20 CLS 30 PAPER INT (RND*7) : INK INT(RND*7) 40 PRINT "MY brother smells "; 45 POKE 23692,255 50 GOTO 30 I changed the text to something I would have more likely output at the tender age of 8 or 9 when I got my speccy! ok so I admit I can't remember my ZX spectrum BASIC this well. I found a manual hingy on the web.... http://www.1000bit.net/support/manuali/zxspectrum/contents.htm[^]

Link2006 wrote:

We need a Mac forum

We all know we are mac wearing geeks, but do we really need a forum for it? X|

Ya I started with those as well , The mags I used where called 'INPUT' and you could be certain that if he program was more than 5 lines long, it wouldn't work. Me and my brother would spend hours typing them in on the ZX spectrum (not easy as half rubber keys had rubbed off from playing games) to find they wouldn't work. Then spend ages trying to find a typo. Only to find out in another 5 issues time that yes they had got it wrong and they published some 'errata' to correct the program. :mad: the errata corrections never worked either though!! grrrrrrr was a frustrating time, and hasn't got that much better over the years!!

on the good ole spectrum 48k 10 Print "Hello World" 20 Goto 10 think thats the right syntax! :rolleyes:

Roath Kanel wrote:

Try to download windows vista beta 2 and install your application.

noooooooooo.... Don't do that if you actually need the destination machine to do anything. I foolishy installed it on a whim, but its sooo unstable I wouldn't trust any results. better off waiting to at least the Release Candidate version, which is probably a long way off!

whats stormfront then? got a link fat_boy ?

disregard for international community? The israelis are the main culprit for that.....

digital man wrote:

What, that you make things up as you go along? Methinks it's time for your Stella...

ahh you poor boy, you must be a buckfast drinker, who can only aspire to Stella.........

if you didn't want us to assume , then you should have stated clearly in your orig post, instead of wasting our time................. dunderhead

hmm not sure exactly what your looking for so I'm going to assume you want: the lowest OID for each distinct CODE which is: select CODE, MIN(OID) from tableA group by CODE which would give your desired result. DISTINCT is no way appropriate for what your trying to do in this case!

revert to most recent backup, or prepare to empty your wallet.. or try going through MS details on how to troubleshoot it. How to troubleshoot and repair a damaged Jet 4.0 database in Access 2000: http://support.microsoft.com/kb/209137/[^]

Simple answer - NO unless as mentioned by someone else you are creating an MS access project to hook up to a sql server, if so its just a SQL server stored proc But if its a normal access database you should be able to write your own scalar functions (single return value), but you can not write functions that will return a recordset. unless the consumer of the recordset is another vba function... hope that makes sense, I've not had my coffee yet! Mr ra ra

you can use also use the coalesce() function to remove the Null value. eg. replace - t2sum with - coalesce(t2sum,0) is a nice little function is coalesce as you can list as many variables as you want, it works through from left to right until it finds a non null value and uses that. sounds like its the same as the isNull() function mentioned in previous post. its a SQL server only function though! -- modified at 4:23 Tuesday 18th July, 2006

sounds like you are using an inner join between your queries? try a left or right join. or post you sql and you may get a better response

IT and traveling? not heard of many people doing that. maybe you should become a world renowned terrorist instead, that will keep you moving..:-O

Weiye Chen wrote:

Grats, i am hoping to get one too. But its for gaming purposes.

I just got a spanky Dell Inspiron 9400, with an nvidia graphics card. Similiar spec to the dell XPS gaming laptop, but without the bells and whistles (has no flashy lights) and cost way less .... and to top that i got it from the outlet store, so saved yet more money! where else can you get top of the range laptop for €1300 (including irish vat @21% ) defo recommend it. :-D its a beast, but alas I have crippled the poor wee thing by putting vista beta 2 on it. man that is one unstable, incomplete pile of horse radish. grrr me and my drunkin ideas. :mad:

I too fill my code with sad jokes! I also tend to put wee snippets of the business rules i am implemented