Just my two cents... We've found that SP's are much much quicker than queries. So even if you could do it in a query, you may want to consider a stored proc. At least do some performance testing on both.
-----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 1:42 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??) James, Stored procs are great - and a great idea, but why for this specific thing? Couldn't you do it in a query? select blah blah..... WHERE month(columname) = month(gedate()) -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:27 PM To: CF-Talk Subject: Listing Current Activity (Stored Procedure??) I believe I need a stored procedure for this, but I thought I would ask anyway. I want to be able to list the current month's activity from the first of the month to the current date. In other words, a live data dump from 1st to current date. Am I correct in guessing stored procedure? ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists