Mercurial > altnet-hispano

diff Agendas/trunk/db/v1.0/01 - Ponentes.sql @ 238:b43dc14886e3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Quitando ponente principal de la UI
author nelopauselli
date Tue, 04 Oct 2011 21:59:40 -0300
parents c61954d24c8c
children
line wrap: on
line diff
--- a/Agendas/trunk/db/v1.0/01 - Ponentes.sql	Tue Oct 04 21:30:55 2011 -0300
+++ b/Agendas/trunk/db/v1.0/01 - Ponentes.sql	Tue Oct 04 21:59:40 2011 -0300
@@ -11,3 +11,9 @@
 			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