Mercurial > altnet-hispano
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