TheSQLGuru (1/2/2016)

---

This sounds like a pretty complex requirement. Thus it is even more important than usual for you to give us sample table(s), sample data and expected output. You need...

Jeff Moden (1/1/2016)

---

Heh... without going into too many details, I've found that one of the most common query blunders is the nearly religious belief in rote, so called "best practices"...

Anakin

BrainDonor (12/31/2015)

---

Right guys, I'm going quiet for a few days. I'm just about to leave my desk for the last time at this job, and will re-appear in about a...

Eirikur Eiriksson (12/31/2015)

---

Slightly more elaborate test

DECLARE @timer TABLE (T_TEXT VARCHAR(16) NOT NULL, T_TS DATETIME2(7) NOT NULL DEFAULT (SYSDATETIME()));

DECLARE @BIGINT_BUVKET BIGINT = 0;

DECLARE @DATE_BUCKET_01 DATETIME = 0;

DECLARE...

Eric M Russell (12/31/2015)

---

Maybe it's just me, but it seems this past year (and 2014 as well) there were a lot of existential discussions here on SQLServerCentral regarding our careers...

I'm staying in tonight as well. I'll be having a great time preparing a seven-course meal for the family, which is something I really enjoy.

Everyone have a safe and...

Qui-Gon

Good catch, Luis.

Tallboy, if you aren't familiar with tally tables and how they can be used, see the article at http://www.sqlservercentral.com/articles/T-SQL/62867/ for explanation and examples.

You need to look at your requirements and then really look at your data. The view pulls together some data, but you need filters you don't have, so go...

Take a look at the data J Livingston has posted.

Do you want all rows where there's an F in both columns? Alan's code does this.

Do you want...

I don't use Cluster-Aware Updating either. I have Windows 2012 R2 running SQL 2012 and I find the whole process to be pretty simple.

Here's the process I use, referring...

I'm surprised that Flint didn't make the list. Oh...wait...that's probably because there isn't anyone left in Flint. 😛

Saginaw, for a city of its size, if remarkably...

It truly does depend on the scenario. I do log backups on my development server, too. I also have staging databases in production that are in simple recovery...

There's no actual question here, so we don't know how we can help. Without knowing what your temp table looks like, it's going to be impossible to answer most...