I'd be interested in seeing the same type flow with a delimited file.

(Nice.) --> scratch that part. Looked good anyway 🙂

Any easy way to fix my 'NOT MATCHED' 'x' input issue?

What I need is if there is an 'x' value on...

Thank you . Much cleaner.

I was all happy getting that part to work but missed a input case. When the user gives me a record that does not...

Probably a better way but this seems to do what I want. Allows the users to feed me an "x" to explicitly clear a field, and if they do...

Great, thank you. Dissecting and learning now.

The UDF is just a user defined field. A text string they can give me to tie into a different data source...

I figured it was...

Yes, I was not familiar with that function. That should do it. Thank you.

OK, but that's no good :ermm:

Appreciate the explanation and help. That produces duplicate rows though.

ProjectNoProjectTypeLocationChildDefFinish

abc123new 111 ...

In your sample data ProjectType was either "new" or "std" there was no empty string ('').

You are changing it to an empty string in your SELECT statement via CASE. So...

Got it. Can't use ChildDef but can just repeat the criteria that it used. I tried this to get both cases and it worked

WHERE (

p.ProjectType <> 'New' AND...

I made one small change so I get "new" or "newChild" in the ChildDef field.

How can I restrict this to just rows with one or the other of those 2...

Works, I'm digesting now. I think I was having some trouble understanding the virtual tables (my noob description) that get created in here and at what point they were...

I thought I had a handle on this and was able to make some mods for my real problem. But I ran into an issue I didn't anticipate originally....

Thank guys VERY MUCH. All work perfectly of course. I'm studying to dissect and comprehend the mechanics. I get it when I read it, now to get...