pivot con variables, Sql Server

Language: Layout:

CREATE PROCEDURE sp_reporteSemana @FECHA DATE
AS
DECLARE @INICIO_SEMANA AS DATE
DECLARE @MARTES AS DATE
DECLARE @MIERCOLES AS DATE
DECLARE @JUEVES AS DATE
DECLARE @VIERNES AS DATE
DECLARE @SABADO AS DATE
DECLARE @FIN_SEMANA AS DATE

SET @INICIO_SEMANA = CAST(DATEADD(wk, DATEDIFF(wk, 0, @FECHA), 0) AS DATE)
SET @MARTES = DATEADD(DAY, 1, @INICIO_SEMANA)
SET @MIERCOLES = DATEADD(DAY, 2, @INICIO_SEMANA)
SET @JUEVES = DATEADD(DAY, 3, @INICIO_SEMANA)
SET @VIERNES = DATEADD(DAY, 4, @INICIO_SEMANA)
SET @SABADO = DATEADD(DAY, 5, @INICIO_SEMANA)
SET @FIN_SEMANA = CAST(DATEADD(wk, DATEDIFF(wk, 0, @FECHA), 6) AS DATE)

;with cte as (
  SELECT a.OPER_CODIGO CODIGO,
         a.OPER_NOMBRE + ' ' + a.OPER_APEPATER + ' ' + a.OPER_APEMATER OPERARIO,
         CAST(c.TCKT_FFINAL AS DATE) FECHAS,
         COUNT(b.TCKT_NUMERO) CANTIDAD
    FROM OPERARIO a
    JOIN BITACORA b ON a.OPER_CODIGO = b.OPER_CODIGO
    JOIN TICKET c ON b.TCKT_NUMERO = c.TCKT_NUMERO
   WHERE CAST(c.TCKT_FFINAL AS DATE) BETWEEN @INICIO_SEMANA AND @FIN_SEMANA
   GROUP BY a.OPER_CODIGO,
            a.OPER_NOMBRE + ' ' + a.OPER_APEPATER + ' ' + a.OPER_APEMATER,
            CAST(c.TCKT_FFINAL AS DATE)
)
select codigo,
       operario,
       coalesce(sum(case when fechas = @inicio_semana then cantidad end),0) as lunes,
       coalesce(sum(case when fechas = @martes then cantidad end),0) as martes,
       coalesce(sum(case when fechas = @miercoles then cantidad end),0) as miercoles,
       coalesce(sum(case when fechas = @jueves then cantidad end),0) as jueves,
       coalesce(sum(case when fechas = @viernes then cantidad end),0) as viernes,
       coalesce(sum(case when fechas = @sabado then cantidad end),0) as sabado,
       coalesce(sum(case when fechas = @fin_semana then cantidad end),0) as domingo
  from cte
 group by codigo, operario
 order by codigo, operario;
GO

SET dateformat dmy;

/*=========================================== OPERARIO ===========================================*/
CREATE TABLE OPERARIO(
	OPER_CODIGO			INT PRIMARY KEY NOT NULL IDENTITY(20170001,1),	
	OPER_DNI			INT NOT NULL UNIQUE,
	OPER_NOMBRE			VARCHAR(30) NOT NULL,
	OPER_APEPATER		VARCHAR(30) NOT NULL,
	OPER_APEMATER		VARCHAR(30) NOT NULL,
	OPER_CORREO			VARCHAR(30) NOT NULL UNIQUE,
	OPER_CONTRASEÑA		VARCHAR(30) NOT NULL DEFAULT 'operario',
	TIPO_OPER_CODIGO	INT NOT NULL
)
GO

/*=========================================== OPERARIO ===========================================*/
INSERT INTO OPERARIO VALUES(45878965,'Edgardo','Perez','Rivas','eperez@inkafarma.com.pe','operario',1)
INSERT INTO OPERARIO VALUES(45678954,'Juan','Zamora','Zapata','jzamora@inkafarma.com.pe','operario',1)
INSERT INTO OPERARIO VALUES(65487852,'María','Villena','Presentación','mvillena@inkafarma.com.pe','operario',1)
INSERT INTO OPERARIO VALUES(98745824,'Manuel','Ízaga','Martines','mizaga@inkafarma.com.pe','operario',1)
INSERT INTO OPERARIO VALUES(98563254,'Roberto','Mendoza','Meza','rmendoza@inkafarma.com.pe','operario',1)

INSERT INTO OPERARIO VALUES(45678452,'Mike','Stephen','Portnoy','mportnoy@inkafarma.com.pe','operario',2)
INSERT INTO OPERARIO VALUES(48745825,'Jhon','Carbajal','Enciso','jcarbajal@inkafarma.com.pe','operario',2)
INSERT INTO OPERARIO VALUES(65488521,'María','Labán','Salgado','mlaban@inkafarma.com.pe','operario',2)
INSERT INTO OPERARIO VALUES(08695484,'Grecia','Pardavé','Chiong','gpardave@inkafarma.com.pe','operario',2)
INSERT INTO OPERARIO VALUES(45879954,'Aldo','Ramirez','Hurtado','aramirez@inkafarma.com.pe','operario',2)

INSERT INTO OPERARIO VALUES(48658795,'Luis','Sánchez','Arteaga','lsanchez@inkafarma.com.pe','operario',3)
INSERT INTO OPERARIO VALUES(45879875,'Julio César','Tapia','Ortiz','jtapia@inkafarma.com.pe','operario',3)

/*=========================================== TICKET ===========================================*/
CREATE TABLE TICKET(
	TCKT_NUMERO			INT PRIMARY KEY NOT NULL IDENTITY(100,1),
	EMP_CODIGO			INT NOT NULL,
	TIPO_CODIGO			INT NOT NULL,
	CAT_CODIGO			INT NOT NULL,
	EQUIP_CODIGO		INT NOT NULL,
	SRV_CODIGO			INT NOT NULL,
	TCKT_FINICIO		DATETIME NOT NULL,
	TCKT_FFINAL			DATETIME NULL,
	TCKT_TITULO			VARCHAR(60) NOT NULL,
	TCKT_DESCRIPCION	VARCHAR(200) NOT NULL,
	EST_CODIGO			INT NOT NULL,
	VIA_CODIGO			INT NOT NULL
)
GO

