Well of course one can write a sp to do it but it would be so nice to just have it in a single query.
Tyler Clendenin GSL Solutions -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 7:59 AM To: CF-Talk Subject: Re: SQL: Brain Teaser Tyler Clendenin wrote: > Ahh if only there was a way to do that I would be so happy. Why wouldn't there be a way to do that? What DBMS are you using? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4