[thelist] Stored Procedure Problem (EXEC)

[Scott]

: CREATE PROCEDURE sp_CMSFormsSegments
:   @Category int,
:   @Language varchar(100)
:
: AS
: DECLARE @ExecCode varchar(8000)
:
: SELECT @ExecCode = 'SELECT tblCMSFormsSegments_ID AS SegID, ' + @Language + '
AS TheText FROM tblCMSFormsSegments Segs INNER JOIN tblCMSTranslations Trans ON
Segs.tblCMSTranslations_ID = Trans.tblCMSTranslations_ID WHERE Category = ' +
CAST (@Category AS VARCHAR)
: --  EXEC @ExecCode
: PRINT @ExecCode
:
: ---------------------------------------------------------------------------

Shaun
You have to use  EXEC (@ExecCode)
not EXEC @ExecCode

Always the little things....

cheers