----------------------------------------
-------------01-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES   	(20140003,1,1,3,1,'01-12-2016 9:00:00','01-12-2016 11:00:00','Teclado malogrado','El teclado del equipo principal esta defectuoso',5,1)
INSERT INTO TICKET VALUES	(20140004,2,1,5,5,'01-12-2016 10:00:00','01-12-2016 13:00:00','Falta cable RJ45','Solicitamos cable RJ45 para el servidor',5,3)
INSERT INTO TICKET VALUES	(20140005,1,2,14,7,'01-12-2016 11:00:00','01-12-2016 15:00:00','Conexion a internet','no puedo ingresar al office 365',5,2)
INSERT INTO TICKET VALUES	(20140006,2,2,12,9,'01-12-2016 12:00:00','01-12-2016 16:00:00','sistema de almacen','Solicito software del sistema de almacen',5,3)
INSERT INTO TICKET VALUES	(20140007,1,1,3,4,'01-12-2016 13:00:00','01-12-2016 17:00:00','Teclado malogrado','Se traba los botones',5,2)
INSERT INTO TICKET VALUES	(20140008,2,1,6,8,'01-12-2016 14:00:00','01-12-2016 16:30:00','Falta Impresoras','Solicitamos una nueva impresora',5,1)
INSERT INTO TICKET VALUES	(20140009,1,2,15,2,'01-12-2016 15:00:00','01-12-2016 17:00:00','reinstalar el sistema de planillas','Genera errores en el sistema',5,1)
INSERT INTO TICKET VALUES	(20140048,1,1,4,6,'01-12-2016 16:00:00','01-12-2016 18:00:00','Pantalla oscura','El monitor esta muy oscuro',5,3)
INSERT INTO TICKET VALUES	(20140049,2,2,15,6,'01-12-2016 11:00:00','01-12-2016 15:00:00','Necesito el sistema de planillas','solicito el programa de sistema de planillas',5,3)
INSERT INTO TICKET VALUES	(20140050,2,1,3,6,'01-12-2016 10:00:00','01-12-2016 14:00:00','Teclado nuevo','Solicito un cambio de teclado',5,2)
INSERT INTO TICKET VALUES	(20140051,1,2,12,6,'01-12-2016 9:00:00','01-12-2016 10:00:00','La PC se apaga sola','La PC se reinicia y se apaga sola cuando ingreso al sistema de almacen',5,2)
INSERT INTO TICKET VALUES	(20140052,1,1,4,6,'01-12-2016 8:00:00','01-12-2016 18:00:00','Programar el monitor','No puedo programar el monitor',5,3)
INSERT INTO TICKET VALUES	(20140015,1,1,4,9,'01-12-2016 10:00:00','01-12-2016 18:00:00','Sobrecalientamiento del monitor','Arreglar el equipo de refrigeracion del monitor',5,2)
INSERT INTO TICKET VALUES	(20140016,2,1,7,7,'01-12-2016 16:00:00','02-12-2016 11:00:00','Falta Scanners','El local carece de Scanners',5,3)
INSERT INTO TICKET VALUES	(20140017,1,2,16,1,'01-12-2016 17:00:00','02-12-2016 10:00:00','Desinstalo outlook','Se desinstalo el programa Microsoft outlook',5,3)
INSERT INTO TICKET VALUES	(20140018,2,2,15,5,'01-12-2016 18:00:00','03-12-2016 8:00:00','Sistema de plantillas  nuevo','Solicito nuevo sistema',5,1)

----------------------------------------
-------------02-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140019,1,1,10,4,'02-12-2016 8:00:00','02-12-2016 10:00:00','Sobrecalientamiento del Telefono movil','Se sobrecalienta la bateria de mi telefono',5,3)
INSERT INTO TICKET VALUES	(20140020,2,1,8,8,'02-12-2016 9:00:00','02-12-2016 11:00:00','Telefono nuevo','Solicito un cambio de Telefono',5,1)
INSERT INTO TICKET VALUES	(20140021,1,2,12,5,'02-12-2016 10:00:00','02-12-2016 12:00:00','Conexion al sistema almacen','Solicito driver o instalador del sistema ',5,3)
INSERT INTO TICKET VALUES	(20140022,2,2,14,2,'02-12-2016 11:00:00','02-12-2016 13:00:00','Paquete One Drive','Solicito software One Driver',5,2)
INSERT INTO TICKET VALUES	(20140023,1,1,6,8,'02-12-2016 12:00:00','02-12-2016 14:00:00','Impresora malograda','La impresora principal esta defectuoso',5,3)
INSERT INTO TICKET VALUES	(20140024,2,1,4,4,'02-12-2016 13:00:00','02-12-2016 15:00:00','Monitor nuevo','Solicito un cambio de monitor',5,2)
INSERT INTO TICKET VALUES	(20140025,1,2,15,3,'02-12-2016 14:00:00','02-12-2016 16:00:00','Word no abre','No puedo llenar el sistema de planillas',5,3)
INSERT INTO TICKET VALUES	(20140026,2,2,13,9,'02-12-2016 15:00:00','02-12-2016 16:00:00','Programar la tablet','No puedo programar la tablet',5,1)
INSERT INTO TICKET VALUES	(20140053,2,2,11,6,'02-12-2016 8:00:00','02-12-2016 18:00:00','Programa Microsoft Office','No puedo llenar los registros',5,1)
INSERT INTO TICKET VALUES	(20140054,2,1,10,6,'02-12-2016 9:00:00','02-12-2016 14:00:00','Falta Telefono movil','Solicitamos nuevo equipo',5,1)
INSERT INTO TICKET VALUES	(20140055,1,2,16,6,'02-12-2016 10:00:00','02-12-2016 13:00:00','Desinstalar Outlook','Genera errores en el sistema',5,2)
INSERT INTO TICKET VALUES	(20140056,1,1,9,6,'02-12-2016 11:00:00','02-12-2016 14:00:00','Pantalla oscura','No puedo ver los programas',5,2)
INSERT INTO TICKET VALUES	(20140057,2,2,15,6,'02-12-2016 12:00:00','02-12-2016 16:00:00','Paquete Office','Solicito software Office para el sistea de plantillas',5,1)
INSERT INTO TICKET VALUES	(20140058,2,1,8,6,'02-12-2016 15:00:00','02-12-2016 18:00:00','Falta cargadores','El equipo carece de cargadores',5,2)
INSERT INTO TICKET VALUES	(20140033,1,2,11,3,'02-12-2016 17:00:00','03-12-2016 8:00:00','Reinstalar Microsoft Office','No puedo empezar a rellenar datos',5,1)
INSERT INTO TICKET VALUES	(20140034,1,2,13,4,'02-12-2016 18:00:00','04-12-2016 10:00:00','Usuario office 365','Solicito el programa Office 365',5,1)

