clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2555400 fiddles created (37435 in the last week).

CREATE TABLE [dbo].[EmployeeCourse]( [Id] [int] IDENTITY(1,1) NOT NULL, [EmployeeId] [int] NOT NULL, [CompanyCourseId] [int] NOT NULL, [HasAttachments] [bit] NOT NULL, [UniqueId] [uniqueidentifier] NULL, CONSTRAINT [PK_Employee_Courses] PRIMARY KEY CLUSTERED ([Id] ASC) )
 hidden batch(es)


CREATE TABLE [dbo].[TrainingHistory]( [Id] [int] IDENTITY(1,1) NOT NULL, [EmployeeId] [int] NULL, [NextDueDate] [date] NULL, [CompanyCourseId] [int] NULL, [UniqueId] [uniqueidentifier] NULL, [HasAttachments] AS (isnull([dbo].[TrainingHistoryHasAttachments]([Id]),(0))), CONSTRAINT [Training_History$PrimaryKey] PRIMARY KEY CLUSTERED ([Id] ASC) )
Msg 4121 Level 16 State 1 Line 1 Cannot find either column "dbo" or the user-defined function or aggregate "dbo.TrainingHistoryHasAttachments", or the name is ambiguous.
 hidden batch(es)