Hi I get the error "Syntax error converting datetime from character string "for
the following sql statement in Stored proc.
SET @dynamicSQL =N'SELECT CUSTID,SHCodeLi nk FROM AccountMaster where CONVERT(DATETIM E,OPDATE,105) < = '''+CONVERT(DAT ETIME,@ACCYEAR, 105) +''' And GLCode = '+@DIVGLCODE
EXEC(@dynamicsq l)
the following sql statement in Stored proc.
SET @dynamicSQL =N'SELECT CUSTID,SHCodeLi nk FROM AccountMaster where CONVERT(DATETIM E,OPDATE,105) < = '''+CONVERT(DAT ETIME,@ACCYEAR, 105) +''' And GLCode = '+@DIVGLCODE
EXEC(@dynamicsq l)
Comment