----------------------------------------
-------------03-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140035,1,1,6,1,'03-12-2016 10:00:00','03-12-2016 18:00:00','Impresora atascada','Las hojas aveces se atascan ',5,3)
INSERT INTO TICKET VALUES	(20140036,2,1,3,7,'03-12-2016 11:00:00','03-12-2016 16:00:00','Solicito nuevo teclado','Solicito el cambio de los teclados',5,2)
INSERT INTO TICKET VALUES	(20140037,1,2,16,4,'03-12-2016 12:00:00','03-12-2016 14:00:00','Usuario en Microsoft Outlook','Solicito nuevo usuario en Microsoft Outlook',5,3)
INSERT INTO TICKET VALUES	(20140038,2,2,11,9,'03-12-2016 13:00:00','03-12-2016 13:00:00','Solicito Nueva version del Office','Solicito nueva version del Office 2015',5,2)
INSERT INTO TICKET VALUES	(20140039,1,1,3,5,'03-12-2016 14:00:00','03-12-2016 17:00:00','Teclado defectuoso','No digita las letras a,c,y,g',5,2)
INSERT INTO TICKET VALUES	(20140040,2,1,9,1,'03-12-2016 15:00:00','03-12-2016 16:00:00','Tablet nueva','Necesito un Tablet nueva con todos sus programas',5,3)
INSERT INTO TICKET VALUES	(20140041,1,2,13,3,'03-12-2016 16:00:00','03-12-2016 18:00:00','Olvido de contraseña','Me olvide mi contraseña en el Office 365',5,3)
INSERT INTO TICKET VALUES	(20140042,2,2,15,8,'03-12-2016 17:00:00','03-12-2016 18:00:00','Solicito programa','Solicito programa de sistemas de plnatillas ',5,1)
INSERT INTO TICKET VALUES	(20140043,1,1,10,5,'03-12-2016 9:00:00','03-12-2016 13:00:00','Sobrecalientaiento de bateria','La bateria del movil se para calentando',5,3)
INSERT INTO TICKET VALUES	(20140044,2,1,7,4,'03-12-2016 8:00:00','03-12-2016 11:00:00','Scanner nuevo','Solicito un scanner nuevo',5,2)
INSERT INTO TICKET VALUES	(20140045,1,2,13,1,'03-12-2016 10:00:00','03-12-2016 18:00:00','Usuario Office 365','Necesito un nuevo usuario en Office 365',5,2)
INSERT INTO TICKET VALUES	(20140046,1,2,13,2,'03-12-2016 18:00:00','04-12-2016 8:00:00','Olvido de clave','Olvide la clave del office 365',5,2)
INSERT INTO TICKET VALUES	(20140047,1,1,3,9,'03-12-2016 18:00:00','05-12-2016 8:00:00','Defectuoso','Los numero no funcionan',5,1)

----------------------------------------
-------------04-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140010,2,2,11,4,'04-12-2016 16:00:00','04-12-2016 18:00:00','Solicito nuevo usuario','Solicito un usuario ',5,3)
INSERT INTO TICKET VALUES	(20140011,1,1,7,1,'04-12-2016 15:00:00','04-12-2016 16:00:00','Usar Scanner','No se como usar el Scanner',5,3)
INSERT INTO TICKET VALUES	(20140012,2,1,3,2,'04-12-2016 16:00:00','04-12-2016 18:00:00','Nuevo teclado','Solicito un buen teclado',5,2)
INSERT INTO TICKET VALUES	(20140013,1,2,13,3,'04-12-2016 8:00:00','04-12-2016 15:00:00','Ingresar usuario','Olvide mis datos de ingreso',5,2)
INSERT INTO TICKET VALUES	(20140014,2,2,15,5,'04-12-2016 9:00:00','04-12-2016 17:00:00','Driver instlador','Solicito el software Sistema de plantillas o el URL',5,2)
INSERT INTO TICKET VALUES	(20140027,1,1,3,4,'04-12-2016 16:00:00','04-12-2016 18:00:00','Teclado defectuoso','Los botones se paran trabando',5,3)
INSERT INTO TICKET VALUES	(20140028,2,1,6,2,'04-12-2016 8:00:00','04-12-2016 14:00:00','Impresora nueva','Solicito una impresora de gama alta',5,3)
INSERT INTO TICKET VALUES	(20140029,1,2,12,5,'04-12-2016 9:00:00','04-12-2016 13:00:00','Olvide usuario','No puedo iniciar al sistema de plantillas por mi usuario',5,2)
INSERT INTO TICKET VALUES	(20140030,2,2,11,7,'04-12-2016 10:00:00','04-12-2016 16:00:00','Requiero el programa','Solicito el programa de Microsoft Office',5,3)
INSERT INTO TICKET VALUES	(20140031,1,1,3,1,'04-12-2016 11:00:00','04-12-2016 15:00:00','Teclado malogrado','El teclado no responde a veces',5,1)
INSERT INTO TICKET VALUES	(20140032,2,1,7,5,'04-12-2016 16:00:00','04-12-2016 18:00:00','Scanner nuevo','Necesitamos dos scanners',5,2)
INSERT INTO TICKET VALUES	(20140059,1,2,14,6,'04-12-2016 8:00:00','04-12-2016 18:00:00','Uso de One Driver','no puedo subir archivos',5,2)
INSERT INTO TICKET VALUES	(20140060,1,1,7,6,'04-12-2016 10:00:00','04-12-2016 18:00:00','Scanner defectuoso','Se prende y se apaga solo',5,3)
INSERT INTO TICKET VALUES	(20140061,2,2,13,6,'04-12-2016 11:00:00','04-12-2016 14:00:00','Crear usuario','Solicito que se cree un usuario para Office 365',5,3)
INSERT INTO TICKET VALUES	(20140062,2,1,6,6,'04-12-2016 13:00:00','05-12-2016 11:00:00','Impresora nueva','Solicito una impresora de gama alta',5,3)
INSERT INTO TICKET VALUES	(20140063,1,2,13,6,'04-12-2016 18:00:00','06-12-2016 8:00:00','Programa office 365','Solicito el programa Office 365',5,2)

