Well SQL Server will link the tables together based on the joins you specified. Just making some hopefully not crazy assumptions about your table designs, you would get 1...

Ed Wagner (3/28/2016)

---

Iwas Bornready (3/28/2016)

---

Steve Jones - SSC Editor (3/25/2016)

---

DBA_Rob (3/25/2016)

---

I can't think of a SQL Server environment where I didn't end up needing to turn on mixed authentication, but...

djackson 22568 (3/25/2016)

---

ZZartin (3/25/2016)

---

Hmm... a good password on the sa account should sufficient, I wouldn't want to disable it in the event it's actually needed. And I certainly wouldn't...

Hmm... a good password on the sa account should sufficient, I wouldn't want to disable it in the event it's actually needed. And I certainly wouldn't want to turn...

Steve Jones - SSC Editor (3/24/2016)

---

GoofyGuy (3/24/2016)

---

Gary Varga (3/24/2016)

---

Steve Jones - SSC Editor (3/24/2016)

---

...if you're selling on multiple platforms, I never understood why you didn't have a team optimizing for...

It's more an issue of how many people are willing to accept things that can easily be improved. There's usually not as much value in today's age in squeezing...

Shouldn't it be COUNT(DISTINCT Played) >= 3, in case some decides to play 'switch kick to the nuts'? 😛

This code doesn't look the greatest but it might do what you want. But how do you plan to handle it when there are multiple solutions? For example...

sql-lover (3/22/2016)

---

None!

It just does not...

Yes, I can fully understand this as I have experienced it as well in past. Smile I really appreciate the help been provided. But I already mentioned this criteria in...

What error message is that user getting if you run just the EXECUTE master..sqlbackup ...... without any of the dynamic SQL or cross server stuff?

I think there's a basic lack of job centric training for people looking to get into IT. Unless you're interested in changing mice and running cables there aren't really...

Jeff Moden (3/21/2016)

---

ZZartin (3/21/2016)

---

Hmm.... with the way technology is moving and I find this true in general not just IT the ability to acquire knowledge is far more valuable than...

Hmm.... with the way technology is moving and I find this true in general not just IT the ability to acquire knowledge is far more valuable than the ability to...

Whales