OK, so... report this post as well!

I'm so happy to have solved...

OK then, this should do.

-- DECLARE TEST TABLE

DECLARE @batch TABLE (

id int identity(1,1),

empcode varchar(50),

batch...

I'm not sure I understand your question.

Everything before the keyword "WITH" is not part of the solution, is just a setup of sample data to show how the example works....

Are you sure, Jeff?

If I understand it correctly, the sort order should not matter.

Arjun Sivadasan (3/9/2011)

---

tfifield (3/4/2011)

---

Tony,

Please be advised that while this type of scalar UDF (accessing a table based on parameters) has its place in some applications, it can lead to very...

This should do the trick for you:

-- DECLARE TEST TABLE

DECLARE @batch TABLE (

empcode varchar(50),

batch int

)

-- POPULATE WITH SAMPLE DATA

INSERT INTO @batch

...

Koen Verbeeck (3/8/2011)

---

Tom.Thomson (3/8/2011)

---

Kiara (3/8/2011)

---

Koen Verbeeck (3/8/2011)

---

First of all, as it is international woman day, congrats to all those woman out here!

(who for some bizarre reason love to work in...

Thanks for clarifying, Bart.

I filed a Connect item here:

https://connect.microsoft.com/SQLServer/feedback/details/649957/case-expression-evaluates-else-branch-at-compile-time.

Let's see what happens.

David Burrows (3/7/2011)

---

SQLkiwi (3/7/2011)

---

Gianluca Sartori (3/7/2011)

---

Great job, Paul! Outstanding, as usual.

Now there's a chance that a poor n00b like...

SQLkiwi (3/7/2011)

---

Gianluca Sartori (3/7/2011)

---

Great job, Paul! Outstanding, as usual.

Now there's a chance that a poor n00b like me can...

Great job, Paul! Outstanding, as usual.

Now there's a chance that a poor n00b like me can understand parallel execution.

Sushant, if you look up sp_send_dbmail in BOL (Books Online, SQL Server's help) you will find the...

SQLkiwi (3/3/2011)

---

Just to be clear, Bart's example is compiled as:

SELECT CASE WHEN 0 <= 0 THEN 0 ELSE LOG10(0) END;

..which also gives the error (when it should not). Reproduces...

Thank you Johan, I must have missed your last post. :blush:

We're still working on the issue with MS support.

Now they're trying to reproduce the problem on their own, as the...

Bart Duncan (3/3/2011)

---

This post seems to recommend CASE as a way to get deterministic short circuiting in T-SQL. Unfortunately, even CASE does not always provide deterministic order of evaluation with...