----------------------------------------
-------------05-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140064,1,1,5,6,'05-12-2016 10:00:00','05-12-2016 13:00:00','Caida del servidor','No puedo ingresar al sistema por la caida del servidor',5,2)
INSERT INTO TICKET VALUES	(20140065,2,2,12,6,'05-12-2016 11:00:00','05-12-2016 14:00:00','sistema de almacen','Solicito software del sistema de almacen',5,2)
INSERT INTO TICKET VALUES	(20140066,2,1,4,6,'05-12-2016 13:00:00','05-12-2016 15:00:00','Monitor nuevo','Solicito un cambio de monitor',5,3)
INSERT INTO TICKET VALUES	(20140067,1,2,11,6,'05-12-2016 14:00:00','05-12-2016 16:00:00','Reinstalar Microsoft Office','No puedo empezar a rellenar datos',5,3)
INSERT INTO TICKET VALUES	(20140068,1,1,3,6,'05-12-2016 12:00:00','05-12-2016 17:00:00','Teclado malogrado','Se traba los botones',5,2)
INSERT INTO TICKET VALUES	(20140069,2,2,13,6,'05-12-2016 15:00:00','05-12-2016 18:00:00','Crear usuario','Solicito que se cree un usuario para Office 365',5,3)
INSERT INTO TICKET VALUES	(20140070,2,1,3,6,'05-12-2016 13:00:00','05-12-2016 14:00:00','Teclado nuevo','Solicito un cambio de teclado',5,2)
INSERT INTO TICKET VALUES	(20140071,1,2,14,6,'05-12-2016 12:00:00','05-12-2016 14:00:00','Uso de One Driver','no puedo subir archivos',5,1)
INSERT INTO TICKET VALUES	(20140072,1,1,3,6,'05-12-2016 8:00:00','05-12-2016 13:00:00','Teclado defectuoso','Los botones se paran trabando',5,3)
INSERT INTO TICKET VALUES	(20140073,2,2,15,6,'05-12-2016 15:00:00','05-12-2016 16:00:00','Driver instalador','Solicito el software Sistema de plantillas o el URL',5,3)
INSERT INTO TICKET VALUES	(20140074,2,1,3,6,'05-12-2016 14:00:00','05-12-2016 18:00:00','Nuevo teclado','Solicito un buen teclado',5,3)
INSERT INTO TICKET VALUES	(20140075,1,2,16,6,'05-12-2016 17:00:00','05-12-2016 18:00:00','Usuario en Microsoft Outlook','Solicito nuevo usuario en Microsoft Outlook',5,2)
INSERT INTO TICKET VALUES	(20140076,1,1,4,6,'05-12-2016 15:00:00','05-12-2016 16:00:00','Sobrecalientamiento del monitor','Arreglar el equipo de refrigeracion del monitor',5,1)
INSERT INTO TICKET VALUES	(20140077,2,2,14,6,'05-12-2016 10:00:00','05-12-2016 18:00:00','Paquete One Drive','Solicito software One Driver',5,1)
INSERT INTO TICKET VALUES	(20140078,2,1,5,6,'05-12-2016 18:00:00','06-12-2016 8:00:00','Falta cable RJ45','Solicitamos cable RJ45 para el servidor',5,1)
INSERT INTO TICKET VALUES	(20140079,1,2,11,6,'05-12-2016 18:00:00','07-12-2016 8:00:00','Reinstalar Microsoft Office','No puedo empezar a rellenar datos',5,3)

----------------------------------------
-------------06-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140080,1,1,6,6,'06-12-2016 8:00:00','06-12-2016 18:00:00','Impresora malograda','La impresora principal esta defectuoso',5,1)
INSERT INTO TICKET VALUES	(20140081,2,2,13,6,'06-12-2016 9:00:00','06-12-2016 12:00:00','Crear usuario','Solicito que se cree un usuario para Office 365',5,2)
INSERT INTO TICKET VALUES	(20140082,2,1,7,6,'06-12-2016 10:00:00','06-12-2016 13:00:00','Scanner nuevo','Necesitamos dos scanners',5,1)
INSERT INTO TICKET VALUES	(20140083,1,2,15,6,'06-12-2016 11:00:00','06-12-2016 14:00:00','reinstalar el sistema de planillas','Genera errores en el sistema',5,3)
INSERT INTO TICKET VALUES	(20140084,1,1,8,6,'06-12-2016 12:00:00','06-12-2016 15:00:00','Telefono sin red','El telefono no me permite hacer llamadas por falta de red',5,3)
INSERT INTO TICKET VALUES	(20140085,2,2,15,6,'06-12-2016 13:00:00','06-12-2016 16:00:00','Driver instalador','Solicito el software Sistema de plantillas o el URL',5,2)
INSERT INTO TICKET VALUES	(20140086,2,1,9,6,'06-12-2016 10:00:00','06-12-2016 17:00:00','Tablet nueva','Necesito un Tablet nueva con todos sus programas',5,2)
INSERT INTO TICKET VALUES	(20140087,1,2,14,6,'06-12-2016 8:00:00','06-12-2016 18:00:00','Uso de One Driver','no puedo subir archivos',5,1)
INSERT INTO TICKET VALUES	(20140088,1,1,10,6,'06-12-2016 9:00:00','06-12-2016 13:00:00','Sobrecalientaiento de bateria','La bateria del movil se para calentando',5,1)
INSERT INTO TICKET VALUES	(20140089,2,2,13,6,'06-12-2016 10:00:00','06-12-2016 14:00:00','Crear usuario','Solicito que se cree un usuario para Office 365',5,2)
INSERT INTO TICKET VALUES	(20140090,2,1,5,6,'06-12-2016 11:00:00','06-12-2016 15:00:00','Falta cable RJ45','Solicitamos cable RJ45 para el servidor',5,1)
INSERT INTO TICKET VALUES	(20140091,1,2,14,6,'06-12-2016 12:00:00','06-12-2016 16:00:00','Uso de One Driver','no puedo subir archivos',5,3)
INSERT INTO TICKET VALUES	(20140092,1,1,4,6,'06-12-2016 13:00:00','06-12-2016 17:00:00','Sobrecalientamiento del monitor','Arreglar el equipo de refrigeracion del monitor',5,1)
INSERT INTO TICKET VALUES	(20140093,2,2,12,6,'06-12-2016 14:00:00','06-12-2016 18:00:00','sistema de almacen','Solicito software del sistema de almacen',5,2)
INSERT INTO TICKET VALUES	(20140094,2,1,3,6,'06-12-2016 15:00:00','07-12-2016 8:00:00','Nuevo teclado','Solicito un buen teclado',5,3)
INSERT INTO TICKET VALUES	(20140095,1,2,11,6,'06-12-2016 16:00:00','08-12-2016 8:00:00','Reinstalar Microsoft Office','No puedo empezar a rellenar datos',5,2)

