Good to know.

However, I am still stuck with this

It took me some time to go through all the posts. I didn't imagine the discussion will take such a turn 🙂

Anyway, my question was only about the change in...

And also since the issue occurs only in case on constants we can trick the engine not to throw the error, like this:

select 1 from sys.tables where

((

CASE WHEN...

I agree with you that the problem occurs only when constants are used. It doesn't occur when variables or column names are used.

Changing the way constants are used by the...

Stefan,

Thanks for the answer.

It is a problem, because in Sql Server 2005 it works just fine.

Let's say that I have a function which is used to add a number of...

Paul,

What would you recommend for serializing a Median UDA?

I am asking this in the context of Merge method/parallel threads.

For median, we need to keep all the value in an array...

Looks cleaner 🙂

Thanks for all the feedback Paul.

Ionut

What you say makes perfect sense.

What I was saying is simply that I couldn't find your scenario to fail as you pointed out. But I do agree that it's better...

Paul,

Based on your initial feedback, I tried two scenarios:

1)input table with only NULL values

2)input table with no rows.

Both failed, but the error did not occur in the Read(), but instead...

Paul,

Thanks for your observations. Let me try to answer them one by one:

1)The Write method does not write anything if the aggregate is empty. The Read method will still try...

Barry,

Thanks for your input.

I managed to change the UDA based on your suggestions ant it appears to be working. The code looks like this now (basically m_uAvg is only calculated...

If you store that string in a column why just not do:

UPDATE my_table SET my_html_column = REPLACE(my_html_column,'%20','_')

WHERE my_html_column LIKE '<a href="#%</a>'

% character means any string that starts with <a...

Enforcing delete cascade will also help here, instead of creating indexes. I believe it should eliminate the deadlock. Of course if you enable delete cascade it's no point in deleting...