I would set up a calendar table for this type of thing. That way you always get exactly what you want. Here are some links showing how to...

opc.three (6/25/2011)

---

tfifield (6/24/2011)

---

Just to add my 2 cents to what Sean posted. You should think of column names as objects in the database. The Employee table shouldn't have...

Just to add my 2 cents to what Sean posted. You should think of column names as objects in the database. The Employee table shouldn't have a column...

Craig Farrell (6/24/2011)

---

BCLynch (6/24/2011)

---

Craig, I completely appreciate that the solution for 2 states is not the necessarily the optimal solution for n states and that you solved the stated problem....

Craig Farrell (6/23/2011)

---

This conversation resparked a curiousity on my part.

The following was tested in a 2k8 R1 environment off my local drives. End result, and if you read the...

TheSQLGuru (6/23/2011)

---

tfifield (6/23/2011)

---

. . . I always create the index after the SELECT INTO as Kevin suggested, since the create time is better. If the temp table is large,...

opc.three,

On your question to Kevin.

I've bench marked CREATE TABLE/INSERT INTO vs SELECT INTO many times. What I come up with is that the SELECT INTO is always faster -...

ankit.shukla1105 (6/23/2011)

---

You might as well better the query using a CTE. You can avoid the cost of creating and inserting into a temp table.

WITH CTE (QuestionID)

AS

(select distinct sf.questionID

...

There's another option to this. If the table is large and you have to scan it anyway, it might be more optimum to just make one pass at it...

TheSQLGuru (6/23/2011)

---

sqldba_icon (6/22/2011)

---

I really appreciate and thank all of you for taking some time to reply to my post. I think i will try creating a temp table first,...

I've seen this sort of thing fairly often. A query that does a lot of searching being done in one fell swoop takes minutes. Breaking it out into...

Gus,

I just put that one in my tool box.

Todd Fifield

As always, Gus has imparted a wealth of information. I get the trained habits. I guess I trained myself on how to eyeball code and it works for...

bphipps-931675 (6/21/2011)

---

Why bother with the temp table? Why not just imbed the select into your where clause?

SELECT

SO.SalesPersonID, C.FirstName + ' ' + C.LastName AS SalesPerson

,...

bphipps-931675 (6/21/2011)

---

Celko

Some version of this mis-use of SQL gets invented again every few months. It is a slow, dangerous mess. Are you familar with the long parameters list idiom? SQL...