You did a great job posting ddl and sample data. However, you didn't provide any details about what you want to happen here. Can you explain what query you trying...

Jeff Moden (5/19/2016)

---

TheRedneckDBA (5/19/2016)

---

What about charging a one-time small fee to be a user of SQLServerCentral.com? Something like $2? (Or whatever the minimum charge would have to be...

Great question to end the week.

Something like this perhaps?

DECLARE @A AS INT;

DECLARE @b-2 AS INT;

DECLARE @Parameter1 AS INT;

DECLARE @Parameter2 AS INT;

DECLARE @Parameter3 AS INT;

DECLARE @Parameter4 AS INT;

select @Parameter1 = case @A when 1 then 77...

You will become familiar with both the backup and restore commands....

Lowell (5/16/2016)

---

Complete non-sequitur here guys, but I'm rather pleased with myself.

I just got my MCSA after taking 70-463 Implementing a Data Warehouse in SQL Server 2012/2014.

I had set a mental...

Hugo Kornelis (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Young people have a tough enough time of it as it is. Imagine this: girls bathroom in high school, half a dozen excitable and sensitive girls pottering...

Awesome stuff. I am glad I can send links to people now that won't complain about being required to signup first. Of course I still always suggest that they should!!!

SQLRNNR (5/13/2016)

---

Sean Lange (5/13/2016)

---

tindog (5/13/2016)

---

Sean Lange (5/13/2016)

---

tindog (5/13/2016)

---

Sean Lange (5/13/2016)

---

Luis Cazares (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

Brandie Tarvin (5/13/2016)

---

For those who hadn't heard, THIS happened.

Yay.

EDIT: I should add I'm not trying to...

tindog (5/13/2016)

---

Sean Lange (5/13/2016)

---

tindog (5/13/2016)

---

Sean Lange (5/13/2016)

---

Luis Cazares (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

Brandie Tarvin (5/13/2016)

---

For those who hadn't heard, THIS happened.

Yay.

EDIT: I should add I'm not trying to start a debate....

tindog (5/13/2016)

---

Sean Lange (5/13/2016)

---

Luis Cazares (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

Brandie Tarvin (5/13/2016)

---

For those who hadn't heard, THIS happened.

Yay.

EDIT: I should add I'm not trying to start a debate. I just wanted...

Luis Cazares (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

Brandie Tarvin (5/13/2016)

---

For those who hadn't heard, THIS happened.

Yay.

EDIT: I should add I'm not trying to start a debate. I just wanted to pass along...

IMHO people should use...

J Livingston SQL (5/12/2016)

---

Sean Lange (5/12/2016)

---

sestell1 (5/12/2016)

---

Yea, very strange. I'm curious as to why it's an issue suddenly now?

Automatic suppression of posts reported as spam by a certain threshold...

Eric M Russell (5/12/2016)

---

sestell1 (5/12/2016)

---

Eric M Russell (5/12/2016)

---

There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are...