We are trying to create a stored procedure, however we run into the following error message:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
This error occurs at line 33, which reads as follows:
SET @MINTIME = (SELECT CONVERT(varchar,DATEADD(MONTH,-1,GETDATE()),112));
Does anyone know how to resolve this issue?