Código:
No lo creeran pero asi sigue hasta julio id nvarchar(50) Unchecked ejecutivo nvarchar(255) Checked segmento nvarchar(50) Checked [Nombre-Descripcion] nvarchar(300) Checked [Holding-Grupo] nvarchar(300) Checked teams nvarchar(50) Checked check1 int Checked matchname nvarchar(290) Checked manager nvarchar(50) Checked corporacion nvarchar(150) Checked frandNovember2008 int Checked franiNovember2008 int Checked shardNovember2008 int Checked shariNovember2008 int Checked offdNovember2008 int Checked offiNovember2008 int Checked platNovember2008 nvarchar(50) Checked ondNovember2008 int Checked oniNovember2008 int Checked excNovember2008 nvarchar(50) Checked fpyNovember2008 int Checked ltNovember2008 int Checked ttlNovember2008 int Checked frandmNovember2008 money Checked franimNovember2008 money Checked shardmNovember2008 money Checked sharimNovember2008 money Checked offdmNovember2008 money Checked offimNovember2008 money Checked ondmNovember2008 money Checked onimNovember2008 money Checked frandDecember2008 int Checked franiDecember2008 int Checked shardDecember2008 int Checked shariDecember2008 int Checked offdDecember2008 int Checked offiDecember2008 int Checked platDecember2008 nvarchar(50) Checked ondDecember2008 int Checked oniDecember2008 int Checked excDecember2008 nvarchar(50) Checked fpyDecember2008 int Checked ltDecember2008 int Checked ttldecember2008 int Checked frandmDecember2008 money Checked franimDecember2008 money Checked shardmDecember2008 money Checked sharimDecember2008 money Checked offdmDecember2008 money Checked offimDecember2008 money Checked ondmDecember2008 money Checked onimDecember2008 money Checked total2008 int Checked totalm2008 money Checked frandJanuary2009 int Checked franiJanuary2009 int Checked shardJanuary2009 int Checked shariJanuary2009 int Checked offdJanuary2009 int Checked offiJanuary2009 int Checked platJanuary2009 nvarchar(50) Checked ondJanuary2009 int Checked oniJanuary2009 int Checked excJanuary2009 nvarchar(50) Checked fpyJanuary2009 int Checked ltJanuary2009 int Checked
yo lo normalicé de la siguiente forma:
Código:
añadiendo type ke me daria si es: fran, frani,shari, off etc. añadiendo anex si tiene o no m , el mes y el año....creen ke exagero en la normalización representa algun problema la estructura inicial, les salta algo a la vista ke es tan molesto como a mi? Espero sus comentarios id nvarchar(50) Unchecked ejecutivo nvarchar(255) Checked segmento nvarchar(50) Checked [Nombre-Descripcion] nvarchar(300) Checked [Holding-Grupo] nvarchar(300) Checked teams nvarchar(50) Checked check1 int Checked matchname nvarchar(290) Checked manager nvarchar(50) Checked corporacion nvarchar(150) Checked type anex month year cant
