Thats why I would rather come find out from the professionals and thank my lucky stars that I never got that job

😉

Once again, thanks....

Ahhhhh, okey. Thanks for the reply....

I was asked in a job interview once from a performance perspective what my preference was, to which I had no reply.

The interviewer hammered on...

Thanks John,

Agreed, functionally they do the same. Just call me a lazy developer with 200 projects, thats why I like the IN keyword.

But from a performance perspective?

Uhmmmmm,

I may be just a lil daft here, but you are creating temp table #XYZ, and inserting into #UserDetail.

With everyone on commenting out your lines of code and adding piece...

Its whatever your preference is.

With the OR statement, you will inadvertently end up writing more letters, but the net effect should remain the same.

Same reads, same amount of scans, same...