It seems I had a small bug in the udf code I posted. The return statement of the udf should be RETURN VARCHAR(4000) instead of just RETURN VARCHAR. ...

If you don't mind using a user defined function, you could create one like this:

CREATE FUNCTION dbo.udf_ClaimDenialReasons

(

@ClaimId INT

)

RETURNS VARCHAR

AS

BEGIN

DECLARE @Description...

You can use dynamic sql like:

ALTER PROCEDURE spTotalCompraIdiomaLibro @Idioma varchar(20), @año varchar(10)

AS

BEGIN

DECLARE @Some_Sql VARCHAR(8000)

SET @Some_Sql =

...

Mick,

You just need to add an additional where clause that checks the column value equal to either of the passed in values. That would prevent the update statement from...