Henk Schreij (3/21/2014)
Ad and Jeff, thanks for your answer.The solution presented in this article is superb.
But before I could implement it (I had to make a Tally table and the function) the user decided to another outcome (in an Excel report). I had to add an extra column with the parameter numbers in it. So the user could select the wanted numbers in Excel in stead of in a given parameter-list.
So I didn't use the given solution. But next time I will 😉
Glad we could help. You know, now that you have the Tally table and the DelimitedSplit8K function, take some time to play around and get used to it. I've heard it described as the "Swiss Army Knife of SQL" by some people. It really does lend itself to some very high performance code. It's another tool you can keep in your toolbox for when you need it.