Here's a quick cross-tab example specific to your situation:

SELECT D.PersonID,

MAX(CASE WHEN D.Activity = 'Woke Up' THEN D.ActivityTime END) AS WakeUpTime,

MAX(CASE WHEN D.Activity...

You didn't get an error because a bit column will treat any value greater than 1 as 1, so SQL converted the "2" to a 1.

Try running:

sp_refreshsqlmodule or

sp_refreshview

on potentially affected objects.

You should get errors on the object(s) that now reference unknown columns.

Jeff Moden (6/30/2015)

---

GilaMonster (6/30/2015)

---

Jeff Moden (6/30/2015)

---

It seems like a lot of folks don't understand that a non-clustered index is a duplication of data that not only affects queries and space...

You can add a file to tempdb if you need to. Or explicitly expand an existing file(s) yourself.

Be extremely careful if/when trying to modify, or drop, existing objects in...

Sean Lange (6/30/2015)

---

Jacob Wilkins (6/30/2015)

---

This is all rather interesting, so I thought I'd chime in.

Based on what I've tested, Scott is technically correct. Under the right conditions, even where it...

You'll probably need to use ROW_NUMBER() for now:

;WITH CTE_sales AS (

SELECT

date_created, sales,

...

Jeff Moden (6/26/2015)

---

ScottPletcher (6/26/2015)

---

Sean Lange (6/26/2015)

---

Scott you have been...

Sean Lange (6/26/2015)

---

Scott you have been around sql long...

Jeff Moden (6/25/2015)

---

ScottPletcher (6/25/2015)

---

sgmunson (6/25/2015)

---

ScottPletcher (6/25/2015)

---

Why does everyone keep repeating that? Of course NOLOCK hints...

sgmunson (6/25/2015)

---

ScottPletcher (6/25/2015)

---

Why does everyone keep repeating that? Of course NOLOCK hints make queries run...

sgmunson (6/25/2015)

---

ScottPletcher (6/25/2015)

---

I prefer this approach [Edit: Because of its clarity, and to avoid using functions in the WHERE clause, which should be avoided whenever (reasonably) possible]:

WHERE

...

I prefer this approach [Edit: Because of its clarity, and to avoid using functions in the WHERE clause, which should be avoided whenever (reasonably) possible]:

WHERE

(requirementGradYear...

Why does everyone keep repeating that? Of course NOLOCK hints make queries run faster, even...

Select [C1] ,

[C2] ,

DATEADD(S, C3, '1970-01-01 00:00:00') AS [C3] ,

[C4] ,

[C5] ,

[C6] ,

[C7] ,

[C8] ,

[C112],

[C675001003] ,

[C812000101] ,

[C875000000] ,

[C875000001],

[C875000002] ,

[C875000003] ,

[C875000004] ,

[C875156000] ,

[C875156001] ,

[C875156002] ,

[C875156005] ,

[C875156006] ,

[C875156007] ,

[C875156003] ,

[C875156004]...