And PS....I know this is terrible database design...have to work with what I was given unfortunately.

<MAIN QUERY>

<cfquery name = "getData" datasource = "db">

SELECT id, name, date FROM table

</cfquery>

<LOOP>

<cfloop query =...

May be better suited for developers with CF experience. I'm an SQL developer, not CF so had this project been given to me off the bat I would've had...

PS - I understand the queries within the original loop do not match, it was a copy and paste effort from my original code to quicken things up 😀

Vijay,

I would take a look at this workbench off of SimpleTalk. It explains everything you are looking for and then some in depth, and also shows multiple ways of...

Thank you for a great article, Dave. I never really thought of using any of these commands as I normally would place data into temp tables to run JOIN...

Thanks Lowell. The 811 after EDI refers to the format of the feed (e.g. EDI 810 and EDI 811 are invoicing EDI feeds in X12). There are others...

Thanks, Jeff! I appreciate the kind words and the welcome aboard.

Jeffrey Williams-493691 (4/30/2010)

---

I have to agree with the others, good start on posting. I did want to point...

Thanks, Seth! After reading these forums for months, I know how much easier it makes it on those who are willing to help when you have the code at...

Dave - Not a bad idea on utilizing Views and combining them into one master table. This still, however, would require MAJOR development cycles as the data is used...

David Portas (4/30/2010)

---

So you have a badly designed application and therefore you have to work around it in the database. Fair enough, we've all been there. 180 million rows is...

Lowell (4/30/2010)

---

excellent point, David. sometimes you...

Because that's not the way the system is designed. And querying from our CF front-end application is much faster on a 15,000,000 record table rather than a 180,000,000+ record...

Lowell - That was it! For some reason I thought that first single quote would terminate the entire statement and not follow through with the rest of my CASE...

I had a similar issue in our production environment where our transaction log was growing to unacceptable sizes after bulk data loads. In my case, the transaction log was...