This could a good start :

Choose an Authentication Mode

the "Connecting Through SQL Server Authentication" section.

Cheers,

Iulian

In the first part you get the last payment date for each customer, from orders table:

;WITH CTE_LastOrder (CustomerID, LastOrderDate) As

(

SELECT CustomerID, MAX(PaymentDate) LastOrderDate

FROM [Order]

GROUP By CustomerId

)

This looks OK to...

Thank you Don for the question. Nice one.

Thank you to Okbangas and Eirikur for putting together the sample.

Thumb up!

Cheers,

Iulian

hjp (9/18/2014)

---

No, it's not. It's a math...

yes, I ignored that one too 🙂

Cheers,

Iulian

That was a lovely exercise, thank you Shiva.

Iulian

nice one , thank you for this qotd

Iulian

Nice one, thank you, and the article is prety strighforward

Stewart "Arturius" Campbell (9/12/2014)

---

Just...

Stewart "Arturius" Campbell (9/12/2014)

---

Iulian -207023 (9/12/2014)

---

GilaMonster (9/12/2014)

---

Meow Now (9/11/2014)

---

I was asked this very thing in an interview a while back. Except, they wanted to know if a TRUNCATE was fully...

GilaMonster (9/12/2014)

---

Meow Now (9/11/2014)

---

I was asked this very thing in an interview a while back. Except, they wanted to know if a TRUNCATE was fully or minimally logged. While I...

ouch, why have a assumed the table Employees exist !? :Wow:

Nice question, thank you for spotting it

Iulian

TomThomson (9/11/2014)

---

Iulian -207023 (9/11/2014)

---

What happens if while the pages are deallocated , another task / process / txn ( or something ) allocates that space for other...

j.green (9/11/2014)

---

What happens if while the pages are deallocated , another task / process / txn ( or something ) allocates that space for other purposes , and I run...