Add the insert into @cte does not make sense to me. The error message that I get indicates that you cannot return a recordset to the client from within...

Could you show me where this needs to be inserted please

Server: Msg 444, Level 16, State 2, Procedure GetLocationDescription, Line 27

Select statements included within a function cannot return data to a client.

Hi There and thanks for the reply

This problem has been dogging me now for oiver a week. When I copy this into query analyser to test I get two...

I dont think it is available - I have SQL2008 (I know this is a 2005 forum)

Thank you

in query analyser I right click on the sp and select open to run it

Thanks for the response

When I run this in query analyser I get this message

Procedure 'get_form_count' expects parameter '@return', which was not supplied.

But when running it there is no prompt for...

CREATE PROCEDURE [DBO].[get_form_count] @return int output

AS

UPDATE form_count

SET form_count = form_count +1

I need to get the new form_count into the @return output param

I am a newbie and have not used...

Thank you very much. Much appreciated

Regards Phill