HowardW (5/17/2012)

---

Hmm, hang on, that article was based on SQL 2000. It's the same argument with the "Quirky Update" running totals solution in that it relies on the internals of...

HowardW (5/17/2012)

---

gemisigo (5/17/2012)

---

HowardW (5/17/2012)

---

The problem here is you're relying on an undocumented and unreliable use of variable assignment in a select statement.

There's absolutely no guarantee that the variable assignment will...

RBarryYoung (5/16/2012)

---

I'm still trying to figure out what it means to "Organically Cancel" a resultset. Does that mean that it comes with a sprig of broccoli or something? ...

In short - even though they are set up as OUTPUT variables, with no default values they are still required during the procedure call.

If you don't want to pass the...

From BOL:

Exits unconditionally from a query or procedure. RETURN is immediate and complete and can be used at any point to exit from a procedure, batch, or statement block. Statements...

Check the table you're inserting into for triggers, etc.... If the trigger is trying to do something with the very large column IT may be getting the truncation error.

Try this (based on your test data):

SELECT

*, case BinaryCode & (POWER(cast(2 as bigint),MyDaTA-1)) when 0 then 'working' else 'non-working' end

--,here is where I need to do the business day...

Chrissy321 (5/14/2012)

---

I am trying to walk some kind of line here between describing an issue in general and providing exact DDL. The vendor doesn't support direct database access, they allow...

Chrissy321 (5/13/2012)

---

I have concerns about contractual vendor...

hmm. I would be cautious about equating parallel with "faster": in many cases the execution plan will be more efficient without the parallelism.

That said - Have you tried parameterizing...

Why is it important for this to be parallel?

Lynn Pettis (5/11/2012)

---

Matt Miller (#4) (5/11/2012)

---

If you're dealing with messaging and responses - you're really in the realm of talking about a SQL Service Broker application with a conversation set...

You'd actually need to use CHECKIDENT twice. The first time resets the next ID to an arbitrarily low value, and the next reseed puts it to the next higher...

If you're dealing with messaging and responses - you're really in the realm of talking about a SQL Service Broker application with a conversation set up. That said -...

You're not going to be able to query a URL directly from within a query. At very least you'd need to save the current RSS feed locally and THEN...