As I said in my original post, it's not an exact science and I'm really just looking for a "good enough" solution.  Because we don't control the incoming data we...

In principle I agree with you 100% but this isn't something I have control over unfortunately.  The data is coming from a third party source.

Some context that may...

Neither is actually saved but both parts are used in a subsequent lookup to a table of UPRNs (a UPRN is a unique code given to every property in the...

Oh, I see. I'm not mad keen on that because it suffers from the same issue as adding a None option: it allows the user to make nonsensical selections....

Yeah, it seems like all roads lead to counting so that's what I've gone with for now. Thanks for your thoughts. It's good to know I'm not missing...

Thanks for posting this, Steve, and thanks for answering, Phil. It may be in the test section but I'll call getting an answer a win:-D

I think that's basically the...

Sorry but I don't understand what you're saying there. Could you elaborate for me?

I don't see an option for Ignore IDX.

Thanks.

Hi Guys and thanks for the replies.

I had already considered adding a "None" option but that doesn't seem right from a user's perspective. On a multi select it would...

I can't seem to start a thread in one of the TSQL forums. Just trying a reply here to see what happens. Sorry to interrupt the ramblings:-)

I'd agree with that.

I worked as a programmer for a data science department...

I think tooling is a large part of the problem but I also think there are some fundamental differences between database and middle tier development that make unit testing much...

Ah, found it. There's a connection type property on the task which was set to OLEDB. I didn't spot that and assumed it would infer it from the...

This says you can. I'll try switching it to an OLEDB though and see if I get anywhere.

I'd rather keep it as an ADO.Net if possible - mostly just...

I've probably designed a dozen or so. None particularly complex or unusual but they do support business "end to end" so there's normally a lot of different entities to...

Nothing at all. I don't think I said there was. If I've...