i'm using sp_executesql to get the output. but doesnt work.

however, the select statement gives the output.

refer:

SET QUOTED_IDENTIFIER OFF

set @stmnt = "SELECT @description = Dscrptn + coalesce(' for ' + CaseNumber,...