I think you'll have to find someone with strong maths skills to help you on this one. This one is not really about t-sql skills...

Could they accept a system...

I hope that the interviewer understands these questions, cause there are far more good answers than the ones posted. He might have to resort to : he seems to...

You can still use this function and specify the rank (where Elementid = 5). Then you can keep the original split function and use it for other tasks.

Still too complex. As a few members here have said, when the query is too complex, stop cursing at the query and change the form behing it. Simplicity...

there's always a but .

I have 0 advanced maths formation... I'll let you handle this one .

Btw, my number of combinaison was only for different combinaisons of...

Is the table permanent or temps?? Have you tried using the other version?

Hey govinn, even with only 20 numbers, you have

2 432 902 008 176 640 000

different possible combinaisons of numbers.

That's 2.4 billions million combinaisons. Do you really want...

Can you connect to it??

Hehe. I've read a article with something like this a few days ago... was about a Whoops incident. Can't recall the circumstances

If it was for a prefix number of values, it could be done. but if the logic is find any match, with any qty of numbers, then I don't...

What fields need to be updatable in the form?

Just run my query and compare to yours... I'm just specualting on your needs. You know what you need more than me.

Please do not cross-post. I already answered that question here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=192379

Isnull is built-in. You can also lookup COALESCE.