Ben Doom wrote: > If you need to do it in pure SQL, I don't know how to help you. You'd > probably need to write an iterator in T-SQL. > > In CF, you could grab each half-hour by using a 'between' argument in > your where clause. > > Does that help at all? > > --Ben >
Yes. If I can use the 'between' statement in CF I can use it in SQL. Just trying to do it without making the QUERY overly complicated. As it stands now it takes about 10 seconds to run the query. That is about 9 seconds more then I want it too. Anything under 15 seconds is considered acceptable. Anything under 5 seconds would be optimal. The simplest thing to do is put it into another table or cursor as 15 minute intervals. That might actually be worth it. -- 2004 - The year $184M couldn't buy a pennant. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:5:135102 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
