ASP Script Maxes CPU

I have been working on this issue for a while and found this forum and thought it wouldnt hurt to post it. I have recently upsized a shop to SQL server.I am running on a Windows 2003 Server running multiple websites. Ihave full access to this server.The shop works fine and orders are taken into the database after the SQL upsize.There is one page that is causing major problems.When this page is brought up, it maxes the CPU to 100% and i can seedllhost.exe is maxed out (one instance of it)I have looked thru my code for infinite loops and have debugged and iknow the issue lies somewhere in the code i am posting here. anyonewho can help, i would appreciate it.Keep in mind that with the access database the page that causes theCPU to max out runs fine.The code is attached in a text file.