Based on what?

Sean Lange (11/22/2014)

---

Lynn Pettis (11/22/2014)

---

Jeff Moden (11/22/2014)

---

Heh... I've reached the "Overflow Exception"...

It seems that whatever is being done regarding spam posts is effective during the week and then is an epic fail on the weekend. There are 80 posts when...

g.britton (11/22/2014)

---

Lynn Pettis (11/22/2014)

---

g.britton (11/21/2014)

---

Lynn Pettis (11/21/2014)

---

Here is an alternative that does not use a cursor or while loop. You will have to test it yourself to be sure...

Koen Verbeeck (11/22/2014)

---

True, but not always true 😀

Before windowing functions came through...

Jeff Moden (11/22/2014)

---

Heh... I've reached the "Overflow Exception" a couple of times...

g.britton (11/21/2014)

---

Lynn Pettis (11/21/2014)

---

Here is an alternative that does not use a cursor or while loop. You will have to test it yourself to be sure it does what...

Here is an alternative that does not use a cursor or while loop. You will have to test it yourself to be sure it does what you expect.

create table...

roryp 96873 (11/18/2014)

---

Lynn Pettis (11/18/2014)

---

I'm sorry, but there is something wrong with the standings when two teams with identical overall records has the team with a better divisional record ranked...

DataEnthusiast (11/18/2014)

---

Hey guys,

I'm fairly newbie with SQL and have been struggling with this used case. I would appreciate any help.

Table has values:

ID NL1 ...

Here are two article right here on ssc:

http://www.sqlservercentral.com/articles/Hierarchy/94040/

http://www.sqlservercentral.com/articles/T-SQL/94570/

mpdillon (11/18/2014)

---

Lynn,

There is still an error. Notice line 2 and Line 5 are both Item 2. Yet the grid shows a different per item cost $20 and $40, respectively. Line...

SQLRNNR (11/18/2014)

---

Lynn Pettis (11/18/2014)

---

GilaMonster (11/18/2014)

---

Lynn Pettis (11/17/2014)

---

Even in single table queries I recommend using table aliases in the FROM clause and using that alias on the columns in the select...

I'm sorry, but there is something wrong with the standings when two teams with identical overall records has the team with a better divisional record ranked below the team with...

JoseACJr (11/18/2014)

---

Hello!

Can I create a PERSISTED computed column where the value (decimal) is get by a Function ?

See the example:

-- Sales

create table sales(

idSale int identity not null primary...