----------------------------------------
-------------07-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140096,1,1,3,6,'07-12-2016 18:00:00','07-12-2016 18:00:00','Teclado Defectuoso','Los numero no funcionan',5,1)
INSERT INTO TICKET VALUES	(20140097,2,2,15,6,'07-12-2016 18:00:00','07-12-2016 18:00:00','Driver instalador','Solicito el software Sistema de plantillas o el URL',5,2)
INSERT INTO TICKET VALUES	(20140098,2,1,3,6,'07-12-2016 18:00:00','07-12-2016 18:00:00','Nuevo teclado','Solicito un buen teclado',5,3)
INSERT INTO TICKET VALUES	(20140099,1,2,13,6,'07-12-2016 18:00:00','07-12-2016 18:00:00','Programa office 365','Solicito el programa Office 365',5,2)
INSERT INTO TICKET VALUES	(20140100,1,1,3,6,'07-12-2016 18:00:00','07-12-2016 18:00:00','Teclado malogrado','El teclado no responde a veces',5,1)
INSERT INTO TICKET VALUES	(20140075,1,2,16,6,'07-12-2016 17:00:00','07-12-2016 18:00:00','Usuario en Microsoft Outlook','Solicito nuevo usuario en Microsoft Outlook',5,2)
INSERT INTO TICKET VALUES	(20140076,1,1,4,6,'07-12-2016 15:00:00','07-12-2016 16:00:00','Sobrecalientamiento del monitor','Arreglar el equipo de refrigeracion del monitor',5,1)
INSERT INTO TICKET VALUES	(20140077,2,2,14,6,'07-12-2016 10:00:00','07-12-2016 18:00:00','Paquete One Drive','Solicito software One Driver',5,1)
INSERT INTO TICKET VALUES	(20140045,1,2,13,1,'07-12-2016 10:00:00','07-12-2016 18:00:00','Usuario Office 365','Necesito un nuevo usuario en Office 365',5,2)
INSERT INTO TICKET VALUES   	(20140001,1,2,11  ,   3   ,'07-12-2016 08:00:00', '07-12-2016 12:30:00','Word no abre','No puedo abrir el word de mi usb',3,3)
INSERT INTO TICKET VALUES   	(20140002,2,2,13  ,   2   ,'07-12-2016 10:00:00', '07-12-2016 12:00:00','Creación de correo','Solicito que se cree el correo corporativo de un nuevo empleado',5,2)
INSERT INTO TICKET VALUES	(20140082,2,1,7,6,'07-12-2016 10:00:00','07-12-2016 13:00:00','Scanner nuevo','Necesitamos dos scanners',5,1)
INSERT INTO TICKET VALUES	(20140083,1,2,15,6,'07-12-2016 11:00:00','07-12-2016 14:00:00','reinstalar el sistema de planillas','Genera errores en el sistema',5,3)
INSERT INTO TICKET VALUES	(20140084,1,1,8,6,'07-12-2016 12:00:00','07-12-2016 15:00:00','Telefono sin red','El telefono no me permite hacer llamadas por falta de red',5,3)
INSERT INTO TICKET VALUES	(20140046,1,2,13,2,'07-12-2016 18:00:00','08-12-2016 8:00:00','Olvido de clave','Olvide la clave del office 365',5,2)
INSERT INTO TICKET VALUES	(20140047,1,1,3,9,'07-12-2016 18:00:00','09-12-2016 8:00:00','Defectuoso','Los numero no funcionan',5,1)

----------------------------------------
-------------08-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140048,1,1,4,6,'08-12-2016 16:00:00','08-12-2016 18:00:00','Pantalla oscura','El monitor esta muy oscuro',5,3)
INSERT INTO TICKET VALUES	(20140049,2,2,15,6,'08-12-2016 11:00:00','08-12-2016 15:00:00','Necesito el sistema de planillas','solicito el programa de sistema de planillas',5,3)
INSERT INTO TICKET VALUES	(20140082,2,1,7,6,'08-12-2016 10:00:00','08-12-2016 13:00:00','Scanner nuevo','Necesitamos dos scanners',5,1)
INSERT INTO TICKET VALUES	(20140083,1,2,15,6,'08-12-2016 11:00:00','08-12-2016 14:00:00','reinstalar el sistema de planillas','Genera errores en el sistema',5,3)
INSERT INTO TICKET VALUES	(20140059,1,2,14,6,'08-12-2016 8:00:00','08-12-2016 18:00:00','Uso de One Driver','no puedo subir archivos',5,2)
INSERT INTO TICKET VALUES	(20140060,1,1,7,6,'08-12-2016 10:00:00','08-12-2016 18:00:00','Scanner defectuoso','Se prende y se apaga solo',5,3)																
INSERT INTO TICKET VALUES   	(20140003,1,1,3,1,'08-12-2016 9:00:00','08-12-2016 11:00:00','Teclado malogrado','El teclado del equipo principal esta defectuoso',5,1)
INSERT INTO TICKET VALUES	(20140004,2,1,5,5,'08-12-2016 10:00:00','08-12-2016 13:00:00','Falta cable RJ45','Solicitamos cable RJ45 para el servidor',5,3)
INSERT INTO TICKET VALUES	(20140023,1,1,6,8,'08-12-2016 12:00:00','08-12-2016 14:00:00','Impresora malograda','La impresora principal esta defectuoso',5,3)
INSERT INTO TICKET VALUES	(20140024,2,1,4,4,'08-12-2016 13:00:00','08-12-2016 15:00:00','Monitor nuevo','Solicito un cambio de monitor',5,2)
INSERT INTO TICKET VALUES	(20140025,1,2,15,3,'08-12-2016 14:00:00','08-12-2016 16:00:00','Word no abre','No puedo llenar el sistema de planillas',5,3)
INSERT INTO TICKET VALUES	(20140035,1,1,6,1,'08-12-2016 10:00:00','08-12-2016 18:00:00','Impresora atascada','Las hojas aveces se atascan ',5,3)
INSERT INTO TICKET VALUES	(20140036,2,1,3,7,'08-12-2016 11:00:00','08-12-2016 16:00:00','Solicito nuevo teclado','Solicito el cambio de los teclados',5,2)
INSERT INTO TICKET VALUES	(20140037,2,2,16,4,'08-12-2016 12:00:00','08-12-2016 14:00:00','Usuario en Microsoft Outlook','Solicito nuevo usuario en Microsoft Outlook',5,3)
INSERT INTO TICKET VALUES	(20140017,1,2,16,1,'08-12-2016 17:00:00','09-12-2016 10:00:00','Desinstalo outlook','Se desinstalo el programa Microsoft outlook',5,3)
INSERT INTO TICKET VALUES	(20140034,1,2,13,4,'08-12-2016 18:00:00','10-12-2016 10:00:00','Usuario office 365','Solicito el programa Office 365',5,1)

