I wish 🙂

I get the parameters from a outsite source: the people who build the website.

I have some influence on what...

Wow, . . .

Thank you both Alan and Eirikur.

I'll try your solutions, after having analysed them, and choose one of them.

They are a bit to sophisticated to me to understand...

@ "Another question, how frequently will this be called?"

Not so often:

From March till August at max a 100 times per hour. Rest of the year almost never.

@"Quick question, how many parameter values do you expect in a single call?"

Not more then 5. It's the count of the Themes of the Trip.

The number of trips is also...

I can't place a UDF in the Database. I am a developer, not the owner. So the "shown solution" is not possible for me.

But I can use the idea (make...

Not exactly an answer to the question, but I use a field named State, Status, or Condition.

VARCHAR(1), Default '' (an empty string).

I fill this field with a Char when the...

Or

[font="Courier New"]REPLACE(STR(@NUM, 5),' ','0')[/font]

Eirikur and Sean, thank you.

I have SqlServer 2012 on my developper machine, but the production machine is 2005 :crying:.

Now I gona try to fit my query into the...

Yeah, a physical Tally table is a good option.

But I like the solution you gave me, a "Tally table on the fly". 😉

I met another problem when I tried to...

Sorry, I found the solution myself in an article from Jeff Moden:

"Generation of testdata Part 1 - Generating Random Integers and Floats"

http://www.sqlservercentral.com/articles/Data+Generation/87901/

SELECT TOP (400)

...

[font="Tahoma"]Table Value Constructor not available in SqlServer2005[/font]

I managed to understand the code and to incorporate the example in my (far much more complex) code.

The first part:

WITH cteTally AS (

SELECT ROW_NUMBER()...

Yes, I'm...

mickyT (5/22/2014)

---

Here's how I would do it, however there is likely to be better ways:-)

It doesn't return the expected results that you have posted, but they don't match the rules...

Jack,

Thank you for your answer.

But I don't think it is the classic gaps and islands problem.

Still I'll have a look at the article you recommended, maybe there is something...

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...