Thanks Gianluca

I will try this way and insert the results of the SP inot the temp table and then count the records.

Thanks

Bruce

Hi Gianluca

The database that I have written is used for Fatigue Management in the Transport Industry here in Australia.

I have a table called DayTimes which has about 4 fields...

thanks for the quick reply Gianluca

------------------

You can capure @@ROWCOUNT right after the query execution and then return it as output parameter or as procedure return value (RETURN @myCountVar).

Hope this helps

Gianluca...