Getting an error When i am going to convert my SP as dynamic

[Omendra]

I am getting an error When i am going to convert my SP as dynamic

Error :
Msg 403, Level 16, State 1, Line 21
Invalid operator for data type. Operator equals add, type equals text.

Code :

CREATE TABLE [dbo].[StudentComments] (

@Query AS VARCHAR(1000)
@DBName As NVARCHAR,

SET @DBName = 'test'
)

@Query = 'SELECT DISTINCT m.ms_id, m.ms_rev_no
FROM' + @DBName+'.manuscript m,'
+ @DBName+'.productionmanuscript p
WHERE m.j_id = p.j_id
AND ( ( m.ms_rev_no = 1
AND EXISTS (SELECT 1
FROM ' + @DBName+'.manuscript ms
WHERE (ms.ms_rev_no = 0
AND ms.ms_id = m.ms_id) ) )
INSERT INTO @TmpEditorReportSummary
(col1,
col2)
VALUES (@ROCol1,
@ROCol2')

print (@Query)
exec (@Query)

[gpl]

2 things - your table creation has a set statement in it, that would not be valid.

Your @Query string needs a space after the FROM

I havent used TEXT fields, is it valid to oncatenate them ? the error message would indicate not, so cast those columns as varchar

When developing dynamic sql, it is often useful to PRINT the generated query in query analyser to see what will be executed