Single quote error in tsql statement
-
Hi all I have the following the statements SET @TempMenuId= 'SELECT @res1 = coalesce(@res1 + ',', '') + CAST([Tb001_Id] AS Varchar(8)) FROM [admin].[cm_tb_005] WHERE' + @Role_Idv +'=1' EXEC @TempMenuId Iam Passing @Role_Idv dynamicall.But its showing error message like this The name 'SELECT @res1 = coalesce(@res1 + ',', ') + CAST([Tb' is not a valid identifier. Please help me on this. Regard's Veeresh
i want to join this group
-
Hi all I have the following the statements SET @TempMenuId= 'SELECT @res1 = coalesce(@res1 + ',', '') + CAST([Tb001_Id] AS Varchar(8)) FROM [admin].[cm_tb_005] WHERE' + @Role_Idv +'=1' EXEC @TempMenuId Iam Passing @Role_Idv dynamicall.But its showing error message like this The name 'SELECT @res1 = coalesce(@res1 + ',', ') + CAST([Tb' is not a valid identifier. Please help me on this. Regard's Veeresh
i want to join this group
this is working ! DECLARE @IDNAL VARCHAR(36) DECLARE @ID_STAVKE VARCHAR(36) DECLARE @IDDOC VARCHAR(36) DECLARE @IDVL VARCHAR(36) DECLARE @IDLOK VARCHAR(36) DECLARE @NEVALJA CHAR(1) DECLARE @RECENICA AS VARCHAR(5000) DECLARE @LOCAL_KONTO AS VARCHAR(36) DECLARE @ID_FORMULE AS VARCHAR(36) DECLARE @FORMULA AS VARCHAR(500) SET @MySTRING=' UPDATE #A SET #A.col001=#A.col001+COALESCE((SELECT ('+@FORMULA+') FROM #LOCAL_STAVKE WHERE #LOCAL_STAVKE.VD='''+@IDDOC+''' AND #LOCAL_STAVKE.KONTO= CASE '''+@LOCAL_KONTO+''' WHEN '''' THEN #LOCAL_STAVKE.KONTO ELSE '''+@LOCAL_KONTO+''' END AND #LOCAL_STAVKE.ID=#A.IDNALOGA ),0)' EXECUTE(@MySTRING)