Sorry, my bad. I misinterpreted his question. :( -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 1:57 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??)
Ryan, Yes, I agree with you. You can wrap your query in a stored proc and it may indeed be faster and provide a level of abstraction. But, I sensed that he was saying there was no way to do this in a query - that he would have to write a lengthy case statement or temp table or whatever to accomplish this. I just wanted to point out that there are date functions that can sort out his data for him. -mk -----Original Message----- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:42 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??) 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? ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
