argh...not enough sleep lately and definitely not enough coffee!

I work for an automotive (brake parts) supplier and have a very odd vacation policy.

I get 10 days per year - 3 of those are mandated to use during July...

I tested a similar solution successfully...

SELECT *

FROM table

WHERE (

CASE

WHEN condition1 = 'xxx'

THEN 1

ELSE 0

END + CASE

WHEN condition2 = 'xxx'

THEN 1

ELSE 0

END + CASE

WHEN condition3 = 'xxx'

THEN 1

ELSE...

dburtenshaw (10/14/2013)

---

I have a strange one for you please..

Given 2 coordinates of a bounding box from a geography polygon, bottom left and top right, how can I find all 4...

I have a barcoded photo ID that I wear on a reel as well as a fob for door and printer access.

Lost cards are $25.

People share fobs and knock on...

I've always completed my two weeks (or more) notice period until my last job. I was immediately escorted out when I gave notice at the casino. It was...

Ha...it occurs to me now that I have never really browsed around the control panel at all. Thanks!

It's definitely not local time...looks like UTC to me.

Nothing in my world that comes anywhere close to "BIG" so far....

Gary Stacey (9/19/2013)

---

Stewart "Arturius" Campbell (9/19/2013)

---

if memory serves, QotD only relates to the...

Full credit to other poster (bugg) who really helped to solve it with the UNION ALL portion.

born2achieve (9/16/2013)

---

my ultimate question is can we have multiple insert statements inside merge clause? if yes can you please show some sample how to achieve this requirement

your example showing how...

Jeff Moden (9/16/2013)

---

Greg Edwards-268690 (9/16/2013)

---

Hope those in Colorado are doing OK.

Floods are so devastating.

Especially when in areas you'd never expect them, and not related to spring run off.

My prayers are...

It's not really clear to me what the result should look like - what exactly belongs in each column?

Here is what is currently available from MS Learning - 12/31/13.

http://www.microsoft.com/learning/en-us/mcm-certification.aspx