T-SQL Store Procedure

Timeline By 3:00 pm September 28, 2005. I need a quick turn around time on this one. Do not bid if you can’t deliver within this timeframe. I’m not sure when I will accept the bid. Ideally the coder should have a solution in mind and just need to code it once I accept the bid. This is for T-SQL programmers ONLY. The code should work on a computer that has MS SQL 2000. The code should be 100% T-SQL all in ONE store procedure that out the data in a temporary table. Please take a look at the screenshot while reading this posting What you are asked to do is that an existing hourly table convert the data1 and data2 fields to be a result as a summation per day. Take a look at the screenshot to see how the datetime is stored as seconds. The tricky part are as follows: - a day is are defined as 9:00 am to 8:59am the next day. For example August 1 9:00 am to August 2, 8:59 am is sum to August 1. - in the hourly table there are 2 version of data; version 0 or version ??"100000. What I need is in the same store procedure is select version ??"100000 ONLY if it exist, if not then select version 0 - implement and return the result in ONE store procedure (no views, other store procedure, etc) - inside the store procedure I like to see if (at)DEBUG = ‘Y’ the SELECT query to demonstration that day range are correct; data version selection is done correctly. So the deliverable is to have ONE store procedure that returns the result of the daily summation of the hourly table. Given the criteria above. I will supply the data for the coder to work with. At the beginning I would expect the coder to come out with test data so that he can start coding immediately and when my test data is sent there is little delay in just waiting. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables) by the Seller in ready-to-run condition in the Buyer's environment. 3) Coder will not resell/used/distribute any documents and source code that was used in the creation of this project. 3) Coder will delete/destroy all documents and source code related to this project within 90 days of completion. 4) Complete ownership and distribution copyrights to all work purchased. 5) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform MS SQL 2000