view Agendas/trunk/db/v1.0/01 - Ponentes.sql @ 244:31fb96912d37

Ticket 162: Publicaciones con Nro Orden repetido.
author juanjose.montesdeocaarbos
date Thu, 06 Oct 2011 09:09:37 -0300
parents b43dc14886e3
children
line wrap: on
line source

if (OBJECT_ID('Ponentes') is null)
begin
	if (OBJECT_ID('OtrosPonentes') is not null)
		EXEC sp_rename 'dbo.OtrosPonentes', 'Ponentes'
	else
		create table Ponentes (
			evento_key uniqueidentifier not null,
			elt uniqueidentifier not null,
			constraint PK_Ponentes primary key(evento_key, elt),
			constraint FK_Ponentes_Evento foreign key (evento_key) references Evento,
			constraint FK_Ponentes_Persona foreign key (elt) references Persona)
end
go

insert into Ponentes (evento_key, elt)
	select e.Id, e.Ponente 
		from Evento e 
		where e.Ponente is not null and e.Ponente not in (select p.elt from Ponentes p where p.evento_key = e.Id)
go