Hi,
I am unable to modify my view due to an error:
Implicit conversion of varchar value to varchar cannot be performed because the collation of the
value is unresolved due to a collation conflict
Database colation is set to SQL_Latin1_General_CP1_CI_AS
Here is my ddl:
CREATE TABLE [dbo].[TB_INDUSTRIEKALENDER](
[KALENDERDATUM] [datetime] NOT NULL,
[KALENDERWOCHENTAG] [tinyint] NOT NULL,
[KALENDERWOCHE] [tinyint] NOT NULL,
[KALENDERJAHR] [int] NOT NULL,
[KALENDERMONAT] [tinyint] NULL,
[KALENDERTAG] [tinyint] NULL,
[QUARTAL] [tinyint] NULL,
[KALENDERWOCHENTAG_TEXT] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KALENDERMONAT_TEXT] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ERSTELLTDATUMZEIT] [dbo].[T_SERVERDEFAULTDATUMZEIT] NULL CONSTRAINT
[DF__TB_INDUST__ERSTE__38996AB5] DEFAULT (getdate()),
[ERSTELLTBENUTZER] [dbo].[T_NAME] NULL CONSTRAINT [DF__TB_INDUST__ERSTE__092A4EB5] DEFAULT
(suser_sname()),
[GEAENDERTDATUMZEIT] [datetime] NULL,
[GEAENDERTBENUTZER] [dbo].[T_NAME] NULL,
[TIMESTAMP] [timestamp] NULL,
CONSTRAINT [PK_TB_INDUSTRIEKALENDER] PRIMARY KEY CLUSTERED
(
[KALENDERDATUM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX_TB_INDUSTRIEKALENDER] UNIQUE NONCLUSTERED
(
[KALENDERJAHR] ASC,
[KALENDERWOCHE] ASC,
[KALENDERWOCHENTAG] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
--
The error occurs when I attempt to create this view:
create View [dbo].[vw_Report]
as
SELECT ,[JAHRMONAT]
,[KALENDERJAHR]
,[KALENDERMONAT]
,[KALENDERMONAT_TEXT]
FROM [dbo].[vw_AdressReport1]
UNION ALL
SELECT ,JAHRMONAT
,[KALENDERJAHR]
,[KALENDERMONAT]
,[KALENDERMONAT_TEXT]
FROM [dbo].[vw_AdressReport2]
The error refers to column [KALENDERMONAT_TEXT] in the view above.
----------------------------------------------------------
DDL of [dbo].[vw_AdressReport1]