----------------------------------------
-------------09-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140002,1,2,11,3,'09-12-2016 8:00:00','09-12-2016 14:00:00','Word no abre','No puedo abrir el word de mi usb',5,1)
INSERT INTO TICKET VALUES	(20140003,2,2,13,2,'09-12-2016 11:00:00','09-12-2016 14:00:00','Crear usuario','Solicito que se cree un usuario para Office 365',5,2)
INSERT INTO TICKET VALUES	(20140004,1,1,4,1,'09-12-2016 12:00:00','09-12-2016 14:00:00','Pantalla oscura','El monitor esta muy oscuro',5,3)
INSERT INTO TICKET VALUES	(20140005,2,1,5,5,'09-12-2016 13:00:00','09-12-2016 14:00:00','Falta cable RJ45','Solicitamos cable RJ45 para el servidor',5,2)
INSERT INTO TICKET VALUES	(20140006,1,2,14,7,'09-12-2016 11:00:00','09-12-2016 15:00:00','Uso de One Driver','no puedo subir archivos',5,1)
INSERT INTO TICKET VALUES	(20140048,1,2,13,6,'09-12-2016 12:00:00','09-12-2016 15:00:00','Usuario office 365','Solicito el programa Office 365',5,1)
INSERT INTO TICKET VALUES	(20140049,2,2,12,6,'09-12-2016 11:00:00','09-12-2016 16:00:00','sistema de almacen','Solicito software del sistema de almacen',5,1)
INSERT INTO TICKET VALUES	(20140050,1,1,4,6,'09-12-2016 11:00:00','09-12-2016 16:00:00','Pantalla oscura','El monitor esta muy oscuro',5,1)
INSERT INTO TICKET VALUES	(20140051,2,2,15,6,'09-12-2016 15:00:00','09-12-2016 17:00:00','Necesito el sistema de planillas','solicito el programa de sistema de planillas',5,3)
INSERT INTO TICKET VALUES	(20140052,2,1,3,6,'09-12-2016 16:00:00','09-12-2016 18:00:00','Solicito nuevo teclado','Solicito el cambio de los teclados',5,2)
INSERT INTO TICKET VALUES	(20140007,2,2,12,9,'09-12-2016 15:00:00','09-12-2016 18:00:00','sistema de almacen','Solicito software del sistema de almacen',5,3)
INSERT INTO TICKET VALUES	(20140008,1,1,5,4,'09-12-2016 09:00:00','09-12-2016 10:00:00','Caida del servidor','No puedo ingresar al sistema por la caida del servidor',5,2)
INSERT INTO TICKET VALUES	(20140009,2,1,6,8,'09-12-2016 08:00:00','09-12-2016 10:00:00','Impresora nueva','Solicito una impresora de gama alta',5,3)
INSERT INTO TICKET VALUES	(20140053,1,2,12,6,'09-12-2016 18:00:00','09-12-2016 10:00:00','Olvide usuario','No puedo iniciar al sistema de plantillas por mi usuario',5,2)
INSERT INTO TICKET VALUES	(20140054,1,1,4,6,'09-12-2016 18:00:00','10-12-2016 08:00:00','Pantalla oscura','El monitor esta muy oscuro',5,3)
INSERT INTO TICKET VALUES	(20140055,2,2,11,6,'09-12-2016 18:00:00','11-12-2016 08:00:00','Requiero el programa','Solicito el programa de Microsoft Office',5,3)

----------------------------------------
-------------10-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140056,2,1,10,6,'10-12-2016 08:00:00','10-12-2016 14:00:00','Falta Telefono movil','Solicitamos nuevo equipo',5,3)
INSERT INTO TICKET VALUES	(20140057,1,2,16,6,'10-12-2016 09:00:00','10-12-2016 15:00:00','Desinstalo outlook','Se desinstalo el programa Microsoft outlook',5,3)
INSERT INTO TICKET VALUES	(20140058,1,1,9,6,'10-12-2016 10:00:00','10-12-2016 15:00:00','Pantalla oscura','No puedo ver los programas',5,2)
INSERT INTO TICKET VALUES	(20140059,2,2,15,6,'10-12-2016 11:00:00','10-12-2016 16:00:00','Necesito el sistema de planillas','solicito el programa de sistema de planillas',5,2)
INSERT INTO TICKET VALUES	(20140010,1,2,15,2,'10-12-2016 12:00:00','10-12-2016 16:00:00','Word no abre','No puedo llenar el sistema de planillas',5,2)
INSERT INTO TICKET VALUES	(20140011,2,2,11,4,'10-12-2016 14:00:00','10-12-2016 17:00:00','Requiero el programa','Solicito el programa de Microsoft Office',5,1)
INSERT INTO TICKET VALUES	(20140012,1,1,7,1,'10-12-2016 13:00:00','10-12-2016 17:00:00','Scanner defectuoso','Se prende y se apaga solo',5,3)
INSERT INTO TICKET VALUES	(20140013,2,1,3,2,'10-12-2016 15:00:00','10-12-2016 18:00:00','Solicito nuevo teclado','Solicito el cambio de los teclados',5,3)
INSERT INTO TICKET VALUES	(20140014,1,2,13,3,'10-12-2016 16:00:00','10-12-2016 18:00:00','Usuario office 365','Solicito el programa Office 365',5,3)
INSERT INTO TICKET VALUES	(20140015,2,2,15,5,'10-12-2016 16:00:00','10-12-2016 18:00:00','Necesito el sistema de planillas','solicito el programa de sistema de planillas',5,2)
INSERT INTO TICKET VALUES	(20140016,1,1,4,9,'10-12-2016 15:00:00','10-12-2016 15:00:00','Pantalla oscura','El monitor esta muy oscuro',5,1)
INSERT INTO TICKET VALUES	(20140017,2,1,5,7,'10-12-2016 14:00:00','10-12-2016 15:00:00','Falta cable RJ45','Solicitamos cable RJ45 para el servidor',5,1)
INSERT INTO TICKET VALUES	(20140018,1,2,16,1,'10-12-2016 13:00:00','10-12-2016 15:00:00','Desinstalo outlook','Se desinstalo el programa Microsoft outlook',5,3)
INSERT INTO TICKET VALUES	(20140019,2,2,15,5,'10-12-2016 12:00:00','10-12-2016 16:00:00','Necesito el sistema de planillas','solicito el programa de sistema de planillas',5,2)
INSERT INTO TICKET VALUES	(20140020,1,1,10,4,'10-12-2016 18:00:00','11-12-2016 10:00:00','Sobrecalientamiento del Telefono movil','Se sobrecalienta la bateria de mi telefono',5,2)
INSERT INTO TICKET VALUES	(20140021,2,1,8,8,'10-12-2016 18:00:00','12-12-2016 08:00:00','Falta cargadores','El equipo carece de cargadores',5,2)

----------------------------------------
-------------11-12-2016----------------- 
----------------------------------------

