Ahh my favorite of all SQL Arguments...WITH CUBE! The description alone is priceless... "The WITH CUBE arguments lets you direct SQL Server to introduce summary rows to the result set, in addition to the rows provided by the GROUP BY clause. This clause essentially results in a data explosion that returns a multidimensional cube."
What I really want is a WITH MULTIPHASIC SHIELD ARRAY clause though... :-) Sorry for the OT...but it's not ofter that with cube is mentioned in public. jon ----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 30, 2001 3:01 PM Subject: RE: Really delayed evaluation > within your query. In SQL Server, you can do this with the WITH CUBE and ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
