You could use SSIS for that. To create the packages more easily, you could use the Import/Export wizard.

Uptown

Lynn Pettis (6/9/2016)

---

Sean Lange (6/9/2016)

---

This still is not really very clear what you are trying to do but here is my shot in the dark. You are looking for rows...

You need to unpivot before pivoting again. This can be done in a single statement.

Would this article give you the answer you're looking for?

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

It mentions month, but should work for any range.

Each statement is assigning a value to a variable. This values will be lost after the batch ends, so basically, they're not doing anything useful unless they're combined with something...

Club

Y.B. (6/9/2016)

---

Greg Edwards-268690 (6/9/2016)

---

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

I realize that...

Just remember that you might want to consider holidays as well. That's only achievable from a holidays or calendar table.

This is what I understood from what you posted, or at least it makes some logic to me. I agree with Drew that you might want to use a calendar...

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

I realize that there are good...

Sergiy (6/8/2016)

---

Luis Cazares (6/8/2016)

---

I mentioned that because he stated the following:

Now, even with the DISTINCT,...

I mentioned that because he stated the following:

Now, even with the DISTINCT, it shouldn't perform...

Not only that, the page...

Read the following article:

http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

It explains what you need to do. It's easy if you understand it.