Completed

SQL Server Bug Help

Hello coders a while back I had a coder write me up a sql process that would generate a section in a report that my database would generate on a daily basis. For those familiar with basketball it would take a look at the value in the hc column of the team in the database and then would sum up a number of stats that the team has accumulated in certain scenarios. You can have a look at the sql file to get an idea what the process does as I have included that the report and the aspx file that it interacts with in my web browser. Now everything works great except when there is a coaching change in the middle of the season. Once that happens for some reason it will only populate the first line and then move onto the next section of the report. I cant figure out why and it has to be something really silly that I am missing here.

If you take a look at Chicago Bulls coach history in the report text file you will see what I am talking about. Compare that to say the Denver Nuggets coach history below it and there is a big difference. You see the Bulls fired their coach about 3 weeks ago so the hc column has the new coach in there now but the report still doesnt work. That first line of data is still actually the old coach.

So the project is, you connect to my pc, I walk you through the database and reporting process and you find the bug so that this works correctly. While this is a minor inconvenience to me I am not going to pay a lot of money for this, $50 tops. I have a ton of sql server work to hand out in the next couple months so I am on the lookout for someone that does know sql very well and this could be an audition in some way for more future work. Let me know if you have any questions.

Skills: C# Programming, Microsoft SQL Server, MySQL, PHP, SQL

See more: sql server bugs, sql server support, microsoft connect portal, microsoft sql server user voice, microsoft sql server support, sql server suggestion, sql server uservoice, sql server ideas, read pdf docs sql server, store image sql server 2005 table, remove sql server 2005 free, sql server automated backup, write code transfer data sql server excel, convert oracle sql scripts sql server, upgrade crm sql server 2008, sql server 2005 developer required skills, save image data sql server 2005, retail pro sql server 2005, open save pdf file sql server, xml files sql server vbnet

About the Employer:
( 248 reviews ) Chicago, United States

Project ID: #18545173

Awarded to:

sergioeliot3

Hi there. I hope you are doing well. My name is Sergio and I am a software developer dedicated 100% here in the marketplace. I have read the project description and I would like to have the chance to connect More

$50 USD in 1 day
(94 Reviews)
6.5

5 freelancers are bidding on average $62 for this job

ChineseJin

Hello Dear! I read your project proposal carefully and understood clearly what you want. I am high skilled and rich experienced for your project.. If you want I can show you my skill and my past works to confirm my More

$133 USD in 3 days
(7 Reviews)
2.2
jawadkhan11

hi . .

$30 USD in 3 days
(0 Reviews)
0.0
techguykailash

Hi, Hope You are doing well. I am having 4.5 years of experience and strong knowledge on writing SQL queries and database programming. I have worked on SQL Server and Oracle both. So I can fix the bug if you walk More

$50 USD in 3 days
(0 Reviews)
0.0
oleksiyyurchyna

Hi, I have wide knowledge in creating and tuning SQL queries on MS SQL Server. Would be glad to help you with your issue to fix a bug.

$45 USD in 3 days
(0 Reviews)
0.0