The problem is that the table you are updating is not referenced (directly) in your FROM clause, so it is updating every row in that table. You want to...

That's not entirely true. ...

The problem is that your desired results require that your TABLE1 be sorted in a specific order, but the data provided is insufficient to enforce that order. You have...

anthony.green (11/5/2012)

---

The code is sound when looked at in the editior but due to it being a XML character it strips it out in the main view.

If you remove the...

CROSS APPLY applies a "function" to each row of the (virtual) table. In...

Without seeing your query, it's impossible to tell what the best approach may be. The previous posts will certainly work, but it's entirely possible that your original query may...

I think that a GROUP BY is much simpler and probably faster, too.

With YOURTABLE (TICKET,STATUS)

AS

(

SELECT 9543,1 UNION ALL

SELECT 9543,5 UNION ALL

SELECT 9543,5 UNION ALL

SELECT 9544,1 UNION...

If...

You want help resolving an error, but haven't included the text of the error message. That's like going to the doctor and asking him to help you without telling...

You already have a thread on this topic http://www.sqlservercentral.com/Forums/Topic1371464-392-1.aspx Please don't start a new one.

The reason your old thread hasn't gotten any comments, is that you haven't provided the...

Cadavre (10/12/2012)

---

Here's a total guess for what you're after: -

SELECT Branch, Year,

SUM(CASE WHEN fail = 'true' THEN 1 ELSE 0 END),

SUM(CASE WHEN fail = 'true' AND

=...

Your query 2 is invalid, because an (INNER) JOIN requires an ON clause, which is missing from your query. I suspect that the problem is in that missing clause.

Drew

GSquared (9/20/2012)

---

I use nested DateAdd and DateDiff functions to get last and first days of various time periods. For example, find the number of months (DateDiff) from 1 Jan...

John Mitchell-245523 (8/24/2012)

---

You need to handle all eventualities once and once only in your case expression - something like this:

...

CASE WHEN Interval < 1 THEN 'X'

WHEN Interval >= 1 AND...

It's simple enough to test. Why don't you try it and report back the results?

Drew