Hi!

Use convert() function to convert to nvarchar type from UNIQUEIDENTIFIER type.

>I wrote the following code and cannot get it to run:
>
>DECLARE @RequestID UNIQUEIDENTIFIER,
> @TempTableName VARCHAR(36),
> @Cmd NVARCHAR(200)
>
>SET @RequestID = NEWID()
>SET @CMD = N'SELECT [TypeIDField], [DataValue] FROM RequestProperty_tbl re LEFT OUTER JOIN ' + @TempTableName + ' AS t ' + 'ON t.[ID] = re.[TypeIDField] WHERE re.[RequestID] = ' + @RequestID
>
>EXECUTE SP_EXECUTESQL @CMD
>
>--Server: Msg 403, Level 16, State 1, Line 7
>--Invalid operator for data type. Operator equals add, type equals nvarchar.
>
>
>How can I format it with the @RequestID UniqueIdentifier to run correctly?