It's because of the return type of CASE.

A CASE expression's return data type will be the data type with the highest precedence of all the possible result expressions. See https://msdn.microsoft.com/en-us/library/ms181765.aspx#Anchor_2

Some...

Most likely in the first environment the conditions that result in the execution of the branch with the ROLLBACK are not being met, while in the second environment those conditions...

ZZartin (8/25/2016)

---

Ed Wagner (8/25/2016)

---

I didn't make it the whole way through, but...

The documentation is incorrect about that for sys.types.

Pull max_length from sys.columns instead, and it should correctly show -1.

Cheers!

UNIQUEIDENTIFIER only permits hexadecimal digits, and your strings contain many non-hexadecimal characters.

Exactly what is the goal of turning strings into UNIQUEIDENTIFIERS like this?

Cheers!

Another alternative is to construct a dynamic UNION ALL query by SELECTing from sys.databases.

Just a quick example of how that might look if my goal is to see all tables...

drew.allen (8/22/2016)

---

Jacob Wilkins (8/22/2016)

---

drew.allen (8/22/2016)

---

COUNT will work as an aggregate if you return a NULL in the proper cases. COUNT() may not perform the best, but it will work.

COUNT(CASE...

drew.allen (8/22/2016)

---

COUNT will work as an aggregate if you return a NULL in the proper cases. COUNT() may not perform the best, but it will work.

COUNT(CASE WHEN status='Discharge' THEN...

A few things:

1) You said this was per avatarid/episode combination, so you would need to group by both columns, not just avatarid.

2) To filter based on aggregates, you should use...

drew.allen (8/22/2016)

---

This will only work if you pass in single characters as your parameters. Given that you've defined your parameters as VARCHAR(50), it...

To follow up on Luis' fine answer, the reason you're seeing those results is that you're not actually using the parameters you're passing.

When you do this:

[column] LIKE '[@a-b]%'

you're saying to...

The first point to make is that you should never assume the output of a query will be ordered any particular way unless you use an ORDER BY clause (I'm...

There's a table of dates (presumably), dbo.date.

The first SET command sets the @EndDate variable to be the most recent date from the dbo.date table that is earlier than the current...

The shrink will attempt to reclaim space starting at the end of the file, but will not shrink past the part of the log that is active.

Most likely the active...

ScottPletcher (6/14/2016)

---

My advanced knowledge, "tricky" q is:

In autocommit mode, when can an UPDATE statement partially complete, some UPDATEs made, some not, where SQL does not roll it back?

Edit:...