Tabla De Hechos
Enviado por vansk8 • 3 de Diciembre de 2012 • 409 Palabras (2 Páginas) • 490 Visitas
select TOP 1000 [cod_distrito],
[nom_distrito]
from [Inteligencia].[dbo].[tb_distrito]
*********************************************************
select TOP 1000 [num_papeleta],
[entidad],
[fecha],
[hora],
[cod_distrito],
[lugar],
[cod_infractor],
[num_placa],
[Importe],
[estado_papeleta],
[NroCIP_poli]
from [Inteligencia].[dbo].[tb_papeletaconductor]
*********************************************************
select TOP 1000 [num_placa],
[cod_marca],
[cod_modelo],
[color],
[año_fabric],
[tarj_prop],
[cod_propietario],
[cod_aseguradora],
[nro_soat],
[cod_tipovehiculo]
from [Inteligencia].[dbo].[tb_vehiculo]
*********************************************************
select TOP 1000 [cod_infrac],
[cod_gradoinfrac],
[desc_infrac],
[multa],
from [Inteligencia].[dbo].[tb_Infraccion]
*********************************************************
select TOP 1000 [cod_conductor],
[cod_tipodocu],
[nro_tipodocu],
[licconducir_conductor],
[cod_categoriaconductor],
[nom_conductor],
[apepat_conductor],
[apemat_conductor],
[sexo_conductor],
[fecnac_conductor]
[codgrado_intruccion]
from [Inteligencia].[dbo].[tb_ConductorInfractor]
*********************************************************
select TOP 1000 [cod_horario],
[desc_horario],
[desc_rangos],
from [Inteligencia].[dbo].[tb_horario]
*********************************************************
select TOP 1000 [cod_tipocausa],
[desc_tipocausa],
from [Inteligencia].[dbo].[tb_TipoCausa]
*********************************************************
select TOP 1000 [cod_tiempo],
[tiempo_fecha],
[tiempo_dia],
[tiempo_dia_semana],
[tiempo_nombre_dia]
[tiempo_dia_mes],
[tiempo_semana_año],
[tiempo_semana_mes],
[tiempo_nombre_mes],
[tiempo_trimestre],
[tiempo_nombre_trimestre],
[tiempo_semestre],
[tiempo_nombre_semestre],
[tiempo_año]
from [Inteligencia].[dbo].[tb_tiempo]
********************************************************
FACT
Select TOP 1000 [cod_FactInfracVehicular],
[desc_InfracVehicular],
[cod_infrac],
...