insert if record does not exists or if exists and column is not null criteria

SQLServerCentral » Latest topics

insert if record does not exists or if exists and column is not null criteria

I have a need to only insert Emp_Info into Emptbl if the Emp_Info doesn't already exist, or if the Emp_Info does exist AND has a value in the Emp_His column. I used below merge statement, but I get an error "An action of type 'INSERT' is not allowed in t

more info...