Craig,

It works. I have to make some tweaks. E.g. pattern comes from SELECT from another table and I have to add some more conditions but it does what it should....

Good point,

It is an error. Sorry for that. I made the sample data manually.

Thanks guys for your help.

Yesterday I tried to solve that problem. With your suggestions I was moving forward. But... I got additional requirement now. The requirement is:

pattern may contain ranges...

Yep, you are right about the temp table.

Do you think it will not be performance killer?

Thanks,

Although that is the problem... Amount of data is huge. Not in gigabytes but in records. I tried doing something like this with a recursive stored procedure.

Due to number of...