Getting error :- Msg 170, Level 15, State 1, Line 18: Incorrect syntax near 'MAX'.

[Omendra]

Hi, I am using SQL Server 2005 and i am using Stored Procedure something like :-

I am getting error:-
Msg 170, Level 15, State 1,
Line 18: Incorrect syntax near 'MAX'.

DECLARE @jid AS VARCHAR(20),
@DBName As VARCHAR(50),
@Query AS VARCHAR(MAX)

SET @DBName = 'test'

SET @Query = '

DECLARE @jid AS VARCHAR(20),
@StartDate AS VARCHAR(50),
@endDate AS VARCHAR(50),
@DBName As NVARCHAR(50),

@PEditorId AS NVARCHAR(2000),
@IsDateAssigned BIT

SELECT @jid = '+ @PJID + ',
@startdate = ' +@Pstartdate+' ,
@enddate = '+@Penddate +'


DECLARE @reviewercount TABLE(
cont INT,
ms_id INT,
rev_no INT)

INSERT INTO @reviewercount
SELECT Count(*),
ms_id,
ms_rev_no
FROM ' + @DBName+'.revie wer
WHERE j_id = @jid
GROUP BY ms_id,
ms_rev_no

DECLARE @editorIds TABLE(
ed_id INT)

DECLARE @String VARCHAR(10)

WHILE Len('+ @PEditorId +') > 0
BEGIN
SET @String = Left(' + @PEditorId +', Isnull(Nullif(C harindex('','', ' + @PEditorId +') - 1, -1), Len('+ @PEditorId +')))

SET @PEditorId = Substring('+ @PEditorId +', Isnull(Nullif(C harindex('','', '+ @PEditorId +'), 0), Len('+@PEditorI d+')) + 1, Len('+@PEditorI d+'))

INSERT INTO @editorIds
([ed_id])
VALUES ( Cast(@String AS INT) )
END


I am getting error:-
Msg 170, Level 15, State 1,
Line 18: Incorrect syntax near 'MAX'.

[gpl]

what does the generated SQL look like ?
try replacing your exec @Query with a Print @Query

Do you really need dynamic sql for this? a stored procedure would be much more efficient and would give a better clue as to where your problem is.