Thanks for all responses.

PK

Hi,

Ok, modifying my case slightly.

If there is a single point of exit for a successfully executed sproc, at that point the return value could be set to a value that...

Thanks rsharma.  Your help is much appreciated.

Regards,

PK.

Hi,

 @pWriteTable is 'Y'

I suspect that the other test, @vIsrtRecCount > 0,

is never true.

Hi,

In the temporary table, the column is named rt_pol_num, in the join it is referenced...

Hi,

Yes Jesper, that's correct.

The...

Hi Mark,

Sorry, thats a typo.

Regards,

Padraic.

Hi,

Yes for those cases it behaves as expected.

i.e.

Records not returned for 1=1

Records returned for 1=2

Hi,

Thanks for your prompt response.

I am trying to resolve a problem with a large system.  I did not write the query, it is not documented and it is not clear...