BFSTEP (8/1/2013)

---

I am in a time crunch, many things on my plate today, and I just can't seem to get this problem, thought I would toss it out to the...

I would use a case statement to handle this.

See http://msdn.microsoft.com/en-us/library/ms187787.aspx

It indicates:

Examples of valid simple terms are "blue berry", blueberry, and "Microsoft SQL Server". Phrases should be enclosed in double quotation marks ("").

I have both desktop and laptop pcs for work. I rarely ever use the laptop outside the plant - but nice to have if I need to travel or...

I have enjoyed 3 weeks vacation and unlimited sick time for several years and now find myself in a much different situation.

My current position includes 2 weeks PTO which must...

Trust me when I say that there is a reason why I looked for that early.

😛

I believe you are missing a comma after the previous line.

SELECT unit_id,

SUM(value) AS unit_total,

CASE

WHEN COUNT(Unit_ID) = 1

AND SUM(value) >= 50

THEN 'Y'

ELSE 'N'

END AS Flag,

CASE

WHEN COUNT(Unit_ID) = 1

AND SUM(Value) >= 50

THEN max(orderID)

ELSE NULL

END AS OrderID,

CASE

WHEN COUNT(Unit_ID) = 1

AND...

I recall having a very similar thought when I finished my Accounting 101 class.

Knowing my debits from my credits and my assets from my liabilities (and most importantly,...

This is my first year in the automotive industry. I must say that for the most part, I don't like being forced to take my vacation at specfic times...except...

This is standard practice in the US - the week of July 4 and the week of Christmas are typically no production.

My July 4 holiday will begin in a little more than 2 hours - my employer is in the automotive manufacturing business and the infamous "shutdown" is nearly upon us.

Then the script I posted above would work.

Here is my attempt - summing the value by unit_id, displaying a "Y" flag if there is a single unit_id with value >= 50 and only displaying results if the...

pongcs86 (6/28/2013)

---

Hey guys,

New to the site, new to writing SQL queries and have no background in this type of thing.

But I've been googling my way to victory for the most...