I agree to disagree.

I will agree to disagree. Just saying, though, Microsoft doesn't always know best how each server (or database) should be configured. Just look at the default for setup...

Really? Just because SQL Server setup defaults to a CI collation that makes it the "DEFAULT" collation?

I give up.

Okay, walking away. I apologize for not agreeing that the SQL Server default collation is a CI collation based on the fact that it is what is selected when...

Sean Lange (6/25/2014)

---

Ed Wagner (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

Ed Wagner (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a...

pwalter83 (6/25/2014)

---

Jeff Moden (6/25/2014)

---

pwalter83 (6/25/2014)

---

Lynn Pettis (6/25/2014)

---

EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.

I found the problem,...

I define default as the setting used when initially installing SQL Server. I don't define it as the default used if not specified when initially installing SQL Server unless...

Jeff Moden (6/25/2014)

---

pwalter83 (6/25/2014)

---

Lynn Pettis (6/25/2014)

---

EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.

I found the problem, try...

Raghavendra Mudugal (6/25/2014)

---

Lynn Pettis (6/25/2014)

---

Sean Pearce (6/25/2014)

---

No, it would be better...

Sean Pearce (6/25/2014)

---

No, it would be better to assume the default...

I got it wrong because I didn't take into account the possibility that the question assumed a case insensitive collation. As posted both queries will return 1 row each...

Okay, stepped away from a problem for a while. Looked at it again today and saw a problem with a running total issue. A simple fix to code...

Ed Wagner (6/25/2014)

---

djj (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone...

Please explain what it is you are trying to accomplish? Is case 2 trying to show current running totals for the weeks 18 to 23 but include the calculations...

pwalter83 (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

The issue is a lack of clarity.

Don't give up. Have a look at the result of this:

IF OBJECT_ID ('tempdb..#GLT') IS NOT NULL DROP TABLE #GLT

CREATE TABLE #GLT (

[Sequence]...