There is a potential problem right up at the front. The codes starts with a "Date_Dataset" cte that does a SELECT DISTINCT to produce a list of values....

Please do post the results when you find your answer. I'm curious myself.

Which NULLIF([somecolumn],0) handles perfectly, if that is the desired behavior.

In the absence of seeing your view, I can only see one thing that jumps out at me. You are starting your second query with FROM (SELECT DISTINCT...

Some...

Re-reading.

Could you please clarify exactly which rowIDs you want to flag for Hold?

I'm seeing them in this order:

rowid

1

5

2

3

4

7

6

Did he say it looks clunky or it runs clunky?

I think your DBA is being really picky unless you have company standards for formatting, but.

SELECT d.WORK_TYPE AS...

The tables and data you included look like result sets based on each of the elements. To figure out permutations don't you need to start with the the...

I see your issue now. I'm afraid I don't have any brilliant insights. I hope the code you are generating above runs satisfactorily for...

You are right, Drew. I missed that in my cutting and pasting. Thank you for setting it straight. 🙂

Nah.... he's gotten lazy. 😉

You're quite welcome, but once again I urge you to read the article about how to best post questions. We all would have gotten to the correct answer...

Goodbye, Gregory. I'm done feeding trolls for a lifetime.

Gregory, you are arguing semantics based on *your* definition of null. We are telling you how SQL works. Further argument is pointless here because they are...

Spin, would you expect the same results from this data as the results you displayed earlier?