At least I know the list is working. I was having doubts yesterday. You might as well read the latest article by Robert Chartier on 15Secs:
http://www.15seconds.com/issue/020730.htm > Ok, To bide the time, a quick SQL question. > > From good ol' Northwind, the following query: > > SELECT o.OrderID, > Max(od.Quantity) as TopItem, > Sum(od.Quantity) as TotalBought > FROM > Orders o, > [Order Details] od, > Products p > WHERE > o.OrderID = od.OrderID AND > od.ProductID=p.ProductID > GROUP BY o.OrderID > ORDER BY TotalBought DESC > > Display the name of the product that matches the TopItem column... > > Cheers, > Andrew > > > -----Original Message----- > From: Nathan Steiner [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 30 July 2002 11:05 PM > To: ActiveServerPages > Subject: RE: slow day > > > What about Rankine, Reaumur, and Kelvin? > > Formulas > F - > Rankine.......F+459.67=R > F - > Celsius.......(F-32)*5/9=C > F - > Reaumur.......(F-32)*4/9=RE > C - > Kelvin........C+273.15=K > C - > Fahrenheit....(C*9)/5+32 > C - > Reaumur.......C*4/5=RE > > From: > http://students.washington.edu/kyle/tempprog.html > > Man, it is slow.... > > http://google.yahoo.com/bin/query?p=celsius+to+fahrenheit&hc=0&hs=2 > > -ns > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 30, 2002 8:27 AM > To: ActiveServerPages > Subject: RE: slow day > > > now we just need a webservice that we can call to > handle the conversion for us. > > Depends on which way you're going... > > > > (n * 9/5) + 32 converts from C to F > > > > (n - 32) * 5/9 converts F to C > > > > -----Original Message----- > > From: Scott [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, July 30, 2002 8:05 AM > > To: ActiveServerPages > > Subject: Re: slow day > > > > > > I know there's a "subtract 32" in there somewhere... ;) > > > > > > ----- Original Message ----- > > From: "Michael Gardner" <[EMAIL PROTECTED]> > > To: "ActiveServerPages" <[EMAIL PROTECTED]> > > Sent: Tuesday, July 30, 2002 10:57 PM > > Subject: RE: slow day > > > > > > : *hits forehead on table attempting to remember how to > > : convert to Celcius as I have not done it in years* > > : > > : Part of the problem with being an American...it allows > > : you the opportunity to become stupid. > > : > > : > > : Wow, that is a wee bit warmer than here...and I > > : thought 96 with 75% humidity was bad. Anything over > > : 100, no matter the humidity, is hot unless maybe you > > : are in a sauna... :) > > : > > : > > : ---Michael > > : > > : > > : --- "Jon Butler (Mailing Lists)" > > : <[EMAIL PROTECTED]> wrote: > > : > 43?!? Wow! And I was about to complain that it's > > : > expected to get to 33 deg. > > : > Celsius this here, with 100% humidity ... but now I > > : > won't! Here we go by > > : > Farenheit though, and you have to admit that a heat > > : > index of 106 does sound > > : > rather imposing. :) > > : > > > : > > -----Original Message----- > > : > > From: Kangaroo's Dream > > : > [mailto:[EMAIL PROTECTED]] > > : > > Sent: Tuesday, July 30, 2002 8:54 AM > > : > > To: ActiveServerPages > > : > > Subject: Re: slow day > > : > > > > : > > > > : > > I am getting 43 degrees in the shade of our porch > > : > and we have > > : > > a humidity factor of 75%. So the only asp joke > > : > is Chillisoft? > > : > > ----- Original Message ----- > > : > > From: "Marco de Groot" <[EMAIL PROTECTED]> > > : > > To: "ActiveServerPages" > > : > <[EMAIL PROTECTED]> > > : > > Sent: Tuesday, July 30, 2002 1:02 PM > > : > > Subject: RE: slow day > > : > > > > : > > > > : > > For you perhaps... > > : > > Over here 5 days above 30 degrees is called a > > : > heatwave... > > : > > > > : > > These temperatures are not really common around > > : > here (The Netherlands) > > : > > > > : > > :) > > : > > > > : > > Good luck with your 49... > > : > > > > : > > > > : > > -----Original Message----- > > : > > From: Kuminda Chandimith > > : > [mailto:[EMAIL PROTECTED]] > > : > > Sent: dinsdag 30 juli 2002 12:42 > > : > > To: ActiveServerPages > > : > > Subject: RE: slow day > > : > > > > : > > > > : > > How About 45 degrees here!! (49 two days a go one > > : > more degree > > : > > and we get a holiday !!) > > : > > > > : > > and you are complaining about 35. Now thats > > : > Joke!!! > > : > > > > : > > > > : > > Kuminda Chandimith > > : > > Sr. Technical Consultant > > : > > Ducont.com FZ-LLC > > : > > Tel: + 971-4-3913000 Ext 237 > > : > > Fax: +971-4-3913001 > > : > > http://www.ducont.com > > : > > > > : > > > > : > > > > : > > -----Original Message----- > > : > > From: Marco de Groot > > : > [mailto:[EMAIL PROTECTED]] > > : > > Sent: 30 July 2002 13:29 > > : > > To: ActiveServerPages > > : > > Subject: RE: slow day > > : > > > > : > > > > : > > It's about 35 degrees celcius out here... > > : > > Pfff.... > > : > > > > : > > marco > > : > > > > : > > -----Original Message----- > > : > > From: Kangaroo's Dream > > : > [mailto:[EMAIL PROTECTED]] > > : > > Sent: dinsdag 30 juli 2002 10:38 > > : > > To: ActiveServerPages > > : > > Subject: Re: slow day > > : > > > > : > > > > : > > It is a REALLY slow day > > : > > ----- Original Message ----- > > : > > From: "Michael J. Ryan" > > : > <[EMAIL PROTECTED]> > > : > > To: "ActiveServerPages" > > : > <[EMAIL PROTECTED]> > > : > > Sent: Tuesday, July 30, 2002 3:32 AM > > : > > Subject: slow day > > : > > > > : > > > > : > > > was it just a REALLY slow day today? used to > > : > seeing more than this > > : > > > when I check in.. > > : > > > > > : > > > > > : > > > > : > > > : ====================================================================== > > : > > > = > > : > > > Michael J. Ryan - tracker1 at theroughnecks > > : > dot com > > : > > Roughneck BBS: > > : > > > http://www.theroughnecks.net > > : > > telnet://theroughnecks.net > > : > > > > > : > > > > : > > > : ============================================================== > > : > > ========= > > : > > > Y!: aztracker1 - aim: azTracker1 - icq: 4935386 > > : > - msn: see > > : > > email One > > : > > > program for aim/icq/yahoo/msn/irc - > > : > http://www.trillian.cc/ > > : > > > > > : > > > > > : > > > --- > > : > > > You are currently subscribed to > > : > activeserverpages as: > > : > > [EMAIL PROTECTED] > > : > > > To unsubscribe send a blank email to > > : > > %%email.unsub%% > > : > > > > > : > > > > : > > --- > > : > > You are currently subscribed to activeserverpages > > : > as: > > : > > [EMAIL PROTECTED] To unsubscribe send a blank > > : > email to > > : > > %%email.unsub%% > > : > > > > : > > > > : > > > > : > > > : ********************************************************************** > > : > > This email and any files transmitted with it are > > : > confidential > > : > > and intended solely for the use of the individual > > : > or entity > > : > > to whom they are addressed. If you have received > > : > this email > > : > > in error please notify the system manager. > > : > > > > : > > This footnote also confirms that this email > > : > message has been > > : > > swept by the latest anti-virus software for the > > : > presence of > > : > > computer viruses. > > : > > > > : > www.motiv.nl > > : > > > : ********************************************************************** > > : > > > : > > > : > --- > > : > You are currently subscribed to activeserverpages > > : > as: [EMAIL PROTECTED] To > > : > unsubscribe send a blank email to %%email.unsub%% > > : > > > : > --- > > : > You are currently subscribed to activeserverpages > > : > as: [EMAIL PROTECTED] > > : > To unsubscribe send a blank email to %%email.unsub%% > > : > > > : > --- > > : > You are currently subscribed to activeserverpages > > : > as: > > : > [EMAIL PROTECTED] To unsubscribe send a > > : > blank email to > > : > %%email.unsub%% > > : > > > : > > > : > --- > > : > You are currently subscribed to activeserverpages > > : > as: [EMAIL PROTECTED] > > : > To unsubscribe send a blank email to > > : > %%email.unsub%% > > : > > > : > --- > > : > You are currently subscribed to activeserverpages > > : > as: [EMAIL PROTECTED] > > : > To unsubscribe send a blank email to > > : %%email.unsub%% > > : > > : > > : __________________________________________________ > > : Do You Yahoo!? > > : Yahoo! Health - Feel better, live better > > : http://health.yahoo.com > > : > > : --- > > : You are currently subscribed to activeserverpages as: > > [EMAIL PROTECTED] > > : To unsubscribe send a blank email to > > %%email.unsub%% > > > > > > > > --- > > You are currently subscribed to activeserverpages as: > > [EMAIL PROTECTED] To unsubscribe send a blank email to > > %%email.unsub%% > > > > --- > > Incoming mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002 > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002 > > > > > > > > --- > > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] > > To unsubscribe send a blank email to > > %%email.unsub%% > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > %%email.unsub%% > > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
