Tnx for answering all. I do use a construction with Tallytable to split the string, I could not figure out how to choose from 2 patterns to choose from. I...

Tnx for answering all. I will take your advise to heart and use it.

Tnx again.

Sergiy, I know the UNION is causing the problem; I'm looking for another way to do this within the parameters explained earlier.

RBarry, the HL7_patienten table hold close to 1500000 records,...

You're right, sorry about that. Now added the complete script.

The SELECT statement is, for instance:

SELECT * FROM REV_KLIGEN_PATIENTEN

WHERE ZOEKPATIENTNUMMER = '0000007'

Here the DDL of the involved views/tables. The view REV_KLIGEN_PATIENTEN is the main view, the problematic view is hl7_allePatientnummers.

TIA

Tnx for answering all. I'll post DDL monday, but it's a bit: several views & tables.

With parameter I mean basically the WHERE clause. As I said, currently it is not...

Tnx for answering all. Glad to read there are several reasons(and good ones) for using qualified columns.

Tnx for answering, Chris. It took me awhile to figure out the SET @dte should be without the timepart, or with another value then midnight. Far more elegant then I...

This might actually be the solution. Tnx a lot.

Nullability is not a problem here.

Tnx for a very enlightning article, including all comments in this thread. I have wondered many times about using SET-based techniques instead of LOOP-like techniques. This article has opened my...

Tnx for answering, Andras. I was afraid of this.

Oh well, just have to live with this.

Forget my last remark: I did not really see how the @whereand is used. Yes, this is more to what I had in mind.

Tnx!

Tnx for answering, Jack. Your second solution does work, though it's not what I had in mind.

I had not thought about using the hidden foreach.. procedures. I don;t think...

Have a look here: very interesting article with several ways how to pass arrays/tables to SP. Ofcourse, you don't REALLY pass a table, but his solutions and examples have helped...

I would not use GOTO either. It's just I am reviewing some stoprocs and notice this, obviously build by a programmer. I can advise, but not just change things here.

Tnx