INSERT INTO TICKET VALUES	(20140022,1,2,14,5,'11-12-2016 08:00:00','11-12-2016 10:00:00','Uso de One Driver','no puedo subir archivos',5,2)
INSERT INTO TICKET VALUES	(20140023,2,2,12,2,'11-12-2016 08:00:00','11-12-2016 12:00:00','sistema de almacen','Solicito software del sistema de almacen',5,2)
INSERT INTO TICKET VALUES	(20140024,1,1,6,8,'11-12-2016 08:00:00','11-12-2016 14:00:00','Impresora atascada','Las hojas aveces se atascan ',5,3)
INSERT INTO TICKET VALUES	(20140025,2,1,4,4,'11-12-2016 09:00:00','11-12-2016 15:00:00','Monitor nuevo','Solicito un cambio de monitor',5,1)
INSERT INTO TICKET VALUES	(20140026,1,2,15,3,'11-12-2016 16:00:00','11-12-2016 17:00:00','Word no abre','No puedo llenar el sistema de planillas',5,2)
INSERT INTO TICKET VALUES	(20140027,2,2,13,9,'11-12-2016 14:00:00','11-12-2016 16:00:00','Crear usuario','Solicito que se cree un usuario para Office 365',5,1)
INSERT INTO TICKET VALUES	(20140028,1,1,7,4,'11-12-2016 13:00:00','11-12-2016 15:00:00','Scanner defectuoso','Se prende y se apaga solo',5,3)
INSERT INTO TICKET VALUES	(20140029,2,1,6,2,'11-12-2016 11:00:00','11-12-2016 17:00:00','Impresora nueva','Solicito una impresora de gama alta',5,2)
INSERT INTO TICKET VALUES	(20140030,1,2,12,5,'11-12-2016 13:00:00','11-12-2016 15:00:00','Olvide usuario','No puedo iniciar al sistema de plantillas por mi usuario',5,3)
INSERT INTO TICKET VALUES	(20140031,2,2,11,7,'11-12-2016 12:00:00','11-12-2016 14:00:00','Requiero el programa','Solicito el programa de Microsoft Office',5,2)
INSERT INTO TICKET VALUES	(20140032,1,1,3,1,'11-12-2016 16:00:00','11-12-2016 17:00:00','Teclado malogrado','El teclado del equipo principal esta defectuoso',5,2)
INSERT INTO TICKET VALUES	(20140033,2,1,7,5,'11-12-2016 12:00:00','11-12-2016 18:00:00','Scanner nuevo','Necesitamos dos scanners',5,2)
INSERT INTO TICKET VALUES	(20140060,2,1,8,6,'11-12-2016 15:00:00','11-12-2016 15:00:00','Falta cargadores','El equipo carece de cargadores',5,3)
INSERT INTO TICKET VALUES	(20140061,1,2,14,6,'11-12-2016 11:00:00','12-12-2016 08:00:00','Uso de One Driver','no puedo subir archivos',5,2)
INSERT INTO TICKET VALUES	(20140062,1,1,7,6,'11-12-2016 18:00:00','12-12-2016 08:00:00','Scanner defectuoso','Se prende y se apaga solo',5,3)
INSERT INTO TICKET VALUES	(20140063,2,2,13,6,'11-12-2016 18:00:00','13-12-2016 08:00:00','Crear usuario','Solicito que se cree un usuario para Office 365',5,2)

/*=========================================== BITÁCORA ===========================================*/
CREATE TABLE BITACORA(
	BIT_CODIGO		INT PRIMARY KEY NOT NULL IDENTITY(15001,1),
	TCKT_NUMERO		INT NOT NULL UNIQUE,
	OPER_CODIGO		INT NOT NULL
)
GO

ALTER TABLE BITACORA ADD FOREIGN KEY (TCKT_NUMERO) REFERENCES TICKET(TCKT_NUMERO)
ALTER TABLE BITACORA ADD FOREIGN KEY (OPER_CODIGO) REFERENCES OPERARIO(OPER_CODIGO)
GO

