will do.

Tks for quick reaction. I will have a look on it!

Hi,

I'm facing the same problem...

Do you by chance have a solution for this ?

Many tks !

Tks.

Unfortunately, the only question I have is "Delete rows and associated group : OK Cancel

So If I answer YEs, Everything is gone...

...ignore ?

Yes !

Tks !

Hi Gail,

will do this with pleasure.

Give me some times to check first myself and I come back !

Many tks for your help !

Hi Gail,

as specified I'm using both inline and multistatement table functions to get the final results.

What's surprising me is that is take 8 seconds to get the results which is...

Tks Grant for your answer.

My table value functions (both inline and multistatements) returns about 500 rows...

For what I have understood from your statement is this is not foreseen for such...

Tks but ...

I'm using the result of the function inside a merge statement... Therefore function is mandatory.....

Hi,

I have the same problematic.

Could you share your stored proc using the openrowset ?

Many tks.

Look this is the 'theoretical function'.

ALTER FUNCTION [dbo].[fctProcessSCP]

(

-- Add the parameters for the function here

@SCP varchar(200),

@Separator char(1),

@ProcessId smallInt

)

RETURNS int

AS

BEGIN

-- Declare the return variable here

Declare @SubSCPId int

Declare @SubSCP1Id int

Declare @SubSCP...

The things is that i's likely not often that I will have to add records to the references tables....

so I would like to have all logic (Get primary keys and...

Tks for your quick reaction.

To explain you

Input table : several columns + 1 column containing 5 <> col (string based) in 1 (separated by |).

Output table : same several columns...