Nah. I cheated and used poorsql.com. 😉

This is yet another reason, in the extremely long list, of why you should use the proper datatypes. Since you are storing datetime data as character data you don't have...

Here it is with some formatting.

SELECT lb.loanid

,lb.clientid

,lb2.beginning_loan_balance AS beginning_loan_balance

,SUM(lb.sales) AS sales

,NULL AS ar_turn

,NULL AS loan_turn

,0 AS minimum_interest

,SUM(lb.collections) AS collections

,lb1.previous_collateral_value AS beginning_collateral_balance

,MAX(lb.float_days) AS float_days

,

--using formula for the yield rate

MAX((

lb.interest_rate + ISNULL(lb.default_rate,...

and promptly forgotten so we can repeat ourselves.

Personally I detest questions like this. This is testing our ability to be a human compiler and debug code that faced with in the real world I would toss out...

That means the column isn't in the table. Also, if you are going to use the TOP 1 solution posted by Eirikur you...

This is commonly referred to around here as "the quote bug". It has been around a long time. I don't know if it is difficult to fix or just not...

Pony Express

artisticcheese (9/9/2014)

---

I narrowed down the issue to statistics, updating statistics on 3 tables used in quyery query complete immediately. No index rebuild necessary.

Estimated execution plan before statistics was updated and...

TBIG (9/9/2014)

---

When I run this script on my local dev server from SSMS, it works as it should.

When I run this script from SSMS on my database server in the...

Lynn Pettis (9/9/2014)

---

Sean Lange (9/9/2014)

---

Koen Verbeeck (9/9/2014)

---

Sean Lange (9/9/2014)

---

Koen Verbeeck (9/9/2014)

---

Steve Jones - SSC Editor (9/9/2014)

---

BTW, it's not that kids aren't important, but it's a balance. I don't look at...

artisticcheese (9/9/2014)

---

I know it hangs on row 88 becouse that's the last row I see in output. Output appears exactly 3 seconds (like first query is finished) and quickly shows...

Koen Verbeeck (9/9/2014)

---

Sean Lange (9/9/2014)

---

Koen Verbeeck (9/9/2014)

---

Steve Jones - SSC Editor (9/9/2014)

---

BTW, it's not that kids aren't important, but it's a balance. I don't look at it as "if I...

artisticcheese (9/9/2014)

---

Yes, that's all I did and yes I believe it's not performance/unoptimized queries issue.

If it would be any of those then results would eventually come up and it would...

Koen Verbeeck (9/9/2014)

---

Steve Jones - SSC Editor (9/9/2014)

---

BTW, it's not that kids aren't important, but it's a balance. I don't look at it as "if I died tomorrow". If I...