Dear SQLers:

I have written the following stored procedure:

create procedure NiceString
@strIn nvarchar(max),
@strOut nvarchar(max) output
with recompile
as
begin
select @strOut=
ltrim(rtrim(replace(replace(@strIn,nchar(9),N' '),N' ',N' ')))
/* */ select N'NiceString Result:',@strOut
end
go

It works to the degree that the result select shows the correct
value when I run it, but the value of strOut does not get back to the
caller in the following sequence, and strAfter still has its initial
value:

use Banking
go

declare @strBefore nvarchar(max)=N' This is an example. '
declare @strAfter nvarchar(max)=N'*** not assigned to ***'

select @strBefore
execute NiceString @strBefore,@strAfter
select @strAfter

use master
go

What am I missing, please?

Sincerely,

Gene Wirchenko

On Mon, 04 Apr 2011 14:26:33 -0700, Gene Wirchenko <genew (AT) ocis (DOT) net>
wrote:

[snip]

[snip]

I found it myself.

The call should be
execute NiceString @strBefore,@strAfter output

This is the sort of thing that should get a warning or error
message.

Sincerely,

Gene Wirchenko