INSERT INTO BITACORA VALUES(100,20170005)
INSERT INTO BITACORA VALUES(101,20170005)
INSERT INTO BITACORA VALUES(102,20170005)
INSERT INTO BITACORA VALUES(103,20170011)
INSERT INTO BITACORA VALUES(104,20170009)
INSERT INTO BITACORA VALUES(105,20170010)
INSERT INTO BITACORA VALUES(106,20170005)
INSERT INTO BITACORA VALUES(107,20170010)
INSERT INTO BITACORA VALUES(108,20170007)
INSERT INTO BITACORA VALUES(109,20170009)
INSERT INTO BITACORA VALUES(110,20170008)
INSERT INTO BITACORA VALUES(111,20170003)
INSERT INTO BITACORA VALUES(112,20170012)
INSERT INTO BITACORA VALUES(113,20170005)
INSERT INTO BITACORA VALUES(114,20170010)
INSERT INTO BITACORA VALUES(115,20170012)
INSERT INTO BITACORA VALUES(116,20170005)
INSERT INTO BITACORA VALUES(117,20170010)
INSERT INTO BITACORA VALUES(118,20170010)
INSERT INTO BITACORA VALUES(119,20170006)
INSERT INTO BITACORA VALUES(120,20170006)
INSERT INTO BITACORA VALUES(121,20170001)
INSERT INTO BITACORA VALUES(122,20170012)
INSERT INTO BITACORA VALUES(123,20170009)
INSERT INTO BITACORA VALUES(124,20170012)
INSERT INTO BITACORA VALUES(125,20170004)
INSERT INTO BITACORA VALUES(126,20170007)
INSERT INTO BITACORA VALUES(127,20170007)
INSERT INTO BITACORA VALUES(128,20170007)
INSERT INTO BITACORA VALUES(129,20170008)
INSERT INTO BITACORA VALUES(130,20170010)
INSERT INTO BITACORA VALUES(131,20170008)
INSERT INTO BITACORA VALUES(132,20170002)
INSERT INTO BITACORA VALUES(133,20170005)
INSERT INTO BITACORA VALUES(134,20170011)
INSERT INTO BITACORA VALUES(135,20170005)
INSERT INTO BITACORA VALUES(136,20170004)
INSERT INTO BITACORA VALUES(137,20170006)
INSERT INTO BITACORA VALUES(138,20170009)
INSERT INTO BITACORA VALUES(139,20170009)
INSERT INTO BITACORA VALUES(140,20170004)
INSERT INTO BITACORA VALUES(141,20170005)
INSERT INTO BITACORA VALUES(142,20170001)
INSERT INTO BITACORA VALUES(143,20170004)
INSERT INTO BITACORA VALUES(144,20170012)
INSERT INTO BITACORA VALUES(145,20170001)
INSERT INTO BITACORA VALUES(146,20170012)
INSERT INTO BITACORA VALUES(147,20170010)
INSERT INTO BITACORA VALUES(148,20170008)
INSERT INTO BITACORA VALUES(149,20170002)
INSERT INTO BITACORA VALUES(150,20170012)
INSERT INTO BITACORA VALUES(151,20170002)
INSERT INTO BITACORA VALUES(152,20170009)
INSERT INTO BITACORA VALUES(153,20170011)
INSERT INTO BITACORA VALUES(154,20170004)
INSERT INTO BITACORA VALUES(155,20170004)
INSERT INTO BITACORA VALUES(156,20170005)
INSERT INTO BITACORA VALUES(157,20170006)
INSERT INTO BITACORA VALUES(158,20170008)
INSERT INTO BITACORA VALUES(159,20170002)
INSERT INTO BITACORA VALUES(160,20170006)
INSERT INTO BITACORA VALUES(161,20170010)
INSERT INTO BITACORA VALUES(162,20170001)
INSERT INTO BITACORA VALUES(163,20170009)
INSERT INTO BITACORA VALUES(164,20170001)
INSERT INTO BITACORA VALUES(165,20170012)
INSERT INTO BITACORA VALUES(166,20170007)
INSERT INTO BITACORA VALUES(167,20170010)
INSERT INTO BITACORA VALUES(168,20170012)
INSERT INTO BITACORA VALUES(169,20170008)
INSERT INTO BITACORA VALUES(170,20170011)
INSERT INTO BITACORA VALUES(171,20170001)
INSERT INTO BITACORA VALUES(172,20170011)
INSERT INTO BITACORA VALUES(173,20170009)
INSERT INTO BITACORA VALUES(174,20170007)
INSERT INTO BITACORA VALUES(175,20170003)
INSERT INTO BITACORA VALUES(176,20170006)
INSERT INTO BITACORA VALUES(177,20170010)
INSERT INTO BITACORA VALUES(178,20170008)
INSERT INTO BITACORA VALUES(179,20170008)
INSERT INTO BITACORA VALUES(180,20170010)
INSERT INTO BITACORA VALUES(181,20170003)
INSERT INTO BITACORA VALUES(182,20170008)
INSERT INTO BITACORA VALUES(183,20170010)
INSERT INTO BITACORA VALUES(184,20170007)
INSERT INTO BITACORA VALUES(185,20170010)
INSERT INTO BITACORA VALUES(186,20170008)
INSERT INTO BITACORA VALUES(187,20170009)
INSERT INTO BITACORA VALUES(188,20170012)
INSERT INTO BITACORA VALUES(189,20170002)
INSERT INTO BITACORA VALUES(190,20170002)
INSERT INTO BITACORA VALUES(191,20170010)
INSERT INTO BITACORA VALUES(192,20170008)
INSERT INTO BITACORA VALUES(193,20170001)
INSERT INTO BITACORA VALUES(194,20170008)
INSERT INTO BITACORA VALUES(195,20170011)
INSERT INTO BITACORA VALUES(196,20170011)
INSERT INTO BITACORA VALUES(197,20170008)
INSERT INTO BITACORA VALUES(198,20170012)
INSERT INTO BITACORA VALUES(199,20170006)
INSERT INTO BITACORA VALUES(200,20170002)
INSERT INTO BITACORA VALUES(201,20170007)
INSERT INTO BITACORA VALUES(202,20170009)
INSERT INTO BITACORA VALUES(203,20170006)
INSERT INTO BITACORA VALUES(204,20170007)
INSERT INTO BITACORA VALUES(205,20170004)
INSERT INTO BITACORA VALUES(206,20170004)
INSERT INTO BITACORA VALUES(207,20170002)
INSERT INTO BITACORA VALUES(208,20170009)
INSERT INTO BITACORA VALUES(209,20170007)
INSERT INTO BITACORA VALUES(210,20170007)
INSERT INTO BITACORA VALUES(211,20170012)
INSERT INTO BITACORA VALUES(212,20170011)
INSERT INTO BITACORA VALUES(213,20170006)
INSERT INTO BITACORA VALUES(214,20170003)
INSERT INTO BITACORA VALUES(215,20170005)
INSERT INTO BITACORA VALUES(216,20170008)
INSERT INTO BITACORA VALUES(217,20170006)
INSERT INTO BITACORA VALUES(218,20170007)
INSERT INTO BITACORA VALUES(219,20170009)
INSERT INTO BITACORA VALUES(220,20170011)
INSERT INTO BITACORA VALUES(221,20170007)
INSERT INTO BITACORA VALUES(222,20170008)
INSERT INTO BITACORA VALUES(223,20170012)
INSERT INTO BITACORA VALUES(224,20170012)
INSERT INTO BITACORA VALUES(225,20170004)
INSERT INTO BITACORA VALUES(226,20170002)
INSERT INTO BITACORA VALUES(227,20170009)
INSERT INTO BITACORA VALUES(228,20170004)
INSERT INTO BITACORA VALUES(229,20170006)
INSERT INTO BITACORA VALUES(230,20170007)
INSERT INTO BITACORA VALUES(231,20170003)
INSERT INTO BITACORA VALUES(232,20170007)
INSERT INTO BITACORA VALUES(233,20170003)
INSERT INTO BITACORA VALUES(234,20170001)
INSERT INTO BITACORA VALUES(235,20170009)
INSERT INTO BITACORA VALUES(236,20170005)
INSERT INTO BITACORA VALUES(237,20170011)
INSERT INTO BITACORA VALUES(238,20170004)
INSERT INTO BITACORA VALUES(239,20170006)
INSERT INTO BITACORA VALUES(240,20170005)
INSERT INTO BITACORA VALUES(241,20170001)
INSERT INTO BITACORA VALUES(242,20170005)
INSERT INTO BITACORA VALUES(243,20170004)
INSERT INTO BITACORA VALUES(244,20170004)
INSERT INTO BITACORA VALUES(245,20170001)
INSERT INTO BITACORA VALUES(246,20170010)
INSERT INTO BITACORA VALUES(247,20170012)
INSERT INTO BITACORA VALUES(248,20170003)
INSERT INTO BITACORA VALUES(249,20170003)
INSERT INTO BITACORA VALUES(250,20170003)
INSERT INTO BITACORA VALUES(251,20170006)
INSERT INTO BITACORA VALUES(252,20170002)
INSERT INTO BITACORA VALUES(253,20170012)
INSERT INTO BITACORA VALUES(254,20170006)
INSERT INTO BITACORA VALUES(255,20170006)
INSERT INTO BITACORA VALUES(256,20170003)
INSERT INTO BITACORA VALUES(257,20170004)
INSERT INTO BITACORA VALUES(258,20170005)
INSERT INTO BITACORA VALUES(259,20170007)
INSERT INTO BITACORA VALUES(260,20170009)
INSERT INTO BITACORA VALUES(261,20170009)
INSERT INTO BITACORA VALUES(262,20170006)
INSERT INTO BITACORA VALUES(263,20170007)
INSERT INTO BITACORA VALUES(264,20170003)
INSERT INTO BITACORA VALUES(265,20170010)
INSERT INTO BITACORA VALUES(266,20170005)
INSERT INTO BITACORA VALUES(267,20170011)
INSERT INTO BITACORA VALUES(268,20170008)
INSERT INTO BITACORA VALUES(269,20170001)
INSERT INTO BITACORA VALUES(270,20170006)
INSERT INTO BITACORA VALUES(271,20170012)
INSERT INTO BITACORA VALUES(272,20170009)

EXEC sp_reporteSemana '20161210'

View schema
Execution time: 0,14 sec, rows selected: 19, rows affected: 358, absolute service time: 0,31 sec