Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- scripts datos
- calendario:
- USE [cubo9]
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Calendario](
- [fecha] [DATE] NOT NULL,
- [dia] AS (datepart(DAY,[fecha])),
- [mes] AS (datepart(MONTH,[fecha])),
- [mesNombre] AS (datename(MONTH,[fecha])),
- [semana] AS (datepart(week,[fecha])),
- [diaDeSemana] AS (datepart(weekday,[fecha])),
- [trimestre] AS (datepart(quarter,[fecha])),
- [año] AS (datepart(YEAR,[fecha])),
- [Style112] AS (CONVERT([CHAR](8),[fecha],(112))),
- [Style101] AS (CONVERT([CHAR](10),[fecha],(101))),
- PRIMARY KEY CLUSTERED
- (
- [fecha] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- USE [cubo9]
- GO
- DECLARE @StartDate DATE = '19900101', @NumberOfYears INT = 30;
- SET DATEFIRST 7;
- SET DATEFORMAT mdy;
- SET LANGUAGE US_ENGLISH;
- DECLARE @CutoffDate DATE = DATEADD(YEAR, @NumberOfYears, @StartDate);
- CREATE TABLE C_Fecha
- (
- [fecha] DATE PRIMARY KEY,
- [dia] AS DATEPART(DAY, [fecha]),
- [mes] AS DATEPART(MONTH, [fecha]),
- [mesNombre] AS DATENAME(MONTH, [fecha]),
- [semana] AS DATEPART(WEEK, [fecha]),
- [diaDeSemana] AS DATEPART(WEEKDAY, [fecha]),
- [trimestre] AS DATEPART(QUARTER, [fecha]),
- [año] AS DATEPART(YEAR, [fecha]),
- Style112 AS CONVERT(CHAR(8), [fecha], 112),
- Style101 AS CONVERT(CHAR(10), [fecha], 101)
- );
- INSERT C_Fecha([fecha])
- SELECT d
- FROM
- (
- SELECT d = DATEADD(DAY, rn - 1, @StartDate)
- FROM
- (
- SELECT TOP (DATEDIFF(DAY, @StartDate, @CutoffDate))
- rn = ROW_NUMBER() OVER (ORDER BY s1.[object_id])
- FROM sys.all_objects AS s1
- CROSS JOIN sys.all_objects AS s2
- -- on my system this would support > 5 million days
- ORDER BY s1.[object_id]
- ) AS x
- ) AS y;
- GO
- ==================================
- ===================================
- ==================================
- vendedor
- USE [cubo9]
- GO
- /****** Object: Table [dbo].[Vendedor] Script Date: 11/12/2019 5:24:02 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Vendedor](
- [Id_Vendedor] [INT] IDENTITY(1,1) NOT NULL,
- [Vendedor] [NCHAR](20) NULL,
- CONSTRAINT [PK_Vendedor] PRIMARY KEY CLUSTERED
- (
- [Id_Vendedor] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- SET IDENTITY_INSERT [dbo].[Vendedor] ON
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (1, N'Juan ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (2, N'Raymond Douglas ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (3, N'Charles Waters ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (4, N'Steven Cook ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (5, N'Robert Irwin ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (6, N'Uriah Solis ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (7, N'Kane Houston ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (8, N'Theodore Fernandez ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (9, N'Brandon Carey ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (10, N'Hall Carney ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (11, N'Brennan Avery ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (12, N'Martin Williams ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (13, N'Moses Goff ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (14, N'Clark Dorsey ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (15, N'Stephen Hardin ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (16, N'Dominic Buchanan ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (17, N'Trevor Silva ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (18, N'Kadeem Torres ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (19, N'Evan Hamilton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (20, N'Hunter Weber ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (21, N'Lucius Mccarty ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (22, N'Jameson Sims ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (23, N'Vincent Hardy ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (24, N'Tanek Blevins ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (25, N'Gannon Kramer ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (26, N'Cole Weiss ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (27, N'Camden Horn ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (28, N'Carlos Shaw ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (29, N'Sebastian Harvey ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (30, N'Brenden Chase ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (31, N'Prescott Gardner ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (32, N'Wade Burch ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (33, N'Samuel Jimenez ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (34, N'Kaseem Aguilar ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (35, N'Brady Stanley ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (36, N'Neil Cain ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (37, N'Omar Miranda ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (38, N'Caldwell Shepard ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (39, N'Joel Boone ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (40, N'Basil Bowers ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (41, N'Asher Stewart ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (42, N'Plato May ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (43, N'Carson Hopkins ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (44, N'Alan Hensley ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (45, N'Hall Horn ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (46, N'Noble Moreno ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (47, N'Henry William ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (48, N'Jordan Melton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (49, N'Chancellor Hopkins ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (50, N'Ian Delaney ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (51, N'Wade Bender ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (52, N'Colin Cooke ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (53, N'Cadman Roth ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (54, N'Tucker Kelly ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (55, N'Silas Moreno ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (56, N'Cole Joseph ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (57, N'Ahmed Anthony ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (58, N'Upton Hanson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (59, N'Garrett Green ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (60, N'Xanthus Becker ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (61, N'Devin Daniels ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (62, N'Ciaran Yates ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (63, N'Connor Dickerson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (64, N'Simon Madden ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (65, N'Nash Sheppard ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (66, N'Steven Chen ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (67, N'Declan Mueller ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (68, N'Chester Stout ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (69, N'Chadwick Lott ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (70, N'Hashim Mcdowell ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (71, N'Scott Aguilar ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (72, N'Alec Simon ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (73, N'Chaim Hopper ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (74, N'Kermit Savage ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (75, N'Hayden Copeland ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (76, N'Cade Baldwin ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (77, N'Buckminster Cooke ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (78, N'Chester Holland ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (79, N'Amos Farrell ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (80, N'Xenos Mcgee ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (81, N'Luke Lewis ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (82, N'Thaddeus Spears ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (83, N'Martin Horton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (84, N'Byron Sexton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (85, N'Quinlan Mcintyre ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (86, N'Giacomo Mcdonald ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (87, N'Howard Hensley ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (88, N'Joshua Snider ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (89, N'Len Hurst ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (90, N'Ishmael Ferrell ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (91, N'Gil Lindsay ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (92, N'Solomon Mcclain ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (93, N'Uriah Hatfield ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (94, N'Luke Erickson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (95, N'Curran Holt ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (96, N'Clark Becker ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (97, N'Price Justice ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (98, N'Donovan Conner ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (99, N'Hammett Dominguez ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (100, N'Emerson Justice ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (101, N'Christian Hale ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (102, N'Castor Lowe ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (103, N'Grady Glover ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (104, N'Finn Burt ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (105, N'Julian Serrano ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (106, N'Neville Dotson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (107, N'Orlando Jackson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (108, N'Blake Townsend ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (109, N'Kyle Casey ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (110, N'Boris Bright ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (111, N'Nathaniel Vinson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (112, N'Igor Moran ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (113, N'Ali Rhodes ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (114, N'Murphy Best ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (115, N'Kasimir Hinton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (116, N'Odysseus Bush ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (117, N'Salvador Ball ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (118, N'Hoyt Stephenson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (119, N'Josiah Stephens ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (120, N'Craig Salazar ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (121, N'Wylie Turner ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (122, N'Timon Franco ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (123, N'Ivan Howe ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (124, N'Drake Sparks ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (125, N'Jacob Hurst ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (126, N'Jakeem Tate ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (127, N'Fitzgerald Whitaker ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (128, N'Malcolm Bolton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (129, N'Omar Dixon ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (130, N'Acton Flores ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (131, N'Ignatius Watson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (132, N'Armando Holt ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (133, N'Carlos Sweet ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (134, N'Prescott Jennings ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (135, N'Thomas Yang ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (136, N'Cade Mcconnell ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (137, N'Zachary Watson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (138, N'Nash Cannon ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (139, N'Walker Gay ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (140, N'Vincent Tran ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (141, N'Garrett Grimes ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (142, N'Nehru Woods ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (143, N'Thane Goff ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (144, N'Adrian Humphrey ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (145, N'Denton Jordan ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (146, N'Oren Daugherty ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (147, N'Kasimir Avery ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (148, N'Nathan Berg ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (149, N'Jakeem Wynn ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (150, N'Magee Ball ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (151, N'Beau Callahan ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (152, N'Timothy Ramsey ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (153, N'Lane Mccarthy ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (154, N'Craig Sandoval ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (155, N'Timothy Rowland ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (156, N'Griffin Meyers ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (157, N'Chadwick Hickman ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (158, N'Demetrius Russo ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (159, N'Colorado Haley ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (160, N'Forrest Morton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (161, N'Chadwick Reid ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (162, N'Preston Miranda ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (163, N'Chester Shaffer ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (164, N'Gabriel Foley ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (165, N'Dominic Charles ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (166, N'Henry Simpson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (167, N'Chaney Jacobson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (168, N'Jackson Irwin ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (169, N'Nathaniel Rivers ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (170, N'Stephen Walsh ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (171, N'Kasper Parrish ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (172, N'Drake Flynn ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (173, N'Evan Manning ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (174, N'Lyle Kent ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (175, N'Odysseus Miranda ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (176, N'Kaseem Turner ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (177, N'Vincent Jefferson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (178, N'Brian Stevenson ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (179, N'Ross Lowe ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (180, N'Rafael Diaz ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (181, N'Yoshio Shannon ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (182, N'Kibo Wagner ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (183, N'Chaney Lott ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (184, N'Dieter Walton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (185, N'Ferris Holmes ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (186, N'Tiger Osborn ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (187, N'Lane Boyer ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (188, N'Lamar Obrien ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (189, N'Warren Lara ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (190, N'Fulton Chambers ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (191, N'Ross Duke ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (192, N'Gannon Brewer ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (193, N'Akeem Fitzpatrick ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (194, N'Thomas Espinoza ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (195, N'Orlando Browning ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (196, N'Hayes Orr ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (197, N'Fuller Curtis ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (198, N'Melvin Stokes ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (199, N'Rudyard Middleton ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (200, N'Hakeem Nichols ')
- GO
- INSERT [dbo].[Vendedor] ([Id_Vendedor], [Vendedor]) VALUES (201, N'Rahim Farley ')
- GO
- SET IDENTITY_INSERT [dbo].[Vendedor] OFF
- GO
- ==================================
- ===================================
- ==================================
- cliente
- USE [cubo9]
- GO
- /****** Object: Table [dbo].[Cliente] Script Date: 11/12/2019 5:25:47 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Cliente](
- [Id_Cliente] [INT] IDENTITY(1,1) NOT NULL,
- [Cliente] [NCHAR](50) NULL,
- [Segmento] [INT] NULL,
- [Telefono] [NCHAR](50) NULL,
- [Ciudad] [NCHAR](50) NULL,
- [Pais] [NCHAR](50) NULL,
- CONSTRAINT [PK_Cliente] PRIMARY KEY CLUSTERED
- (
- [Id_Cliente] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- SET IDENTITY_INSERT [dbo].[Cliente] ON
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (1, N'Tyler Browning ', 2, N'(839) 441-4339 ', N'Mejillones ', N'Kiribati ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (2, N'Vincent Duffy ', 2, N'(336) 815-1278 ', N'Campbelltown ', N'Costa Rica ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (3, N'Nasim Graves ', 1, N'(506) 482-8195 ', N'Vremde ', N'Chad ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (4, N'Perry Norman ', 2, N'(974) 245-2972 ', N'Waterbury ', N'Andorra ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (5, N'Jasper Horn ', 1, N'(651) 386-0624 ', N'Alessandria ', N'Greece ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (6, N'Igor Walter ', 1, N'(443) 780-7275 ', N'Frascati ', N'Malaysia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (7, N'Jelani Carlson ', 1, N'(449) 526-4042 ', N'North Battleford ', N'Morocco ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (8, N'Hector Bullock ', 1, N'(693) 499-4742 ', N'Diyarbakir ', N'Burundi ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (9, N'Neil Norris ', 1, N'(290) 922-4840 ', N'Parla ', N'Martinique ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (10, N'Oren Elliott ', 1, N'(738) 142-5196 ', N'Tofield ', N'Uzbekistan ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (11, N'Baker Sanchez ', 2, N'(967) 996-1551 ', N'Lichfield ', N'Mexico ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (12, N'Oscar Keith ', 1, N'(322) 158-4607 ', N'Boise ', N'Svalbard and Jan Mayen Islands ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (13, N'Bernard Morse ', 1, N'(285) 289-2003 ', N'Telfs ', N'Panama ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (14, N'Armand Lara ', 2, N'(719) 734-2649 ', N'Zhob ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (15, N'Hall Murray ', 1, N'(932) 435-0761 ', N'Bloomington ', N'Antigua and Barbuda ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (16, N'Holmes Fernandez ', 2, N'(189) 237-0934 ', N'Burns Lake ', N'French Guiana ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (17, N'Vance Moore ', 2, N'(756) 501-6099 ', N'Sint-Martens-Lennik ', N'Wallis and Futuna ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (18, N'Ulysses Conrad ', 2, N'(643) 679-3564 ', N'Qu?bec City ', N'Norway ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (19, N'Darius Fitzpatrick ', 1, N'(168) 664-1806 ', N'Jasper ', N'Yemen ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (20, N'Jermaine Gates ', 1, N'(939) 691-8158 ', N'San Gregorio nelle Alpi ', N'Jersey ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (21, N'Paki Tanner ', 2, N'(103) 350-6937 ', N'Bicester ', N'Svalbard and Jan Mayen Islands ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (22, N'Jack Stewart ', 2, N'(416) 623-1153 ', N'Salem ', N'Tuvalu ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (23, N'Colin Sykes ', 1, N'(508) 826-1485 ', N'Surendranagar ', N'Malawi ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (24, N'Travis Robinson ', 1, N'(129) 365-3740 ', N'Notre-Dame-du-Nord ', N'Cyprus ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (25, N'Kermit Wyatt ', 2, N'(747) 395-4077 ', N'Neder-Over-Heembeek ', N'Burkina Faso ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (26, N'Amery Norman ', 1, N'(113) 450-2562 ', N'Wevelgem ', N'Vanuatu ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (27, N'Brian Wilder ', 2, N'(286) 172-1580 ', N'Quarona ', N'Syria ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (28, N'Elvis Marshall ', 1, N'(196) 973-6484 ', N'Kingston-on-Thames ', N'Niger ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (29, N'Conan Briggs ', 2, N'(312) 997-2039 ', N'Meldert ', N'Armenia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (30, N'Reed Cooke ', 2, N'(382) 289-9020 ', N'Spiere-Helkijn ', N'Guadeloupe ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (31, N'Kermit Wilcox ', 2, N'(221) 427-8517 ', N'San Joaquín ', N'New Caledonia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (32, N'Wade Mccormick ', 1, N'(297) 293-4991 ', N'Etobicoke ', N'Oman ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (33, N'Dean Owen ', 1, N'(508) 765-6705 ', N'Saint-L?onard ', N'Guinea-Bissau ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (34, N'Harrison Walker ', 1, N'(897) 632-2883 ', N'Strongoli ', N'Djibouti ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (35, N'Adam Horne ', 2, N'(620) 801-9447 ', N'Yogyakarta ', N'Tajikistan ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (36, N'Steel Goff ', 2, N'(338) 572-3075 ', N'Kakisa ', N'Congo (Brazzaville) ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (37, N'Bert Tran ', 2, N'(935) 716-1144 ', N'Aligarh ', N'Germany ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (38, N'Jerry Levine ', 2, N'(489) 810-2479 ', N'Swindon ', N'Andorra ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (39, N'Byron Wells ', 1, N'(412) 149-3389 ', N'Primavera ', N'Luxembourg ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (40, N'Silas Davidson ', 2, N'(492) 672-8583 ', N'Livo ', N'Cayman Islands ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (41, N'Jerry Mejia ', 1, N'(989) 399-9179 ', N'Chelsea ', N'Bermuda ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (42, N'Vernon Golden ', 1, N'(643) 153-1459 ', N'Gyeongju ', N'Syria ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (43, N'Jared Riddle ', 1, N'(401) 628-7648 ', N'Caucaia ', N'Belarus ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (44, N'Wallace Hatfield ', 2, N'(636) 321-5375 ', N'Quinte West ', N'Guam ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (45, N'Abbot Wyatt ', 2, N'(879) 578-4984 ', N'Riesa ', N'Argentina ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (46, N'Prescott Davenport ', 1, N'(352) 775-4413 ', N'Lafayette ', N'Philippines ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (47, N'Ferris Herrera ', 1, N'(278) 617-6290 ', N'Alexandra ', N'Sierra Leone ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (48, N'Aristotle Anthony ', 1, N'(781) 358-1209 ', N'Vrasene ', N'French Guiana ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (49, N'Hammett Trujillo ', 1, N'(714) 251-2006 ', N'Hillsboro ', N'Ireland ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (50, N'Erich Herrera ', 1, N'(910) 364-8437 ', N'Des Moines ', N'Peru ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (51, N'Ronan Wheeler ', 2, N'(105) 222-2525 ', N'Kingston ', N'Aruba ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (52, N'Aquila Ramos ', 2, N'(870) 260-1513 ', N'Isola di Capo Rizzuto ', N'Puerto Rico ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (53, N'Judah Walsh ', 1, N'(260) 237-6985 ', N'Rocca Massima ', N'Malaysia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (54, N'Colt Jennings ', 1, N'(281) 389-9630 ', N'Sennariolo ', N'Kuwait ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (55, N'Murphy Rowe ', 1, N'(319) 914-6041 ', N'Rocca San Felice ', N'Estonia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (56, N'Warren Morse ', 2, N'(223) 611-8923 ', N'Severodvinsk ', N'Seychelles ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (57, N'Lee Barnett ', 2, N'(653) 750-9266 ', N'Açailândia ', N'Somalia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (58, N'Jeremy Medina ', 2, N'(240) 277-7451 ', N'Beringen ', N'Gabon ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (59, N'Basil Roberts ', 1, N'(931) 838-2810 ', N'Lüneburg ', N'Greenland ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (60, N'Lawrence Conner ', 2, N'(115) 797-2428 ', N'Orta San Giulio ', N'Equatorial Guinea ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (61, N'Jelani Bullock ', 2, N'(187) 595-0920 ', N'Toltén ', N'Togo ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (62, N'Hasad Mcclure ', 2, N'(371) 246-6822 ', N'Hondelange ', N'Burundi ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (63, N'Phillip Matthews ', 2, N'(830) 361-1833 ', N'Reading ', N'Bermuda ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (64, N'Kane Burks ', 1, N'(804) 202-7915 ', N'Talca ', N'Latvia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (65, N'Nigel Spencer ', 2, N'(606) 105-5377 ', N'Buin ', N'Isle of Man ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (66, N'Solomon Brock ', 1, N'(655) 119-0785 ', N'Tufo ', N'Lesotho ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (67, N'Boris Baird ', 2, N'(580) 233-7201 ', N'Facatativá ', N'Ecuador ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (68, N'Branden Mccormick ', 1, N'(681) 989-8958 ', N'Kashira ', N'Mali ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (69, N'Reese Sears ', 1, N'(640) 882-6361 ', N'College ', N'Comoros ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (70, N'Nero Puckett ', 1, N'(658) 934-2000 ', N'Swabi ', N'Kiribati ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (71, N'Drew Meyer ', 1, N'(145) 666-6291 ', N'San Mauro Cilento ', N'Saint Pierre and Miquelon ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (72, N'Baker Robbins ', 1, N'(163) 445-2838 ', N'South Bend ', N'Isle of Man ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (73, N'Barry Anderson ', 1, N'(634) 339-6297 ', N'Cercepiccola ', N'Romania ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (74, N'Connor Dawson ', 1, N'(491) 231-2388 ', N'Cupar ', N'Saudi Arabia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (75, N'Ezekiel King ', 1, N'(528) 340-4234 ', N'Eigenbrakel ', N'Honduras ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (76, N'Micah Buck ', 1, N'(451) 924-5381 ', N'Saint-L?onard ', N'Guadeloupe ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (77, N'Tyrone Yates ', 2, N'(282) 825-5027 ', N'Fort St. John ', N'Ukraine ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (78, N'Phillip Cain ', 1, N'(146) 688-9867 ', N'Bayswater ', N'Poland ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (79, N'Finn Stark ', 1, N'(518) 310-6987 ', N'Greenlaw ', N'Belgium ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (80, N'Lawrence Wiggins ', 2, N'(550) 892-6054 ', N'Bochum ', N'Nigeria ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (81, N'Bradley Hensley ', 1, N'(191) 661-5343 ', N'Velsk ', N'Papua New Guinea ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (82, N'Tyrone Deleon ', 2, N'(146) 145-6511 ', N'Eigenbrakel ', N'Bonaire, Sint Eustatius and Saba ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (83, N'Ivor Delgado ', 2, N'(611) 156-5738 ', N'Brussegem ', N'Morocco ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (84, N'Carl Stanton ', 1, N'(831) 952-7598 ', N'Nus ', N'Russian Federation ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (85, N'Lucian Berry ', 2, N'(142) 569-0113 ', N'Castello Tesino ', N'Turks and Caicos Islands ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (86, N'Drake Oneill ', 1, N'(287) 272-9336 ', N'Juneau ', N'Fiji ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (87, N'Noble Griffith ', 2, N'(287) 635-8308 ', N'Lloydminster ', N'Andorra ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (88, N'Perry Morales ', 1, N'(296) 963-4209 ', N'San Rafael ', N'Curaçao ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (89, N'Ryan Morales ', 1, N'(585) 650-6463 ', N'Marchtrenk ', N'Croatia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (90, N'Malcolm Blankenship ', 2, N'(538) 471-0069 ', N'Borgone Susa ', N'Yemen ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (91, N'Branden Finley ', 2, N'(830) 968-5999 ', N'Kampenhout ', N'Turkey ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (92, N'Calvin Patel ', 1, N'(512) 781-5695 ', N'Ipiales ', N'Taiwan ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (93, N'Hakeem Randall ', 2, N'(998) 234-7929 ', N'Glimes ', N'Zimbabwe ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (94, N'Jacob Winters ', 1, N'(293) 823-6837 ', N'Telford ', N'Lesotho ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (95, N'Isaiah Bryan ', 2, N'(606) 975-4222 ', N'Jamshedpur ', N'Gibraltar ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (96, N'Channing Schmidt ', 1, N'(295) 866-0101 ', N'Rivière-du-Loup ', N'Timor-Leste ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (97, N'Vance Miller ', 1, N'(939) 907-9323 ', N'Fort Saskatchewan ', N'Pakistan ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (98, N'Blake Hartman ', 1, N'(663) 562-3131 ', N'Lanark ', N'Peru ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (99, N'Ryder Anthony ', 1, N'(548) 476-3019 ', N'Salerno ', N'Mongolia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (100, N'Brendan Contreras ', 2, N'(176) 478-5461 ', N'San Cristóbal de las Casas ', N'Haiti ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (101, N'Lyle Pickett ', 2, N'(563) 480-3432 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (102, N'Levi Tillman ', 1, N'(669) 117-0291 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (103, N'Curran Barber ', 1, N'(113) 182-3160 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (104, N'Emery Preston ', 1, N'(356) 964-5588 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (105, N'Xander Cox ', 2, N'(445) 524-4934 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (106, N'Lamar Graves ', 2, N'(946) 891-7788 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (107, N'Kevin Brooks ', 2, N'(726) 198-3328 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (108, N'Kadeem Ruiz ', 2, N'(596) 100-5653 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (109, N'Benedict Gibson ', 1, N'(186) 782-5423 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (110, N'Kermit Moran ', 1, N'(789) 580-4184 ', N'Temuco ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (111, N'Robert Macdonald ', 1, N'(173) 128-6660 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (112, N'Jesse Farrell ', 1, N'(815) 674-3598 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (113, N'Brennan Norton ', 2, N'(937) 839-2149 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (114, N'Jelani Church ', 2, N'(376) 339-8088 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (115, N'Chancellor Oneil ', 2, N'(118) 476-0014 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (116, N'Allistair Robertson ', 2, N'(700) 413-0143 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (117, N'Malcolm Leon ', 1, N'(610) 894-0118 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (118, N'Kieran Wooten ', 2, N'(312) 482-3382 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (119, N'Macaulay Cummings ', 1, N'(158) 797-8495 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (120, N'Tyler Cook ', 2, N'(990) 250-0748 ', N'Santiago ', N'Chile ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (121, N'Gage Schultz ', 2, N'(668) 439-8035 ', N'Xalapa ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (122, N'Axel Shepherd ', 2, N'(944) 231-7524 ', N'Labrecque ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (123, N'Emery Avery ', 1, N'(148) 218-0179 ', N'Villafalletto ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (124, N'Arden Shaffer ', 1, N'(682) 403-1942 ', N'Hathras ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (125, N'Honorato Mccarty ', 2, N'(475) 266-1218 ', N'Lac-Serent ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (126, N'Jesse Barker ', 2, N'(361) 438-3069 ', N'Bontang ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (127, N'Hop Peck ', 1, N'(359) 282-0026 ', N'Perquenco ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (128, N'Curran Figueroa ', 2, N'(459) 292-7816 ', N'Lancaster ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (129, N'Odysseus Holcomb ', 2, N'(940) 106-3268 ', N'Hoofddorp ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (130, N'Brody Charles ', 2, N'(601) 769-5696 ', N'Bearberry ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (131, N'Macaulay Wheeler ', 2, N'(684) 227-5884 ', N'Acuña ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (132, N'George Leach ', 2, N'(863) 256-0905 ', N'Knokke ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (133, N'Nero Clemons ', 1, N'(186) 886-3333 ', N'Moerkerke ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (134, N'Ali Powers ', 1, N'(971) 328-0716 ', N'Codognè ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (135, N'Odysseus Mullins ', 2, N'(163) 446-8598 ', N'Montefiore dell''Aso ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (136, N'Amal Howell ', 2, N'(749) 242-9377 ', N'Bhind ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (137, N'Ross Meyers ', 1, N'(988) 770-7864 ', N'Gap ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (138, N'Richard Maxwell ', 1, N'(626) 247-5384 ', N'Gumi ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (139, N'Graiden Kirk ', 1, N'(158) 621-7215 ', N'Lafayette ', N'Colombia ')
- GO
- INSERT [dbo].[Cliente] ([Id_Cliente], [Cliente], [Segmento], [Telefono], [Ciudad], [Pais]) VALUES (140, N'Yuli Wallace ', 2, N'(325) 265-9755 ', N'Houston ', N'Colombia ')
- GO
- SET IDENTITY_INSERT [dbo].[Cliente] OFF
- GO
- ==================================
- ===================================
- ==================================
- tabla ventas:
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Ventas](
- [Id_Factura] [INT] IDENTITY(1,1) NOT NULL,
- [Fecha_Factura] [DATE] NOT NULL,
- [Id_Cliente] [INT] NOT NULL,
- [Id_Vendedor] [INT] NOT NULL,
- [Monto_Simple] [INT] NOT NULL,
- [Impuesto] [INT] NOT NULL,
- [Monto_Facturado] [INT] NOT NULL,
- CONSTRAINT [PK_Ventas] PRIMARY KEY CLUSTERED
- (
- [Id_Factura] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[Ventas] WITH CHECK ADD CONSTRAINT [FK_Ventas_Cliente] FOREIGN KEY([Id_Cliente])
- REFERENCES [dbo].[Cliente] ([Id_Cliente])
- GO
- ALTER TABLE [dbo].[Ventas] CHECK CONSTRAINT [FK_Ventas_Cliente]
- GO
- ALTER TABLE [dbo].[Ventas] WITH CHECK ADD CONSTRAINT [FK_Ventas_Fecha] FOREIGN KEY([Fecha_Factura])
- REFERENCES [dbo].[Calendario] ([fecha])
- GO
- ALTER TABLE [dbo].[Ventas] CHECK CONSTRAINT [FK_Ventas_Fecha]
- GO
- ALTER TABLE [dbo].[Ventas] WITH CHECK ADD CONSTRAINT [FK_Ventas_Vendedor] FOREIGN KEY([Id_Vendedor])
- REFERENCES [dbo].[Vendedor] ([Id_Vendedor])
- GO
- ALTER TABLE [dbo].[Ventas] CHECK CONSTRAINT [FK_Ventas_Vendedor]
- GO
- USE [cubo9]
- GO
- INSERT INTO [dbo].[Ventas]
- ([Fecha_Factura],
- [Id_Cliente],
- [Id_Vendedor],
- [Monto_Simple],
- [Impuesto],
- [Monto_Facturado])
- VALUES
- ('21/08/2014',77,78,18300325,779636,86692475),('25/10/2008',108,28,76833962,364343,50216227),('23/03/2019',97,49,82844266,749979,10730565),('02/11/2007',133,140,25352486,328608,96139215),('28/07/1991',117,153,34904326,441727,60385007),('10/08/2007',108,165,47334423,284866,70466928),('24/12/2013',27,140,96704115,372486,52524294),('29/03/2012',89,30,29256970,651095,90842043),('03/06/1991',127,22,9805371,514067,28152612),('26/04/1991',31,68,36215442,602162,98391999),('15/07/2016',79,171,91459461,406947,8348919),('27/11/1993',8,87,27733986,317631,42413138),('25/10/2012',117,162,25268524,507920,33709844),('27/09/2014',71,36,51090730,943619,43111296),('22/05/2019',28,39,87505986,636168,39274854),('08/07/2019',44,22,92240776,188979,54699876),('25/08/2013',65,50,3407598,971686,96770275),('08/09/2010',21,115,6671688,533015,1274953),('11/12/2008',9,143,55678107,369747,29999983),('25/05/1994',7,156,51027115,697241,44763889),('21/08/2019',98,189,18128120,403256,60168449),('11/03/1998',35,140,22567285,189872,65191528),('21/06/2008',34,191,78079437,513457,34087607),('21/06/1995',61,29,6158043,492256,44369900),('12/04/2016',1,49,18244746,829799,6456976),('27/06/2002',5,125,75091635,865967,41442349),('06/02/1999',10,91,23704445,524596,34235494),('14/12/2011',29,55,45701111,203088,20279732),('20/05/2017',15,145,55040642,786547,68969200),('26/04/2015',48,84,40476683,475230,39163893),('30/12/2009',38,123,71004586,451331,21931670),('08/10/2010',81,101,28899895,567087,90521981),('17/02/2019',85,127,37176996,208870,34964427),('23/04/1995',132,19,4768115,899992,31222514),('23/10/2008',57,164,44524519,976395,53546416),('01/04/2003',90,47,64578424,867539,66732680),('10/12/1997',72,25,23151479,130024,29292445),('22/01/1999',82,71,23243194,913284,59533624),('20/04/2006',38,113,24660973,651065,24461988),('27/06/2012',21,135,85621448,303070,84777625),('10/06/2007',39,148,46188224,811798,93803139),('21/01/2008',77,78,79623413,633595,27681544),('05/11/1998',28,123,52770743,926429,8919387),('12/04/2002',125,191,2451606,172554,11623189),('18/11/2001',66,171,4879338,896062,40926401),('01/08/2017',119,92,9249909,182392,87731195),('11/09/2016',17,197,48075063,912851,70388895),('02/03/2018',133,10,45775877,111203,3792004),('30/05/2012',22,90,24150697,959145,88172198),('20/06/1997',23,116,29837981,731252,65124075),('13/01/1991',30,137,22314600,193004,56785224),('17/07/2016',80,96,75563172,617724,54321562),('06/04/2013',137,137,91687844,693927,13364599),('01/09/1991',109,44,93791967,303256,97908627),('12/02/2003',45,182,19516241,722579,96308458),('10/01/2004',11,4,59037753,807488,4496081),('12/11/2013',42,74,63731219,340098,78056267),('30/03/2012',33,177,18012968,974739,13569929),('21/09/2012',121,33,36752262,171824,70627854),('22/05/1997',115,151,36680643,789469,22352383),('17/12/2008',9,1,95684005,247278,70472965),('02/07/1996',36,96,54346689,650228,19859616),('07/05/2011',117,150,79424649,927378,61676552),('27/05/2019',119,44,53823507,658314,27566182),('16/06/1995',75,46,50361941,634223,3836627),('09/04/2006',118,164,82389402,653171,19589537),('26/02/2016',87,150,79678515,407957,65326102),('06/01/1995',95,194,16200579,577354,59724015),('06/03/2006',85,115,2711847,152802,84823252),('12/10/1996',6,96,13240078,936467,85424243),('22/03/2016',26,164,57341120,157679,22608929),('15/12/1995',140,175,29965026,577771,1268324),('21/12/1998',53,19,36716747,421509,71610500),('22/11/2008',71,9,29365539,609544,88230906),('14/12/2012',103,109,64228980,981052,76132086),('24/11/2009',83,195,64073198,430977,62232560),('27/04/2011',68,160,45140908,679005,64190981),('04/06/1995',77,181,29255750,772782,5336919),('24/11/2011',67,139,24090252,503698,17298335),('31/08/2014',41,183,33506443,394364,43226350),('17/08/2011',26,123,75231449,172062,32971820),('10/10/2000',105,145,86376636,660025,36721646),('14/05/2000',20,155,10238690,355022,85856803),('20/11/2015',106,81,74223652,207778,72640360),('14/11/2017',122,4,50924610,399758,85241306),('27/03/2000',87,13,92849628,633075,4116209),('24/02/2012',66,50,10881645,209249,330266),('17/08/1991',2,200,62571801,840543,22080043),('29/04/2005',18,184,40195900,292119,70685429),('09/09/2006',47,153,56117658,471332,8311910),('18/12/2006',10,54,98941278,870569,87634642),('08/08/1996',94,13,31608148,596162,20341166),('19/07/1992',2,16,43167583,971790,26035679),('21/08/2016',112,36,55413790,102041,39286740),('01/03/2002',111,98,612086,129808,80711714),('24/02/2004',88,40,42487624,339813,39801900),('01/10/2005',27,65,3469285,436316,33806289),('13/10/1992',100,154,94513574,578744,17390626),('30/07/2000',131,11,50229430,985933,76872624),('22/06/2000',34,8,59782937,944223,57308634)
- ,('09/04/2003',42,49,97266572,478243,29301244),('20/12/2018',127,31,98884256,376153,13502047),('03/04/1993',70,122,22282212,989621,63671508),('28/12/2006',85,1,27993523,606657,83000101),('06/04/2014',140,51,64890693,787407,11146682),('30/10/2011',3,185,80047695,979367,28541452),('24/05/2006',137,96,91269503,967112,85371858),('13/03/1994',60,156,42197404,772462,16347500),('06/01/2001',132,142,59550406,799671,83138777),('16/12/2003',110,12,22219667,488235,38904428),('23/02/2019',67,71,85476977,119041,87787903),('09/02/2001',127,92,62355990,710493,27868819),('28/10/1996',134,45,69714755,809258,80620854),('25/06/2001',124,72,41446106,545189,79029268),('28/09/1992',123,166,74989182,483727,25633830),('25/04/1994',55,45,25292906,536810,68737459),('06/01/2009',57,109,26486639,369899,78333437),('24/06/2000',139,95,70625038,639785,35847666),('05/07/2009',92,106,7438205,421282,29811221),('23/12/2019',131,184,29467764,237365,45258490),('28/03/1996',136,107,30789622,438966,62209922),('04/07/2018',90,12,27994288,278592,38949395),('28/08/2005',50,29,38612333,517645,12806378),('28/12/2012',120,127,20840523,116317,52672072),('27/07/2004',6,73,75160127,162452,51830339),('26/10/2004',12,7,13597965,799176,90668724),('15/03/2007',47,147,23522844,893047,77813249),('04/01/1997',17,30,86817280,883883,24952913),('07/12/1992',100,102,14982225,205642,37000817),('27/10/2000',104,136,84468632,309286,50595482),('30/01/1995',64,47,36621109,761157,55445678),('03/01/1994',66,192,47618543,686326,78618516),('14/03/1997',10,2,65277109,946422,31591402),('05/12/1992',124,170,17068518,422798,55071102),('30/12/2011',38,155,25539867,824069,31505032),('11/10/2008',107,130,11039974,190213,25529845),('06/02/1999',124,36,33319103,785402,49965274),('11/02/2007',68,68,94588991,468927,43962247),('14/02/1999',42,73,11720097,141732,16572606),('06/06/2000',39,111,19979646,380744,78153013),('11/06/2009',78,8,25444380,662689,83150569),('24/12/2008',99,165,33337357,454600,74868120),('23/09/2001',45,68,72844677,321645,32120214),('21/04/2002',70,34,31170283,982997,2445779),('21/02/2005',93,183,66762328,245882,75053299),('16/03/2002',21,11,41973546,724325,2010880),('28/11/2018',61,187,43359303,565742,95409547),('20/05/1999',57,97,82168015,382078,47700257),('28/01/1993',40,191,35810364,864186,92561305),('12/06/2010',118,153,51491894,981258,41350313),('28/04/2002',112,43,98916494,247355,5055421),('15/07/2006',109,7,56526183,705620,36245617),('24/06/1993',1,198,11466493,160400,18920484),('02/10/2017',19,87,66352021,751959,15908656),('31/03/1996',68,192,63776007,845145,17555181),('27/04/1997',8,10,40363939,627693,23850118),('19/01/2008',134,124,1036263,498378,18087528),('12/03/1991',19,183,95926268,572503,7743058),('08/04/2012',26,41,86074613,861917,8925528),('15/02/2005',137,198,42925559,311472,72665417),('17/02/2016',24,172,43453587,899049,50684875),('18/03/1995',56,100,41827418,225645,7818123),('08/01/2007',13,89,77836218,461265,75273452),('28/11/2002',56,199,19720689,903934,90068057),('13/04/2013',28,41,77297636,832473,33315150),('08/01/1991',121,79,520960,928761,50641770),('07/08/2014',74,15,46699064,645116,31074709),('26/09/2006',11,137,64448641,504071,72833904),('10/03/2017',110,141,10981402,362368,39775009),('03/02/2004',94,111,64908536,356553,75814284),('26/08/1999',104,159,78726214,240375,94869307),('15/02/1996',123,114,87937779,835103,52224983),('24/06/1994',124,21,41680697,610573,29733626),('14/06/2006',28,97,51015196,989453,65468467),('01/07/2006',42,85,8677250,384509,2096903),('07/06/2014',95,103,2276166,334716,93645373),('03/10/2017',63,8,33931566,871040,69905746),('15/12/1995',120,98,80105716,363207,85858482),('14/12/1999',79,136,76939433,173329,69770745),('20/04/2004',124,96,73357238,245843,57455893),('29/06/1993',134,71,33150786,493213,94958008),('05/04/2010',140,83,30456529,657508,77865463),('13/03/2004',88,55,83263701,291933,72342235),('19/11/1993',79,168,17344303,926344,12348821),('28/10/2007',80,86,52140340,714843,77465096),('29/09/1995',52,73,38307273,312810,97122432),('09/01/2015',3,77,91984500,596856,71881983),('02/02/1998',37,151,39599242,286252,81429753),('26/11/2001',105,51,64915420,366507,15114861),('30/06/2008',80,5,5562246,954625,98391600),('23/10/2005',109,168,22298006,333879,10852102),('24/06/1994',138,55,87328448,476827,42423665),('22/11/2013',131,179,22334575,471815,94069892),('28/08/1995',14,108,64596341,188015,53249183),('24/07/2003',66,1,21213829,724731,81198347),('23/09/1998',112,15,86668535,303286,54883361),('20/01/2015',116,21,79850133,572020,88312335),('12/01/2004',17,166,90841259,339440,79135808),('21/12/2017',97,101,56456084,262489,50516975),('20/08/1996',49,27,48321990,694780,57429852)
- ,('13/08/1997',90,199,80555700,448158,6576807),('26/01/2004',3,166,18149004,160734,81260066),('26/10/1994',139,20,49109509,924082,72520076),('10/08/1999',131,44,62167158,107344,68614490),('12/11/1992',50,5,22829345,365557,97998945),('02/10/1991',135,12,26999839,816903,71284781),('20/01/1998',69,19,11604374,898124,89038245),('29/12/2008',32,77,17930724,504035,5115317),('31/12/1994',111,182,82102061,928383,3310674),('23/10/2006',48,15,91363530,927322,59639705),('19/03/2000',104,163,20653534,828829,35247191),('16/10/2018',9,24,51918273,490939,34001136),('13/09/1999',9,147,98873099,190634,30953781),('02/03/2010',133,73,43244465,780465,35467124),('29/11/2015',101,198,39677267,707215,16474786),('29/09/1993',27,155,23559175,958107,66056217),('07/10/2012',25,181,55327281,558134,37969497),('30/01/2007',1,175,36683148,259213,89034132),('12/05/2012',110,121,15571318,135821,98270265),('01/02/1999',87,2,58702104,198838,91479498),('02/09/1994',89,14,18657199,820558,55657134),('14/09/2011',110,172,25389290,571413,13773159),('13/04/2003',63,115,42697659,657051,75145883),('16/09/2001',113,3,18035958,166714,19402381),('06/09/2002',115,53,32435498,477416,85256272),('30/12/2018',63,174,9816733,241552,74986997),('29/12/1997',45,131,84690702,208299,98671059),('07/02/2017',39,188,82152214,808218,39663937),('03/04/2012',24,197,68953464,425310,77689345),('19/10/2000',28,40,58119308,865338,77035483),('22/07/2015',41,73,49392563,823027,29213784),('18/01/2009',102,187,59209018,568314,96353635),('23/02/2010',39,149,77010013,594717,20993375),('28/09/2017',95,157,30737861,985689,89718216),('22/11/1996',25,187,32861840,868132,39337323),('16/04/2017',52,112,27951833,721874,19816564),('04/12/2010',9,98,64226774,895557,48838949),('20/10/2006',45,6,87877927,101549,97806593),('16/03/2006',52,108,46439030,281300,23987136),('13/09/2015',1,53,14040984,622532,13181508),('08/10/1994',49,176,24395357,974712,71457667),('21/05/2005',113,139,63913041,252608,10818269),('18/02/1998',100,84,34325713,405391,13120814),('12/02/2011',139,92,28374832,974485,18090708),('25/01/2014',52,68,4662410,918699,7722469),('16/04/2007',89,180,6006748,973014,3200668),('09/03/2012',79,177,14941595,377921,57933054),('19/11/2007',79,194,96516596,874398,15842189),('23/06/2006',8,108,22174637,243784,21960030),('24/07/1991',69,147,66584098,845465,2235187),('03/03/2002',72,78,31077322,937894,55340841),('19/01/2011',47,162,73860117,369835,58462052),('08/08/2016',91,52,57261760,478411,86979405),('11/05/2017',30,180,50097718,430049,61089658),('01/02/2010',137,108,42714958,927220,78003080),('25/10/2007',109,121,77788486,484144,11738624),('20/11/2006',83,129,13450803,716068,84260933),('21/04/2002',70,98,1984097,940353,98080599),('07/11/2008',59,76,66140370,884827,2966091),('01/12/2018',116,27,29516758,942765,55307962),('30/01/2006',55,124,45783894,421605,28988740),('19/08/1993',67,91,7913173,334132,54348394),('31/03/1999',128,102,13774969,156297,4131637),('22/04/2014',108,158,28008045,917175,39183362),('27/02/2003',131,21,35994625,846749,36454057),('03/09/2017',33,122,4194425,298863,22092330),('13/12/2013',95,129,7340648,873291,60194199),('08/04/1996',108,184,6573325,675482,88774279),('09/08/2008',135,181,69181397,903925,91764047),('07/04/2005',32,177,45197052,203963,54496151),('20/05/2010',130,19,49246234,870827,68576722),('14/09/1992',10,93,15726318,637249,93197379),('22/10/2011',19,130,60209581,905363,65879917),('17/08/2007',73,96,14970783,810757,20659395),('27/04/2008',106,96,5746808,409187,51791789),('05/11/2001',17,136,77327421,683386,98619550),('04/06/1998',78,195,74208774,164595,1158168),('07/01/1998',109,105,36367775,870549,3388759),('24/03/2011',66,192,89093817,818344,39031076),('23/03/2017',131,175,47778993,228871,57948273),('08/03/2012',103,78,91044592,757625,60548762),('05/03/2005',127,33,41254597,851908,73564493),('21/07/2005',97,63,56408731,738428,76903847),('20/09/1994',71,14,12742684,968168,80495323),('23/08/2012',121,70,2775173,138483,42846186),('29/07/2008',56,92,43056585,881356,78530470),('15/05/2005',44,71,826498,836866,13036498),('11/10/2009',25,28,87148807,897904,69134648),('23/04/1994',93,16,82100302,947070,91673012),('15/04/2001',58,16,34484941,131480,23922275),('23/02/2008',34,182,4961069,681364,19177870),('30/03/2008',77,171,98409179,769456,18961529),('25/11/1998',7,145,16770938,823043,53257288),('26/04/2000',79,84,17989641,186461,21877683),('18/06/2009',102,59,31965825,528757,1840169),('02/10/2015',132,13,1475486,477019,84468044),('11/03/1996',135,43,57203288,101282,78368530),('03/07/2018',12,180,48166371,201796,86123371),('01/01/2008',100,85,40045281,803397,83343938),('06/02/2003',99,71,75141490,100719,92688484)
- ,('25/04/2005',22,91,30860128,968614,34114447),('30/04/2004',76,194,88342639,810129,24758736),('21/04/2008',85,103,30980452,403099,69291619),('14/01/1996',24,182,11408733,535337,68361123),('18/12/1993',87,128,81486746,677852,19678767),('06/01/2004',33,109,96686900,440191,21931870),('07/06/1996',25,16,5656302,564739,20155020),('07/10/1997',78,157,12738846,922404,37913291),('26/10/1997',123,76,40785724,758822,44576800),('10/05/1991',94,38,28372279,484170,32003837),('14/12/2007',111,39,15065942,742690,5420507),('20/01/1994',75,52,40402240,121086,25725304),('31/01/1999',57,77,36430263,962683,22187324),('26/05/1995',137,104,24804950,934779,76088577),('10/12/2015',99,21,85675436,744672,48096277),('25/09/2013',133,23,97258769,136164,94545677),('13/04/1997',12,100,14995393,650044,19286085),('26/08/2013',19,83,387769,780226,11056585),('28/02/2011',85,168,9934981,699199,79037126),('11/03/1996',9,117,20560041,575158,43044294),('25/01/2001',82,35,45311473,719452,58399355),('12/09/2010',42,16,85524102,144608,97001050),('29/03/1995',11,70,67605156,512431,72036792),('31/12/2017',83,134,44415351,156007,7148282),('04/11/2012',74,147,44296716,912574,59177421),('30/09/1995',62,155,7077204,234199,53970970),('16/09/1996',90,42,1664954,219729,24892721),('06/01/2000',87,47,37679550,227207,80454919),('19/05/2019',83,13,57779351,683847,72956232),('09/04/2002',117,13,91171649,632451,33878135),('19/05/2010',55,152,9423870,626152,16922722),('18/05/2019',96,134,14205523,777194,76478668),('08/03/2018',105,148,17876465,216738,47491779),('08/07/2007',110,200,98352025,858557,343642),('17/11/2018',26,91,91526867,495730,61870912),('30/04/1993',75,138,43075143,843711,46649733),('14/07/2008',5,80,79204020,556861,15470685),('18/07/2009',36,78,65876133,291239,94554077),('29/07/1992',26,52,44655057,423326,77255476),('25/09/2010',62,100,37600189,931863,92954597),('19/04/2013',84,7,32260076,567923,33885542),('14/09/2017',34,160,13558192,376243,78932935),('09/02/2010',38,67,19819062,809198,52809793),('26/04/1995',91,71,97481290,618236,42781348),('02/09/1997',130,42,86948605,271639,86173819),('29/07/2001',29,168,40999469,914253,38967847),('10/03/2016',110,110,84090512,289544,55468780),('08/05/2011',58,135,15327728,450570,62688015),('16/11/1996',23,85,36970073,752983,35409453),('05/04/2008',77,33,22138739,286230,39664418),('06/01/2002',21,72,92258564,230813,57370082),('14/09/1993',70,153,39280287,586720,39249308),('17/09/1998',116,138,14514135,864790,18712685),('06/06/2013',49,70,41362032,205887,30824409),('28/11/2018',131,157,30415598,957122,34210279),('11/01/2001',69,34,10699018,800068,4073579),('08/11/1999',19,133,74649652,235145,58440914),('02/07/2015',84,20,42925324,216055,68451450),('24/05/1995',106,112,96076184,673794,49190109),('18/07/2012',7,53,92069157,129877,60942281),('20/02/2006',29,45,90818974,696820,17898637),('07/10/2007',104,119,76067145,346719,39169152),('16/01/1996',36,84,37656984,925673,85941731),('01/02/2009',11,165,16697491,224613,1718749),('01/06/2006',73,100,839997,398704,30214618),('22/06/2019',34,4,50905146,317432,22341366),('30/01/1996',84,6,80374066,421850,92991309),('13/08/2003',98,33,14281530,722836,9896993),('23/01/2017',134,25,13243601,789705,72318088),('04/05/2011',93,53,19220931,178609,91157073),('06/12/2017',46,125,37854361,787081,70194521),('10/08/2006',31,8,18380087,852688,37460634),('25/10/2010',137,111,75084516,682948,20059115),('09/03/2013',128,172,10980285,607262,30701023),('13/08/1994',48,38,65610880,135963,53518187),('03/04/2007',45,80,21524953,871275,33794164),('29/07/1997',102,143,48479589,377360,36097714),('05/05/2004',61,109,62133673,723392,62936084),('27/04/2004',36,40,66734649,809474,31172207),('26/08/2019',58,25,30609576,881944,21604292),('15/07/2013',13,156,53904104,558818,97238171),('24/06/1995',38,80,52434489,577973,29965288),('18/12/1998',46,164,25907227,949632,57561908),('22/07/2003',72,132,37855191,483459,10873737),('20/03/1997',128,155,20568963,640143,69190715),('07/02/1992',84,99,16802996,640810,67012468),('05/04/2004',115,198,81367941,881747,16919832),('08/02/2002',95,3,90621524,889061,9940555),('19/08/2005',15,87,65326417,245955,95208247),('24/03/2019',40,121,90728014,197214,4436640),('04/03/1996',73,170,74393133,708583,13927610),('27/06/2018',95,70,86594774,304958,12985427),('23/07/2001',13,1,59680654,289756,96264592),('22/01/2016',115,47,36726898,854970,83477573),('16/08/1993',126,183,43913546,426952,27100635),('30/09/2008',60,43,73095860,168818,15779716),('30/12/2017',52,156,758565,951590,9910606),('18/03/1999',95,92,97128483,318002,3921109),('17/10/2011',27,76,63369572,243462,24894719),('26/04/2016',109,112,65897713,929010,35880098)
- ,('04/09/2007',102,40,65759896,978280,77891827),('25/10/2015',96,90,97973257,914454,25241275),('21/02/2006',16,180,2523187,381396,42644501),('08/09/1996',120,107,42298324,362470,16209005),('21/11/2016',111,131,4186642,610383,98373607),('10/09/2000',36,178,36691852,718190,39156408),('01/05/2017',110,167,61185469,170051,73195500),('24/08/2004',13,76,81996306,426009,70862201),('07/09/2018',23,11,27053038,295152,30505363),('30/10/2008',88,102,77719307,928226,49986819),('24/05/1996',116,12,98168973,844783,4708084),('17/07/2002',87,10,93359082,800526,72946490),('27/09/2013',139,29,51161964,444508,49158547),('08/03/1995',113,166,149751,786097,38842319),('12/07/2004',59,62,37414502,736876,78224412),('26/11/2019',93,5,41599807,348293,31370292),('29/11/2000',92,162,20219901,989148,17227366),('30/03/1998',60,93,80183663,321099,87138791),('11/04/2004',52,69,42160438,809380,305025),('08/03/1998',64,37,15290572,344802,89012816),('28/05/1993',43,45,61481736,830779,82316117),('31/08/1992',98,50,26083099,366840,30578576),('08/11/2000',22,124,7303156,362781,49488405),('21/05/1993',21,191,76423552,626997,29770619),('13/09/2010',93,41,26041360,422869,67696043),('28/02/2009',62,47,31928047,871149,3545299),('04/08/1993',59,160,80879560,987233,32490168),('22/07/2004',101,103,73726323,316732,16887293),('22/06/2009',113,24,82471627,507793,30282307),('17/10/2014',47,135,43433690,596881,22262339),('31/07/2012',94,83,68354924,438154,12902796),('13/09/2014',118,34,14585697,658939,56582433),('22/01/2013',60,93,2148723,613711,98509300),('17/03/1999',101,83,60898991,200503,7807914),('17/08/2011',18,32,64605949,903429,33625111),('17/11/1993',119,30,75317799,401583,7021526),('04/08/2002',29,123,86013010,889721,54746802),('11/11/2003',112,170,66516710,477421,59876208),('15/03/2009',57,81,28798558,757912,92438597),('15/11/2005',93,39,27372394,895435,26757889),('10/07/1999',16,54,434465,244036,73737952),('27/08/2000',23,67,37757845,405478,23627901),('14/10/1995',24,96,67606389,215174,15852041),('21/05/2002',59,112,4583076,523332,3619155),('19/06/2001',122,57,61960180,310610,56001670),('08/01/2006',133,102,86443961,983975,15039456),('02/05/2014',51,26,51225908,274228,27393229),('30/01/2014',120,166,41780127,971952,73604827),('20/02/2003',71,60,85907507,621061,25247086),('10/10/1996',13,77,32788285,220575,49036573),('01/08/1992',60,176,11661899,206063,5601745),('18/03/2006',27,160,66660793,953807,18868057),('12/01/1993',122,127,86648104,910783,22629219),('01/04/2009',50,29,27688292,117530,19785111),('08/02/1996',92,82,52604473,837526,71864840),('13/07/1993',82,183,74830815,356553,66222269),('04/09/1996',32,190,90590210,453119,13035963),('23/08/2014',137,127,57189226,183325,56195709),('24/02/1991',35,130,43174109,751375,34591945),('30/05/1999',49,108,9540569,293348,30855387),('13/11/2001',134,75,83521123,525846,35894644),('20/04/1994',66,158,61179304,362331,31707689),('12/10/1996',64,79,13308693,460473,50615028),('20/09/1992',91,130,26369443,122380,75005524),('16/12/1997',23,180,1267148,162925,54199548),('14/07/2002',46,144,2122630,738231,22733406),('12/11/1991',68,102,13468977,578047,51122441),('03/11/2007',65,32,41332258,265260,19861252),('17/11/1996',103,138,87813629,576269,28636590),('12/03/2004',89,143,45980947,525404,52264139),('28/12/1991',62,56,41010308,770875,63790687),('18/06/1992',115,34,27717962,497789,7091188),('01/07/2008',126,101,6536282,385651,65482269),('27/05/2011',26,126,76005364,429436,17303149),('24/02/1994',82,61,22173427,964866,39933392),('15/08/1995',133,184,84890563,117027,19288334),('08/03/1997',11,27,25493011,330720,28237749),('29/07/2001',38,192,20612030,233490,58101167),('21/11/2013',62,19,80440570,615933,68572403),('26/04/2012',85,81,82358839,302160,47929694),('23/11/2002',77,72,98617367,202354,2835634),('08/03/2013',35,14,7615047,305067,95770916),('02/02/2009',78,161,84117155,706329,50300927),('16/11/2013',86,197,95159204,555271,39692090),('30/07/2004',67,134,48660836,336461,4274532),('04/10/1999',63,83,53876393,831093,56292159),('17/08/1996',123,12,77569846,281170,95852993),('27/06/2000',113,80,12760186,433504,34365069),('07/12/1996',16,178,4063202,254559,63999788),('09/03/1999',7,133,93345401,163547,94271477),('16/10/1994',13,67,64380292,483740,83909665),('08/04/1996',99,110,42275388,853410,76154557),('27/01/2015',117,99,24818030,109161,77736771),('27/10/2006',98,116,55024507,901851,81257252),('19/04/2019',24,198,28938365,391969,37688586),('14/05/2005',8,118,90024774,481955,60720361),('04/11/2014',41,31,88416666,593295,66776268),('06/09/2005',46,74,30357149,383707,67033433),('05/01/1993',91,59,70264011,435903,65250468),('10/10/2002',127,169,45463487,947528,93038385)
- ,('23/07/2019',108,60,13697389,409494,48234900),('30/07/2005',86,136,40722674,553278,59054593),('12/03/2013',80,16,77518364,746466,52255373),('06/05/2019',84,183,82196703,829578,60722115),('01/05/2001',65,146,39495909,172405,6215614),('10/11/2011',140,143,21078838,748056,21173375),('20/12/1991',58,132,15494651,795704,21619932),('05/11/1999',99,78,94332624,906420,27967712),('14/08/2006',18,31,60100950,935295,98182599),('07/04/2008',15,160,137717,340749,4753797),('30/06/2008',73,105,91300857,226905,52797529),('16/04/2003',113,186,95728962,779082,9032761),('15/10/1997',50,151,77139067,305288,16875746),('22/01/2011',9,119,50142255,316320,59652928),('05/08/2014',116,81,49374284,507485,89121778),('30/12/2009',23,83,42742544,514919,35715194),('26/01/2016',60,175,79007174,310911,64336280),('15/03/2008',4,200,66675103,821866,96708141),('28/05/2003',63,46,61048769,186092,96293186),('01/12/2016',115,65,12591080,913308,57717350),('28/01/2012',92,32,71685258,889638,29950939),('07/01/2017',135,5,27120460,436001,40652080),('24/01/2017',32,12,88650599,425174,97077893),('11/07/2012',2,74,11969672,661055,89817934),('27/01/1998',138,146,84454535,895072,70989231),('10/10/2017',21,181,63451219,983971,87996378),('02/07/2000',27,147,47060703,358295,4197425),('05/08/2018',62,98,75084690,459570,9098658),('19/11/2019',59,182,41640198,728553,53502754),('06/01/2013',43,144,23621627,713481,55166322),('02/08/2018',5,72,44809147,345263,38728615),('22/02/2019',35,43,69890292,514095,81894982),('18/05/2002',52,63,46006078,577006,57267354),('24/04/2018',31,137,86193835,453339,31805993),('07/03/2010',32,102,88689464,306645,96686183),('08/05/1999',96,40,34013115,945187,4578546),('09/09/1992',117,68,15793424,106722,40713190),('21/03/2008',135,74,33876561,910538,15509538),('08/10/2015',57,70,19184453,446400,75640366),('29/08/2015',40,11,73397527,111207,33946830),('02/08/2019',62,48,62869304,730761,66490475),('18/09/1991',43,132,68407234,656200,37606483),('17/06/2004',137,26,66482384,652467,57823985),('03/11/2003',96,50,75826257,111045,62318902),('28/05/2019',93,81,79716738,386045,29063372),('15/11/2006',122,48,67001909,566448,70881861),('21/11/1995',74,58,89809827,893033,6444223),('19/08/2006',46,48,1685478,137854,6531470),('24/03/2003',52,150,60375468,975687,67448035),('14/05/1994',17,183,49009868,884733,95519652),('22/10/2007',69,144,81682548,852496,16110566),('06/11/2015',54,176,2588654,283039,30150065),('10/08/2008',39,132,52599243,426974,4580034),('28/07/2012',136,192,62422075,428577,65582517),('21/09/2007',95,154,91859040,800629,63457083),('20/11/1999',56,90,3335107,402471,6742133),('29/01/1997',49,95,30384586,742703,30039458),('01/07/2000',23,96,63817911,913532,14376705),('07/07/2014',118,110,34708336,238741,78332657),('16/04/1991',139,63,8795414,772885,57217690),('08/10/2014',83,47,96790853,582436,38828075),('05/04/2017',58,176,3084703,937447,98064109),('29/02/2012',7,124,22939538,630518,92810570),('07/12/1995',33,52,53337078,229054,21496285),('14/08/1995',115,161,31041392,930394,89790790),('01/02/1991',4,17,17257963,246754,43612649),('10/01/2015',74,119,20340641,640298,10248805),('09/10/1999',105,143,75443468,778154,13658329),('11/12/1999',105,78,40375318,374044,18244212),('02/04/1994',71,81,56707630,312674,67714724),('14/04/2019',41,22,50486078,702754,4474682),('20/01/1991',46,77,26792285,238297,80171409),('31/05/1994',17,183,59506915,584191,55420698),('17/06/1999',113,132,24149150,680233,55740440),('24/11/2003',29,47,72120213,781174,62278670),('08/03/2011',113,164,96816369,901175,42614114),('03/09/2003',66,102,30947821,665077,43286172),('27/03/1993',98,76,4480523,786734,41154292),('28/07/2009',75,159,36068462,298696,31216721),('04/05/1998',89,41,89644441,743363,821419),('03/05/2018',87,130,76375450,554347,12521302),('08/06/2018',8,146,49714010,638382,22825240),('29/12/2011',123,173,96592328,584539,45280633),('06/05/2018',21,112,65000819,284444,37055179),('06/09/1993',30,115,60806557,842815,1204616),('17/10/1993',25,74,87547295,127573,51434238),('13/01/1998',114,88,25316496,747230,79268377),('14/08/2009',103,46,39721739,327450,69522696),('15/01/2012',18,22,30166650,608246,96973708),('16/09/2000',45,189,3408438,939536,26419311),('24/04/2017',17,117,7972147,415669,3595117),('12/06/2008',73,165,89916169,259752,6430048),('03/11/2000',15,105,41815504,607966,59400437),('29/09/2015',51,42,69006072,583474,50603954),('22/03/1992',97,63,71992600,802625,92476133),('28/07/1992',90,4,94120278,653322,23529907),('04/07/2016',51,21,69689760,124408,70709943),('16/07/1996',119,62,4511302,419311,60797754),('18/03/2000',130,100,95900856,707993,68835622),('07/06/2010',3,116,85390794,896569,83873394)
- ,('04/08/2017',98,9,96232393,483333,11609196),('13/03/2002',29,125,41634648,787441,75214353),('30/07/1998',107,17,62423175,208102,29149667),('04/12/2012',126,201,93136560,881490,51459883),('23/05/2005',30,81,22107924,420836,52922865),('30/06/2009',115,89,1019854,263872,84351461),('13/04/2009',103,138,79166342,339925,35333680),('12/08/2013',90,136,35552136,146534,58774334),('17/08/2019',34,141,54376499,264368,53162558),('21/06/2008',97,98,79943103,461917,64655942),('04/12/1999',102,76,83340087,898040,97926192),('12/02/2014',33,129,98651043,575503,49934722),('22/11/1992',31,163,85444986,151802,31800715),('24/03/2016',110,18,40111259,436765,76705529),('09/04/1997',118,11,17455398,373552,24520819),('20/11/1996',20,195,53154343,670876,90367816),('26/09/1997',109,15,59731215,945023,6072681),('07/03/1998',89,122,63352628,266096,60277914),('03/05/2002',40,47,59481804,534444,76796603),('01/09/2011',36,127,44723482,131797,23788480),('10/04/2004',118,140,33567107,349743,65967204),('04/08/2008',98,58,11377720,715601,91611560),('23/11/2002',5,81,45976259,380966,40680140),('24/04/2017',30,32,49164010,638653,63709782),('28/08/1998',42,59,56762858,526982,88567920),('09/10/2001',46,8,8797778,441251,27768454),('19/09/2016',49,60,7361005,653640,71423120),('20/07/2000',12,124,81391674,446550,64141551),('09/01/2010',104,20,44160735,755076,2725709),('12/02/2013',101,122,73358731,409400,48477677),('11/08/2003',80,45,2517179,340649,47470984),('04/06/2017',9,98,73403744,767686,25010998),('13/09/1999',50,181,37252622,208380,30375091),('19/05/1997',36,22,65487082,885901,23236091),('04/10/1997',39,100,63601670,555317,19161185),('04/12/2006',11,175,32162427,284330,23230360),('11/06/1996',2,77,37725335,201351,56130513),('31/10/2010',96,92,40472617,203672,59688929),('07/04/2005',112,175,14869329,871023,67419623),('17/10/1999',140,138,29424326,673503,54528373),('03/08/2008',52,105,73238202,263658,93772944),('20/01/2005',62,51,65409932,742152,49520706),('05/04/1994',5,68,64929909,466661,85749755),('27/10/2015',128,27,67373615,648958,15991262),('29/07/1993',114,20,58589962,187128,85111785),('22/12/2001',88,39,85829644,690609,12738356),('14/06/2001',13,59,83294230,728897,36081117),('07/10/2006',33,16,35876031,939003,46121635),('08/05/2017',53,198,83309905,832367,64841294),('28/06/2016',35,133,88360711,245925,77585687),('21/09/2007',56,172,96653143,309330,15666172),('18/08/2009',41,110,64834470,522337,75131641),('14/06/2014',71,98,16865735,967998,16391505),('25/08/2008',21,126,827968,942072,9438847),('16/01/2002',68,2,69174433,495500,98896010),('14/04/1991',66,122,64985214,303626,91993804),('27/03/2010',103,6,31113011,375172,76331381),('02/08/1996',41,84,31931502,298908,14223817),('15/03/2001',116,94,83379180,346373,56426549),('29/04/2010',110,111,23330685,665513,10457148),('12/07/2008',68,139,2913105,981977,86637784),('12/08/1992',45,81,42452197,930959,14481034),('26/10/2010',118,27,58702434,569713,15648320),('10/04/2012',65,173,78602981,357389,81003186),('21/10/2011',102,168,73104590,867452,36051313),('26/01/1992',72,189,26389374,267364,9322257),('06/09/2015',131,6,3180758,240625,3937815),('15/12/1996',54,144,66796140,683234,59373628),('10/05/2016',5,136,75743942,952387,61430829),('16/06/2019',36,70,63290255,688934,32658545),('09/09/1998',8,27,71384325,669758,43599935),('22/03/2010',1,35,86412978,390361,9262954),('14/12/2014',93,69,73179791,696358,44553686),('20/09/1993',80,39,88172914,385938,90115590),('25/09/2013',58,19,66461423,197322,86449776),('21/04/1997',124,9,12373598,293772,80163717),('25/06/1995',47,101,63896218,659453,51193720),('17/04/1997',1,53,96920322,601615,54876687),('25/06/2007',89,24,89865815,541228,57717935),('21/05/2000',117,63,16830664,331271,82224556),('20/02/2010',1,193,50360163,896256,60565747),('21/12/2015',84,115,90692756,507822,5210653),('15/02/2006',76,51,83615195,244005,97233695),('19/01/1998',91,112,34576275,136031,52671744),('03/05/2007',35,131,29328472,937075,57668456),('03/11/1993',110,53,50450176,803442,90893382),('03/08/1999',109,128,88293931,308822,52937360),('28/04/1992',45,18,16143509,193679,10791669),('19/05/2008',106,77,67923151,254320,42665931),('29/06/2018',37,62,24320434,397374,20554283),('29/07/2006',49,92,91794494,362100,662706),('14/03/2001',120,127,88194008,513797,16099002),('19/06/2012',22,74,39787067,957636,9890762),('08/10/2016',128,3,3774535,494728,48700248),('23/10/1995',38,78,94583538,231564,89338841),('19/02/2005',69,188,83072682,553382,86943199),('12/04/2004',120,21,39892373,836693,70516780),('15/06/2013',89,102,94890189,549755,64499884),('28/07/1997',97,113,85837200,631321,33092458),('21/07/2007',29,78,17615995,389304,76858880)
- ,('08/03/2019',63,75,4329179,865247,29529651),('17/12/2011',1,73,53348511,101225,84735425),('20/09/2010',96,33,86050542,476102,19620207),('01/09/1998',118,172,15945283,731814,34012883),('27/07/2019',104,181,76300378,438907,43198130),('29/05/2018',10,130,78825583,834008,68870422),('01/04/2013',17,72,94873941,518587,23965353),('21/05/2014',67,135,81181845,810442,14747074),('30/12/1995',125,59,78635568,710106,25187354),('13/12/2007',14,57,77663930,237749,25628197),('08/06/2016',53,10,19305529,705907,70850735),('06/07/2008',31,37,37354041,802281,95376188),('12/06/2012',139,36,87998147,874947,67668403),('10/10/1997',51,140,52805953,107745,13884013),('09/03/2001',73,85,81252745,435695,77516588),('07/08/2000',97,90,70747497,663592,71308719),('17/07/2014',94,164,25808419,312856,98254102),('07/10/1992',68,176,24058228,273341,76461425),('28/05/2006',35,123,79966674,268604,50346978),('19/09/2005',25,120,71770597,665400,59725204),('09/11/2012',81,3,89411457,642236,33676497),('22/10/1992',16,75,14042725,854541,98531334),('07/10/1995',30,191,56126115,387761,86226753),('08/09/2000',26,73,51830417,386922,54210442),('22/12/2009',61,200,98109766,707924,17350769),('28/08/1992',97,54,27975563,411499,42616613),('02/09/2009',5,187,72485739,480645,57637772),('07/03/2019',102,76,94162974,215314,39875360),('30/09/2001',47,96,85155588,670753,95440518),('01/09/2018',104,193,97498722,461953,80791409),('21/05/2014',136,143,62874668,948663,94316308),('08/12/2010',13,12,5481899,875928,76100751),('06/03/2015',91,82,80432196,803849,60406296),('25/03/2007',81,10,38482247,940798,96033040),('18/03/1993',120,158,30849015,197928,28125553),('19/01/1992',28,58,2357703,812997,67636809),('15/12/2015',93,154,7656938,913633,97164786),('07/10/1998',123,19,79445922,197024,76703947),('25/10/1996',24,157,87193813,724194,19468746),('15/11/2004',84,20,34377343,449623,94904046),('31/12/2014',79,5,75612515,338803,67772806),('05/01/2015',87,118,15945351,928459,26552803),('26/05/1999',107,155,92825437,356494,77353138),('03/07/2005',25,48,55544852,603348,65669270),('25/09/1998',20,135,75256459,468435,48378807),('01/09/2003',14,154,62972323,426390,31576346),('05/04/2000',53,173,15706082,472488,2015084),('06/09/2000',13,97,33323656,489073,54648248),('27/01/2002',8,32,30745241,893021,64495696),('18/11/1993',59,170,62450407,812868,53897852),('26/07/2004',88,128,70022627,247028,80206591),('07/11/2014',61,106,42424213,438472,25367763),('11/12/2003',79,74,32331100,843622,11826183),('07/04/2010',14,115,43301094,198478,28417576),('02/12/2005',8,86,86690705,746850,79333480),('15/09/1997',27,127,72301064,705115,95475958),('03/01/2004',91,22,47366202,416575,17962823),('30/01/1997',83,175,85000316,701797,88892697),('03/11/2014',14,67,68142146,954583,82463765),('06/08/2007',32,38,24047925,224560,20591766),('20/12/1991',73,47,53594444,462623,23514408),('30/08/2007',15,33,95765734,676686,96815898),('15/09/2012',70,161,10138308,397233,15106566),('22/08/2007',127,148,29967279,243906,81071710),('09/10/2002',131,135,27967047,851586,83131941),('27/05/2006',62,135,20113641,170488,86956836),('27/12/2016',55,201,72844748,966112,42719611),('18/07/2016',119,52,50831811,183131,4082065),('12/02/2006',109,32,32147994,216059,94066607),('07/05/2002',61,140,47615149,307901,44040648),('13/01/2018',92,39,80476832,724500,57257831),('21/08/2018',111,20,80368491,618983,62178357),('21/08/2014',36,172,77112679,570163,87234115),('14/11/1994',26,181,17865924,903401,2449973),('13/06/2006',12,99,72035187,712204,96324854),('11/10/2014',121,2,88202416,316010,50433988),('13/01/2007',54,177,56069952,398496,51361347),('10/07/2009',24,174,45278531,515402,66135719),('27/01/2018',98,176,21452828,179228,97012014),('25/01/1996',8,35,17962540,327770,93320692),('11/12/2007',38,48,15844618,113730,80013119),('21/04/1993',27,35,120168,320526,28741625),('09/03/2000',51,190,37926929,970336,43539409),('28/08/2011',105,68,84720960,564344,46828951),('06/06/2016',140,8,75107128,519877,75329253),('01/12/1997',15,129,96375983,184839,87310086),('09/01/2013',80,10,92610866,779757,21967482),('23/10/2017',42,78,9206793,197527,35132563),('14/08/1993',21,174,13741052,843630,14259215),('17/06/2003',82,74,18131566,614136,2148817),('08/12/2015',116,185,80605109,740360,29193972),('31/03/2012',111,93,41952179,635626,69723284),('02/11/1998',58,82,34010672,757068,33052483),('16/10/2002',83,68,29115483,489414,92544043),('14/02/1995',45,192,75139531,333313,5464475),('31/07/2015',115,149,86668787,157089,7862561),('09/08/2016',60,110,66756398,600547,39443780),('31/10/2013',7,75,39004986,634097,16366683),('01/06/2000',87,84,40573146,808176,87836285),('03/07/2003',30,1,42484991,405230,21924101)
- ,('16/08/2005',69,163,97264586,877644,13389430),('08/01/2008',123,114,87972655,885151,86975675),('23/01/1998',95,70,93477386,281576,40722902),('17/02/2006',90,92,90818627,861383,19900428),('29/04/1993',134,169,43142795,962464,10654015),('10/12/2016',27,102,27982723,420212,83972686),('10/01/2002',59,7,65892943,612786,59606883),('26/05/2002',79,34,58750651,454049,88505433),('09/08/1999',9,1,16261135,292643,91553774),('02/04/1991',131,123,4916312,280398,15419948),('18/01/2006',43,201,58723883,721279,15674645),('09/11/2007',122,169,59722063,877364,73237450),('12/01/2014',40,152,36117655,486458,1182121),('04/08/2014',76,186,2006607,680773,79503361),('23/11/1995',134,178,42882964,811286,26631044),('13/06/2005',67,110,12812868,538022,77460687),('26/11/2003',76,33,82527853,389314,3142193),('29/10/1994',44,111,40108788,535656,77346790),('22/09/2017',29,143,34956754,404839,64619673),('24/05/1999',117,33,67304949,347921,93641792),('08/05/1994',66,62,64291646,424866,30441664),('25/09/2009',126,134,44421595,798905,39900025),('02/10/1998',108,5,63667845,669028,89186857),('10/12/1997',102,160,53855395,766691,97257275),('25/06/2011',30,153,16609980,621389,50735822),('07/05/1993',87,172,80825464,637749,32370480),('15/07/2003',77,30,77098335,541123,79786478),('08/09/2006',72,186,76966986,106901,48766680),('10/03/2006',26,54,18325251,479873,16749255),('18/08/2019',119,6,64055032,249837,78982608),('28/11/2018',128,5,35889418,262612,2566442),('08/10/2003',23,158,17679243,732418,73697547),('27/10/1991',5,129,4696037,374779,27082336),('06/12/2007',131,147,22610467,913764,72886865),('12/08/1998',51,196,19774384,613074,11150584),('01/04/1992',91,155,68671295,710805,31021792),('08/05/2017',87,1,49611306,701161,97765761),('19/02/2014',12,197,2458411,314252,14730473),('20/04/2012',88,65,65368208,569758,23200083),('06/11/2006',63,55,55394482,548971,2637201),('14/04/2014',87,61,91790526,913815,93724023),('06/05/2011',90,12,59624346,980957,1426868),('29/03/2012',8,54,30879701,987328,38838931),('26/11/2010',67,90,46238130,110975,83374892),('07/12/1998',98,82,50945991,858863,33104915),('07/10/2014',62,153,96297515,308993,60448554),('27/03/2011',110,112,91548193,832580,33312242),('20/04/2010',99,74,60047772,208141,86618326),('10/01/2016',110,78,83996392,653382,15097001),('02/02/2008',113,90,1898158,856432,68881817),('12/04/2012',111,178,45613220,644946,86225183),('25/07/2015',85,89,87394050,620162,79112715),('28/04/2009',136,101,42020887,404466,48619470),('09/01/2002',42,9,71549147,950253,17384284),('31/01/2012',73,25,62736855,117094,12810606),('16/06/1993',125,59,93473447,682241,49115194),('08/10/2007',114,103,29999317,695598,97079612),('12/07/1992',76,31,21136762,585526,28172404),('03/12/1992',102,200,42016059,122254,51414156),('20/10/2003',53,122,63960922,680083,52292580),('28/06/2001',43,161,98355210,716773,46834216),('18/07/1993',62,2,3694324,908830,32081129),('17/10/1998',71,55,36339988,349853,17081326),('25/08/2014',89,48,77992264,582488,38574981),('28/12/2016',136,159,29938796,346196,57256349),('01/01/2018',15,201,50314813,857493,77962037),('09/10/1999',55,85,3205671,499645,89996677),('20/03/2004',13,23,37145848,779639,82963556),('21/12/2012',38,30,83530659,250346,79677780),('24/05/1994',33,108,84830425,901320,53099990),('17/12/2016',104,42,56713234,623193,45330025),('24/02/2002',15,178,2707132,336698,88416631),('28/08/2005',132,159,77959789,845208,13114939),('29/01/1993',75,92,74064743,867187,20954345),('14/04/1993',62,155,71535022,536837,91124650),('17/02/1998',125,154,50379445,215003,21292686),('10/09/1991',23,130,92830315,370302,97009798),('12/04/1997',90,198,73066959,698785,28361638),('12/12/2012',53,98,72471662,524136,80103555),('03/11/2002',46,142,10326886,457340,37701305),('17/06/2017',107,118,19694530,171792,90306891),('22/03/2005',62,46,35313101,699424,2213267),('11/02/2005',16,161,60958164,879314,45266643),('28/03/2015',137,151,9816934,345049,79985402),('24/02/2014',56,69,3419616,596617,56186015),('12/10/1994',28,180,15648412,223736,63667986),('26/07/2006',98,154,37580641,528399,54114487),('17/05/1993',42,60,38988466,336777,34502802),('23/04/1994',135,46,35523582,930179,81448694),('15/03/1998',69,80,55164878,592688,37276153),('04/05/1998',53,36,87245368,989932,51905617),('20/11/2002',64,192,56367736,315040,82587968),('27/04/2009',113,128,52427038,655330,24067529),('23/04/2009',61,85,54506351,102536,42620479),('22/03/1992',75,142,19337012,570734,52909961),('05/11/2000',83,60,89949640,290426,24765773),('30/08/2007',111,125,62878863,399341,80461322),('19/07/2016',74,181,20462807,471755,85269236),('15/12/2004',11,135,18219433,601763,76134305),('03/10/2013',99,166,91042662,550461,55997044)
- ,('24/06/2010',9,58,55499829,722479,79130197),('29/01/1996',132,35,9362416,952843,35615978),('18/04/2000',11,36,23649831,701989,72639350),('03/03/1993',44,80,52847719,907405,24034837),('25/09/2010',130,138,9953509,179216,21931745),('10/05/2000',102,91,70277070,696516,22681100),('08/02/1996',26,1,85267654,864167,76375846),('19/10/2001',30,144,90356036,984674,54933642),('05/04/1997',87,44,11905846,355760,1691329),('05/09/2017',94,133,72699651,136373,60094400),('19/10/1999',22,56,64215552,475601,98694220),('20/01/2011',35,42,14791499,543448,60542413),('19/04/2000',84,107,96772962,687666,8243785),('03/07/2004',98,52,84740271,814597,22644946),('04/10/2012',60,66,19961192,845622,45879873),('24/12/1997',107,55,75533985,531899,87735256),('10/07/2006',4,15,66847175,617403,72786285),('17/06/1993',20,171,67497331,691287,92941157),('13/08/2010',99,113,96315360,551171,42235126),('21/04/1991',106,64,84906014,951161,11567469),('15/06/2015',27,34,21614337,554957,74053525),('30/08/2016',18,98,54815670,381089,63743326),('11/09/2012',55,14,59597069,694781,92555323),('06/12/2005',48,2,43750536,941187,42317868),('28/11/1997',129,158,59582998,924488,87653492),('06/06/2002',57,64,38704484,946601,24078571),('13/07/2014',118,31,67234839,271772,77883244),('11/04/2017',102,38,17393428,947905,21652205),('23/12/2006',120,167,92460428,257868,10197922),('18/04/2009',20,98,81365508,176835,22720751),('19/04/1992',11,112,86569135,669312,14000957),('22/03/2011',15,172,38546022,389355,15725524),('05/04/2018',59,7,96865332,617691,22592028),('13/01/2014',101,191,5215466,179308,94360158),('03/11/2000',135,110,98856810,276150,50888555),('09/08/2019',42,152,12622367,711756,8344845),('04/11/2002',110,58,9385433,119331,14622881),('10/06/2006',22,79,359193,603425,89800599),('17/01/2004',16,52,81751566,941124,89363873),('16/02/2018',3,71,4413772,129636,68139092),('06/09/2000',46,109,7479958,819934,78048051),('16/01/2012',64,4,66686936,219365,75586168),('21/05/2008',59,143,3954988,785855,83365983),('01/01/1995',67,93,4280366,639935,10056015),('14/03/2014',27,185,67564981,981972,15448925),('10/10/2014',92,32,34376809,766084,96377540),('28/05/2009',93,23,3854328,929370,38323077),('28/07/2006',78,102,29973988,216637,29879103),('13/10/1992',86,122,94563879,177574,78335566),('24/12/2002',99,200,86559425,757908,76038769),('26/12/2008',56,147,45126297,723648,72185678),('01/03/2007',115,44,54277964,793044,50052168),('03/12/2011',129,17,70552099,266097,40203947),('05/12/1992',97,169,27673768,843911,16017983),('21/08/2008',100,200,45128962,740666,24242272),('05/07/2015',75,133,26989680,700143,86146254),('24/07/2016',71,120,55215014,822839,95167653),('26/12/1992',37,57,37360068,855499,61285942),('01/06/2017',80,116,76311379,269364,90285183),('22/07/2010',121,65,40521775,397497,17257344),('19/12/2017',87,75,51552671,152444,87147706),('22/04/2018',107,137,82583203,724746,65620094),('25/09/2005',16,135,18401021,283553,20018134),('27/01/1995',71,190,42353264,867163,92954359),('09/10/2000',95,38,48898663,484627,76536594),('28/11/2004',137,41,95012599,886183,84348632),('12/08/1998',28,35,16380924,915383,58193044),('16/04/1995',79,52,47920345,134938,13808307),('10/07/1991',84,105,76423231,955272,28438029),('08/04/2010',138,113,55558367,775957,81231631),('26/09/2017',104,164,45527590,272652,97725286),('03/02/2017',54,24,90971766,282730,94475706),('05/07/2015',53,55,20770692,894909,83442889),('09/08/2001',132,15,54866502,813320,9928138),('25/03/1999',43,156,19903194,211200,60055516),('17/02/1998',119,118,9473186,124850,66418029),('04/03/2012',128,125,29429669,567480,16363666),('15/04/2005',71,110,40692593,352885,97389604),('21/11/2018',8,175,97847609,358214,3871692),('25/11/2012',67,139,81737883,537437,18388536),('24/04/2000',128,111,2537254,656848,33919364),('25/09/1994',115,90,6352966,480693,75384204),('24/06/1994',133,17,16793519,291336,18762604),('20/10/1999',103,89,36369773,828884,38319005),('08/07/2012',94,177,22895164,907843,85184191),('26/01/2018',1,186,36847122,527175,32438181),('01/04/2014',117,23,88887648,619143,96435571),('02/09/2006',28,23,9878260,156405,10868427),('14/11/2015',46,144,9959632,943455,83324018),('21/11/2010',28,20,6823589,123877,23350000),('21/10/2001',128,59,35057381,739541,13981813),('05/05/1994',17,31,3266816,980379,58814712),('07/04/2015',14,76,74599042,722087,7510547),('21/04/2006',6,99,55419214,554424,44358285),('11/09/2005',137,74,32534700,679222,20311903),('21/08/2013',39,163,54718032,562314,63887658),('21/09/2002',9,63,25167054,778782,71725819),('08/01/1999',17,93,29133744,599373,44539922),('05/04/1993',112,83,55343767,296203,69419039),('03/01/1991',89,184,83279291,241141,79390046)
- ;
- GO
- ==================================
- ===================================
- ==================================
- tabla proyecto
- USE [cubo9]
- GO
- /****** Object: Table [dbo].[Proyecto] Script Date: 11/12/2019 5:27:35 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Proyecto](
- [Id_Proyecto] [INT] IDENTITY(1,1) NOT NULL,
- [Proyecto] [NCHAR](50) NOT NULL,
- [Fecha_Inicio_Proyecto] [DATE] NOT NULL,
- [Fecha_Fin_Proyecto] [DATE] NOT NULL,
- [Id_Cliente] [INT] NOT NULL,
- [Oficina] [NCHAR](50) NOT NULL,
- [Costo_Proyecto] [INT] NOT NULL,
- CONSTRAINT [PK_Proyecto] PRIMARY KEY CLUSTERED
- (
- [Id_Proyecto] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[Proyecto] WITH CHECK ADD CONSTRAINT [FK_Proyecto_Cliente] FOREIGN KEY([Id_Cliente])
- REFERENCES [dbo].[Cliente] ([Id_Cliente])
- GO
- ALTER TABLE [dbo].[Proyecto] CHECK CONSTRAINT [FK_Proyecto_Cliente]
- GO
- ALTER TABLE [dbo].[Proyecto] WITH CHECK ADD CONSTRAINT [FK_Proyecto_Fecha_Fin] FOREIGN KEY([Fecha_Fin_Proyecto])
- REFERENCES [dbo].[Calendario] ([fecha])
- GO
- ALTER TABLE [dbo].[Proyecto] CHECK CONSTRAINT [FK_Proyecto_Fecha_Fin]
- GO
- ALTER TABLE [dbo].[Proyecto] WITH CHECK ADD CONSTRAINT [FK_Proyecto_Fecha_Inicio] FOREIGN KEY([Fecha_Inicio_Proyecto])
- REFERENCES [dbo].[Calendario] ([fecha])
- GO
- ALTER TABLE [dbo].[Proyecto] CHECK CONSTRAINT [FK_Proyecto_Fecha_Inicio]
- GO
- USE [cubo9]
- GO
- INSERT INTO [dbo].[Proyecto]
- ([Proyecto],
- [Fecha_Inicio_Proyecto],
- [Fecha_Fin_Proyecto],
- [Id_Cliente],
- [Oficina],
- [Costo_Proyecto])
- VALUES
- ('Molestie Sed Id LLP','22/07/2003','30/08/2014',36,'Interdum Enim Industries',42087717),('Magnis Associates','12/08/2003','11/10/2018',114,'Mauris Inc.',97766457),('Cras Associates','27/10/2007','05/10/2016',125,'Urna LLC',38531156),('Ut Odio Vel PC','02/11/2005','15/06/2016',66,'Sem Industries',85933888),('Tortor Nibh Inc.','08/03/2006','03/04/2014',112,'Nisl Corp.',85411190),('Quisque Associates','26/10/1995','12/01/2019',61,'Magna Industries',45231958),('Arcu Et Industries','06/06/2005','25/09/2016',89,'Velit Egestas Inc.',39584771),('Faucibus Corp.','26/04/1996','06/05/2015',54,'Ut Pharetra LLP',23618062),('Vulputate Incorporated','17/06/1996','02/04/2009',10,'Nibh Enim Gravida Institute',15601006),('Ac Feugiat Non Inc.','28/11/2008','16/03/2011',88,'Faucibus Leo In Incorporated',77844166),('Risus Limited','28/10/2008','30/09/2010',106,'Consectetuer Adipiscing Foundation',90525002),('Faucibus Morbi Vehicula Inc.','17/05/1998','25/02/2011',82,'Praesent Luctus Curabitur Institute',84270073),('Nulla Consulting','04/12/1999','10/07/2019',32,'Hendrerit A Industries',53761457),('Magnis Dis Ltd','18/12/1999','18/06/2014',17,'Lacus Quisque PC',49326958),('Ligula Nullam Enim Ltd','26/11/2000','17/12/2017',36,'Dolor Inc.',13570568),('Nunc Company','08/07/2005','18/07/2015',74,'Diam Company',46220861),('Vestibulum Institute','23/09/2004','16/12/2017',104,'Integer Corp.',53168723),('Ultricies Dignissim Institute','28/01/2002','27/10/2010',139,'Semper Cursus PC',44408826),('Est Inc.','12/06/2002','28/08/2014',130,'Metus LLC',81739316),('Mauris Rhoncus Corporation','02/07/1992','26/02/2010',109,'Leo Associates',70879632),('Ipsum Phasellus Incorporated','20/02/2003','12/03/2017',3,'Ridiculus Mus Aenean Corporation',50972625),('Commodo Ipsum Corporation','08/04/1996','12/01/2018',102,'Orci Foundation',73844450),('Cursus LLC','02/07/2008','20/11/2016',16,'Nunc Mauris PC',64762069),('Ac Fermentum Vel Inc.','23/09/2007','12/02/2015',80,'Ultricies Foundation',95866896),('Pede Limited','12/11/2006','30/05/2016',129,'At Arcu Vestibulum LLC',9042830),('Massa Integer Vitae Limited','31/08/2000','20/12/2012',91,'Fusce Fermentum Industries',58132338),('Purus Mauris Corp.','21/10/2008','29/06/2019',53,'Nunc LLP',85538020),('Sed Dui Corp.','30/06/1995','25/03/2018',28,'Orci Inc.',60460730),('Sapien Cras Dolor Inc.','16/01/1994','23/01/2011',79,'Iaculis Lacus Pede Corp.',63878138),('Diam Pellentesque Habitant LLC','13/11/2002','29/08/2012',1,'Egestas Fusce Ltd',46619431),('Cras Corporation','09/08/1994','23/10/2014',15,'Ac Limited',86680047),('Eu Associates','07/12/1992','14/10/2010',104,'Dapibus Limited',84847371),('Est Arcu Foundation','27/04/2006','29/01/2013',70,'Tempor Company',79986475),('Lacus Corp.','08/01/2004','03/02/2009',30,'Convallis Ltd',94722035),('Lobortis Mauris Corp.','15/11/1992','21/05/2018',110,'Nec Metus Facilisis Institute',9584055),('Consectetuer Incorporated','09/05/1997','06/09/2010',92,'Ipsum Sodales Purus Inc.',58322012),('Dui LLP','10/09/2000','06/01/2019',52,'Neque Vitae Company',60282093),('Donec Luctus Aliquet Corporation','28/09/1995','13/10/2014',109,'Tristique Foundation',4084168),('Auctor Velit LLC','06/07/2002','25/02/2009',109,'Luctus Curabitur LLP',23971478),('Imperdiet Nec Leo LLC','10/04/1994','13/06/2010',79,'Molestie Dapibus Ligula Company',16645121),('Magna Duis Dignissim Consulting','30/04/2001','25/04/2018',17,'Vivamus Nibh Dolor Associates',5039428),('Nonummy Ac Incorporated','24/01/1993','20/02/2017',127,'Nisi Mauris Incorporated',46444582),('A Neque LLC','01/03/1999','16/07/2009',59,'Neque Nullam Industries',49294397),('Integer Tincidunt Incorporated','27/02/2003','21/11/2012',36,'Fames Ltd',50796036),('Ac Mattis Industries','15/06/2002','29/07/2013',136,'Dapibus Rutrum Company',67828990),('Integer Company','20/05/1994','13/02/2016',105,'Velit LLP',88506626),('Lectus PC','19/11/2008','01/10/2017',23,'Nulla Vulputate Dui Inc.',3986310),('Nec Urna Ltd','03/07/1992','16/10/2009',27,'Vitae Sodales Nisi LLC',19133054),('Hendrerit A Arcu Limited','24/03/2006','04/09/2019',140,'Tellus Eu Corporation',92831810),('Mollis Corp.','14/08/1993','17/01/2017',55,'Cubilia Curae; Inc.',47483731),('In LLP','29/08/1995','12/11/2016',98,'Sit Amet Diam Corp.',13013314),('Mattis Semper Dui Incorporated','22/06/1995','30/07/2018',7,'In Cursus Institute',78689327),('Molestie Sed PC','02/07/1998','21/11/2014',58,'Libero Proin Mi PC',57281949),('Euismod Enim Etiam Corporation','30/10/1992','27/01/2013',38,'Aliquet Associates',41785951),('Est Associates','23/01/2003','12/05/2017',101,'At Egestas A Corporation',54423185),('Sed Corp.','04/06/2001','03/09/2011',97,'A Scelerisque Sed PC',34957450),('Non Justo Institute','29/01/2004','18/08/2015',127,'Dis Parturient Industries',65801397),('Justo Corporation','26/09/2005','17/07/2014',11,'Vitae Purus Gravida Associates',42253360),('In Magna Phasellus Institute','13/07/1996','30/10/2010',115,'Lacus Corp.',48003377),('Sagittis Felis Limited','04/04/2003','24/10/2011',21,'Ac Mattis Limited',72433408),('Integer Sem Limited','28/04/2008','16/10/2013',83,'Lectus Inc.',44990945),('Eu Foundation','02/10/1991','13/07/2013',63,'Magna Lorem Ipsum Corp.',35339643),('Ut Foundation','29/06/2005','14/12/2018',19,'Elit Fermentum Risus PC',32852819),('Tellus Limited','26/10/1996','09/06/2018',95,'Ligula Elit Limited',56235665),('Dictum Proin Corp.','01/10/2006','09/09/2016',65,'Mauris Sagittis Placerat Ltd',16822342),('Aliquam Nisl PC','16/01/2006','23/03/2015',15,'Quisque Limited',57076142),('Lorem Corp.','15/04/1991','15/05/2014',39,'Hendrerit Id Inc.',36390822),('Duis Cursus Corp.','02/01/2004','20/11/2014',87,'Vehicula Et Rutrum PC',37756470),('Eget Corporation','29/11/2007','23/04/2013',25,'Egestas Hendrerit LLC',43338436),('Ipsum Primis In Ltd','05/06/1992','20/07/2019',16,'Diam Luctus Corp.',64175415),('Sem Incorporated','09/01/1999','08/11/2013',59,'Ante Nunc Associates',17580993),('Orci Lobortis Augue Incorporated','25/02/1996','14/06/2018',79,'Dictum Mi Ac Corp.',94438814),('Turpis Nulla Associates','08/04/1991','10/02/2012',84,'Eu LLC',88474161),('Vel Turpis Aliquam Corporation','24/02/1994','14/05/2019',107,'Ut LLP',51206027),('Auctor Odio A Incorporated','04/04/2008','15/03/2013',90,'Donec Elementum Inc.',17122023),('Per Inceptos Corporation','13/06/2006','02/09/2018',14,'Nulla PC',55958060),('Sed Pede Incorporated','27/03/2000','06/06/2018',1,'Magna Ut Foundation',39908154),('Mi Limited','12/04/2003','10/06/2013',18,'Sapien Corporation',20590283),('Amet Dapibus Id PC','14/09/2005','03/11/2009',47,'Ac Mi Institute',77848284),('Nunc Quisque Ornare Industries','26/05/1993','15/09/2016',91,'Aenean Egestas Hendrerit Limited',10920802),('Orci LLC','25/05/2002','16/06/2011',84,'Natoque Penatibus Corp.',94353638),('Et Foundation','08/01/1995','19/03/2009',75,'Eleifend Associates',52272110),('Ut Institute','01/02/2008','19/02/2016',119,'Fusce LLC',21430211),('Turpis Industries','14/01/1991','04/02/2009',132,'Nunc Limited',7878860),('Rutrum Eu Foundation','15/01/1996','01/04/2016',65,'Curabitur Egestas Institute',10609091),('Donec Foundation','16/11/2005','18/10/2013',14,'Magna Sed Incorporated',78596273),('Adipiscing Mauris LLC','25/05/2008','23/05/2016',75,'Dui Quis Accumsan LLC',72770381),('Dis Parturient Foundation','10/07/1993','14/01/2010',100,'Duis A Mi Institute',82821206),('Bibendum Fermentum Associates','13/05/2002','18/04/2013',49,'Vel Limited',94652579),('Imperdiet Erat Nonummy LLP','20/10/1993','30/05/2011',125,'Adipiscing Elit Curabitur Incorporated',7240925),('Mollis Incorporated','03/02/1992','28/03/2009',81,'Ridiculus Mus Industries',83249588),('Vitae Consulting','26/07/1999','12/03/2011',127,'Consectetuer Ipsum Corp.',25422605),('Lorem Ut Institute','17/12/2006','21/11/2015',7,'Amet Nulla Donec Consulting',9325651),('Magna A Consulting','11/04/2002','23/08/2012',16,'Consequat Nec Inc.',67390512),('Neque Sed Institute','01/02/2008','26/08/2012',69,'Turpis In Condimentum Ltd',27405850),('Venenatis Vel Faucibus LLC','18/12/1993','10/01/2013',75,'Augue Corporation',5098190),('Dui Nec Consulting','08/06/1994','06/02/2014',9,'Dapibus Institute',22112454),('Mi Tempor Lorem Incorporated','10/04/1996','09/10/2009',32,'Felis Adipiscing Fringilla LLP',12675101),('Dis Parturient Montes Institute','12/11/1992','22/01/2017',44,'Tellus Faucibus Associates',2257449),('Integer Eu LLC','26/08/2008','15/03/2010',112,'Tempus Eu Ligula Consulting',55895740)
- ,('Blandit Viverra PC','02/12/1991','12/10/2018',127,'Tristique Neque Venenatis Consulting',53458428),('Natoque Penatibus Et Industries','13/05/2007','26/02/2016',133,'Tristique Senectus Et Foundation',39086223),('Urna Institute','08/11/2005','08/08/2012',99,'Enim Suspendisse Aliquet LLC',77866178),('Orci Luctus Et Corporation','20/01/1998','18/07/2009',76,'Mauris Corporation',36705063),('Adipiscing Associates','27/04/2001','07/06/2016',54,'Luctus Et LLC',85579763),('Tristique Senectus Corp.','02/02/1996','23/01/2016',40,'Neque Incorporated',17271885),('Interdum Associates','07/05/1997','26/09/2009',93,'Non Hendrerit LLC',63274369),('Gravida PC','17/06/2008','12/07/2016',58,'Malesuada Institute',50197558),('Dolor Sit Consulting','04/02/1997','03/03/2009',28,'Aenean Sed Pede LLC',92187813),('Lacus Mauris Non Consulting','08/07/2001','07/04/2019',22,'Ante Institute',35900290),('Nisi Cum Institute','12/04/1992','22/01/2009',82,'Nunc Mauris Morbi Company',77694794),('Tortor Dictum Inc.','11/07/1998','06/12/2017',136,'Nunc Pulvinar Foundation',47209171),('Dignissim LLP','29/07/1994','11/01/2014',114,'Dui Augue Eu Ltd',82010215),('Sed Eu Nibh Limited','30/01/2007','23/09/2011',80,'Ornare Consulting',67022341),('Dui Fusce Diam Associates','08/12/2007','16/02/2015',36,'Fusce Diam Institute',87691041),('Vehicula Inc.','11/06/2006','27/09/2016',100,'Elit Industries',75253406),('Morbi LLP','11/12/1994','02/08/2010',59,'Odio Sagittis Semper LLC',48141153),('Interdum Consulting','05/12/1996','01/11/2017',47,'Sed Institute',82994078),('Molestie Consulting','21/03/2005','18/11/2014',67,'Morbi Metus Vivamus Associates',84478735),('Nullam Lobortis Associates','20/10/2005','21/01/2013',6,'Cursus Diam Industries',91446190),('Auctor Corporation','10/02/2008','03/11/2009',42,'Lorem Incorporated',16933246),('Egestas Consulting','08/07/1998','20/09/2015',94,'Bibendum Sed Consulting',41516025),('Sit Amet Faucibus LLC','02/12/2006','12/04/2016',68,'Bibendum Sed Est Corporation',70100655),('Molestie Arcu Sed Industries','10/12/2001','27/02/2017',57,'Metus Facilisis Lorem Limited',23527056),('Phasellus Institute','26/02/2000','09/02/2014',113,'Mauris LLP',65099776),('Est Foundation','31/03/2003','12/02/2016',34,'Morbi Accumsan Laoreet Corporation',85330899),('Fusce Consulting','24/06/2006','12/07/2012',66,'Consectetuer Incorporated',31632185),('Proin Ultrices Duis LLP','07/01/1999','22/10/2017',116,'Accumsan Interdum Industries',97573614),('Blandit Mattis Ltd','03/05/2008','01/09/2015',61,'Tristique Pharetra Corp.',31797479),('Imperdiet Incorporated','31/05/2007','04/10/2015',54,'Non Egestas A Limited',11821362),('Nunc Ullamcorper Company','09/10/2006','11/01/2017',5,'Aliquet Lobortis LLC',86892097),('Aliquet Nec Institute','01/09/2008','23/08/2010',93,'Dolor Associates',69229216),('Ipsum Ac Mi Consulting','12/12/1997','27/07/2010',121,'Arcu Sed Et Limited',9016408),('Vel Corp.','07/10/2000','13/10/2012',67,'Scelerisque Consulting',71401278),('Arcu Curabitur Corporation','17/10/2000','06/07/2019',99,'Augue Porttitor Interdum Ltd',94665919),('Duis Cursus Corporation','05/06/2006','05/01/2016',70,'Orci Phasellus PC',65315385),('Mi Company','23/09/1998','21/08/2009',132,'At Egestas PC',88045740),('Egestas Incorporated','08/04/1993','23/06/2011',60,'Cursus Et Eros Institute',54821647),('Pede Industries','18/03/1994','02/06/2010',11,'Ornare LLC',97832038),('Integer Id Magna Corp.','03/09/2004','09/03/2015',107,'Elit Nulla Facilisi Corporation',6246370),('Eu Dolor Corp.','22/09/2002','28/05/2016',123,'Sed Eget Lacus Consulting',45446195),('Aliquet Incorporated','12/02/1992','20/03/2019',132,'Blandit Mattis Corporation',92023565),('Est Arcu Incorporated','17/08/1993','02/10/2013',108,'Libero Foundation',6640377),('Nunc Corp.','02/09/1998','09/06/2019',91,'Auctor Inc.',41700010),('Eu Limited','07/10/2003','25/07/2015',1,'Convallis Dolor Quisque Inc.',71212245),('Enim Diam LLC','06/03/2007','21/03/2019',27,'Convallis Ligula Donec Consulting',70473549),('Bibendum Donec Felis Institute','30/06/2001','25/05/2016',7,'Urna Suscipit Inc.',58029972),('In At Foundation','04/11/2001','23/02/2011',100,'Enim Curabitur LLC',87871677),('Duis Corp.','03/03/1997','13/02/2018',39,'Arcu Sed Institute',92768033),('Lectus Sit Limited','04/06/1994','20/01/2018',10,'Nam Nulla Consulting',12229517),('Vel Limited','26/12/1995','05/11/2017',37,'Mi Enim Condimentum Incorporated',69275098),('Ultrices Company','27/02/1999','23/07/2015',7,'Suspendisse Inc.',14107823),('Donec Ltd','14/03/1995','07/02/2019',31,'Sem Semper Erat Corporation',84738260),('Urna Inc.','18/06/2005','21/10/2014',36,'Cras Lorem Corporation',24524408),('Ac Risus Morbi Ltd','30/07/1997','29/03/2018',115,'Volutpat Ornare Facilisis LLC',33804766),('Sociis Industries','28/07/1992','09/07/2009',69,'Commodo Auctor Inc.',28998021),('Donec Company','18/04/1994','26/08/2014',33,'Morbi Tristique Senectus Industries',60768407),('Quam Dignissim Pharetra Consulting','05/11/2002','14/02/2017',21,'Eget Magna Suspendisse Foundation',23526998),('Suspendisse Non Leo Consulting','21/02/2004','13/12/2011',91,'Adipiscing Lacus Ut LLC',94395166),('Magnis Dis Parturient PC','15/02/2000','26/08/2015',101,'Sed Turpis Nec Associates',29293736),('Ut Dolor Institute','10/05/1997','15/02/2009',86,'Quis Massa Consulting',58787583),('Sit Amet Faucibus Incorporated','18/03/2005','06/02/2009',17,'Sed Tortor Integer PC',82532533),('Eget Venenatis Industries','23/05/2002','01/08/2015',28,'Mi Duis Risus Consulting',96906977),('Mus Proin Vel Inc.','15/07/1996','24/02/2017',49,'Eu Odio Tristique Associates',32294600),('Eu Augue Institute','10/07/2005','24/08/2009',35,'Vivamus Foundation',15312723),('Nonummy Fusce LLC','15/03/2002','06/10/2016',1,'Donec Associates',97623230),('Molestie Sed Institute','08/11/2002','11/03/2016',125,'Feugiat Non Inc.',34234625),('Bibendum Consulting','01/04/2001','09/12/2013',6,'In Lobortis Tellus Institute',91798376),('Conubia PC','19/03/2007','01/05/2019',61,'Erat Volutpat LLP',77737676),('Urna Limited','22/01/2001','11/03/2016',92,'Ut Lacus Nulla Consulting',58516164),('Egestas Hendrerit Neque Corporation','04/06/1999','24/09/2016',126,'Turpis Nulla Corp.',26772194),('Nunc Nulla Vulputate Industries','12/04/2005','18/05/2016',101,'Dictum Company',97785578),('Malesuada Id LLC','25/10/2000','18/01/2010',74,'Lacus Aliquam Incorporated',96156760),('Justo Praesent Incorporated','03/04/2007','08/07/2015',45,'Viverra Donec Foundation',22777932),('Elit Aliquam Auctor Ltd','24/05/1998','07/12/2019',54,'Ac Sem Ut LLC',58357734),('Massa Associates','24/09/1992','28/08/2014',85,'Sem Pellentesque Company',21817933),('Cursus Purus Consulting','30/01/1994','15/04/2018',108,'Auctor Non LLP',50127950),('Enim Etiam Imperdiet Associates','25/08/1996','19/06/2010',65,'Morbi Tristique Senectus Associates',76359788),('In Limited','03/09/2007','15/08/2010',69,'Velit Eu Corp.',4396393),('Id Mollis Nec Limited','03/02/1993','27/04/2015',91,'Fusce Dolor Quam Corporation',42605362),('Aliquam Ltd','10/07/1992','31/07/2010',39,'Mi Felis Adipiscing Foundation',33935948),('Natoque Ltd','18/11/2003','30/11/2012',60,'Magna Tellus Associates',46275889),('Mus Proin Vel Limited','23/08/1991','15/05/2019',5,'Erat Etiam Inc.',61551261),('Cursus Non Egestas Consulting','17/10/1993','13/12/2016',44,'Orci Ltd',16361305),('Interdum Sed Auctor Company','22/08/1996','04/06/2012',30,'Augue Incorporated',54056933),('Curabitur Foundation','22/03/1995','29/01/2014',53,'Lectus Nullam Suscipit Associates',75148636),('Ornare PC','25/05/1993','21/01/2012',101,'Neque Sed Dictum Ltd',72773558),('Vitae Ltd','02/12/2003','22/05/2010',16,'Nulla Facilisi LLP',43306819),('Nulla Integer Industries','15/09/1994','14/06/2012',87,'At Egestas LLP',60121219),('Fermentum Risus At Consulting','21/09/1993','24/04/2019',21,'Malesuada Vel Convallis Company',44460418),('Sollicitudin Corp.','23/07/1994','22/03/2015',87,'Pellentesque Institute',29160945),('Volutpat Ornare Facilisis Corp.','20/12/2005','16/09/2012',37,'Donec Institute',77757167),('Semper Pretium Neque Limited','20/09/2005','14/08/2019',44,'Sit Limited',3674137),('Ligula Tortor Ltd','19/04/1994','30/11/2010',40,'Dictum Corp.',79675406),('Eget Dictum Placerat Institute','17/01/1999','21/09/2015',43,'Mauris Incorporated',49250284),('Vitae Consulting','23/11/1997','07/01/2010',9,'Et Corp.',32922489),('Dis Parturient LLP','25/06/2002','27/08/2018',109,'Purus Corporation',40060889),('At Fringilla Purus Industries','03/08/1991','15/09/2009',36,'In Faucibus Morbi Foundation',7173579),('Congue A Aliquet LLC','12/05/2003','26/02/2018',84,'Ac Ipsum Phasellus Company',46434853),('Ut Sagittis Inc.','28/06/2004','03/05/2011',14,'A Purus Foundation',24260219)
- ,('Ipsum Company','15/10/2007','21/11/2017',25,'Enim Commodo Inc.',56849315),('Suspendisse Ac Metus Institute','11/08/1992','09/12/2017',18,'Risus Incorporated',97608110),('In Faucibus Industries','26/07/1998','31/07/2018',105,'Suspendisse Commodo Tincidunt Company',18647597),('Orci Institute','31/12/1993','21/09/2018',85,'Sodales Mauris LLP',5111996),('Dui LLP','03/06/2002','01/03/2014',111,'Donec Institute',29701592),('Dis Parturient Corporation','02/08/1999','12/09/2014',49,'Nulla LLC',43513014),('Nibh Sit Incorporated','12/12/1998','30/05/2010',116,'Euismod Enim Etiam Corp.',44255950),('Pellentesque A Foundation','25/02/1993','09/06/2015',118,'Fusce Company',70852212),('Proin Ltd','19/02/2000','19/12/2011',32,'Ridiculus Mus Donec Inc.',1944494),('Faucibus Morbi Vehicula LLP','15/02/1991','11/01/2019',50,'Vivamus Non Industries',18032315),('Sapien Limited','27/07/1998','15/05/2016',89,'Ut Molestie PC',51300128),('Aptent Taciti Industries','21/02/2001','04/02/2012',83,'Etiam Bibendum Fermentum Incorporated',18897132),('Feugiat Tellus LLC','21/04/2001','07/03/2012',106,'Egestas A Scelerisque Corporation',87238985),('Purus Corp.','03/02/1992','10/01/2011',57,'Tellus Suspendisse Sed Corporation',90392983),('Dictum Placerat Consulting','30/12/1998','05/09/2012',63,'Ante Dictum Mi Consulting',6764465),('Nascetur Ridiculus Mus Company','21/05/1996','29/12/2013',21,'Primis In Faucibus Limited',70750803),('Egestas Consulting','07/08/2001','15/01/2013',62,'Tincidunt Corp.',77691368),('Donec Institute','30/03/2007','01/01/2015',88,'Ac Corporation',48876683),('Donec Elementum Lorem Corporation','07/12/2008','26/11/2012',140,'Sed Est PC',84143183),('Curae; PC','06/05/2007','15/01/2017',57,'Commodo Tincidunt Nibh Foundation',23853787),('Auctor Industries','18/10/2005','13/04/2012',50,'Semper Egestas Corporation',110484),('Tempus Inc.','25/11/2008','21/09/2009',55,'Dui Nec LLC',77638010),('Maecenas Iaculis Corp.','10/04/2002','14/10/2013',81,'Aliquam Nec Enim Institute',39781569),('Quisque Varius Foundation','13/03/1999','24/04/2014',75,'Est Congue LLC',34148730),('Turpis Nulla Aliquet Industries','18/08/2002','27/12/2009',130,'Nullam Feugiat Placerat Company',95869930),('Cras Convallis Convallis Consulting','01/08/2007','05/03/2014',25,'Ut Quam Vel Corporation',55405828),('Ultricies Limited','09/03/1992','20/08/2019',112,'Eu Corp.',48283937),('Egestas Blandit Ltd','23/03/2003','30/06/2015',99,'Duis Cursus Corporation',29303643),('In Scelerisque Company','29/09/2003','31/01/2013',117,'Fusce Diam PC',45560826),('Integer Foundation','20/04/2000','15/11/2016',81,'Nulla Integer Corporation',8814868),('Turpis Foundation','25/04/2006','20/10/2010',61,'Ut Ipsum PC',48561503),('Ipsum Primis LLP','13/05/1992','06/07/2019',140,'Cursus Nunc PC',62563183),('Mus Company','13/02/1995','21/08/2012',109,'Semper Egestas Company',37915001),('Arcu Vivamus Sit Corp.','26/12/1994','21/01/2018',124,'Placerat Eget Ltd',52642816),('Blandit Associates','11/09/1998','13/07/2014',79,'Dolor Donec Fringilla Inc.',81323160),('Dictum Eu Eleifend Foundation','02/12/1995','22/03/2012',82,'Tristique Ac Eleifend Consulting',76545824),('Eu Augue Porttitor Foundation','23/03/2005','04/07/2012',50,'Egestas LLC',94016093),('Justo Sit Institute','05/11/2000','08/09/2012',113,'Ac Corp.',24912580),('Elementum Limited','28/04/1997','29/06/2014',18,'Pede Praesent Eu Institute',54856962),('Adipiscing Foundation','01/11/1996','07/12/2014',7,'Blandit Associates',72463377),('Elementum Sem Vitae Company','05/04/1997','06/09/2010',2,'Donec Egestas Industries',24257252),('Mauris Non LLC','25/10/1994','21/08/2016',38,'Luctus Vulputate Associates',21943636),('Vitae Erat Vel Corp.','27/04/1991','18/12/2015',71,'Dui Cum LLC',38843770),('Ultricies Ornare Elit Limited','18/08/2001','15/12/2015',1,'Aliquet LLC',63986713),('Magnis PC','06/05/2000','13/07/2011',68,'Conubia Nostra Per Ltd',76219015),('Sed Nunc Est Foundation','13/01/1991','05/08/2013',118,'Metus In Nec LLP',76042978),('Libero Consulting','09/06/2002','21/09/2009',88,'Ridiculus Mus Proin Company',11988919),('Magna Limited','17/11/1993','12/11/2016',19,'Eu Augue Foundation',34571492),('Fusce Dolor Quam Corporation','14/10/2003','21/12/2018',103,'Sed Molestie Sed Incorporated',6015472),('Pede Industries','10/10/2000','02/05/2018',27,'Tincidunt Vehicula Ltd',69755949),('Etiam Corp.','26/05/2005','29/09/2019',32,'Venenatis Lacus Etiam PC',14419902),('Nibh Consulting','24/06/1999','19/09/2013',89,'Dolor Donec Fringilla Incorporated',22334794),('Varius Ultrices Associates','11/11/2005','09/01/2013',60,'Tortor Industries',30094711),('Pellentesque Inc.','16/05/2005','16/05/2009',35,'Ullamcorper Nisl Arcu Corp.',92533045),('Lectus Cum Sociis Company','19/12/2007','17/07/2014',42,'Diam Eu Dolor Ltd',5270024),('Placerat Cras Dictum Corp.','20/10/2003','03/01/2014',72,'Lectus Limited',97838489),('Dolor Nonummy Ltd','18/11/1992','08/04/2011',49,'Placerat Associates',77609101),('In Limited','25/03/1997','04/11/2018',107,'Augue Ut LLC',5346128),('Lectus Sit Amet Corporation','29/05/2004','01/08/2016',137,'Pretium Neque Industries',67392149),('Aliquet Libero Associates','23/07/2006','19/08/2012',56,'In At Corporation',21156033),('Nunc Sit Institute','03/01/1994','07/01/2017',36,'Eu Industries',15511053),('Quam Ltd','12/06/1998','14/12/2010',78,'Posuere Cubilia Limited',62839192),('Integer Limited','14/04/2001','18/06/2009',34,'Sagittis Placerat Cras Ltd',73912899),('Justo Sit Amet Foundation','17/10/1993','17/05/2009',108,'Vel Company',46130764),('Et Euismod Et Corporation','20/03/1999','06/01/2013',33,'Mi Associates',51103803),('Sed Consulting','26/12/1997','04/09/2011',26,'Ut Sem Nulla Corp.',53348159),('Elit Institute','09/06/1993','29/11/2013',42,'Tristique Associates',15146909),('Sed Nunc Est Industries','25/01/2005','21/03/2010',59,'Ullamcorper Viverra Limited',61949340),('Mus Aenean Eget LLP','13/07/1992','22/11/2014',105,'Adipiscing Associates',28538929),('In Consectetuer LLC','21/08/2001','22/07/2012',134,'Nibh Associates',81101384),('Magna Industries','27/01/2003','30/11/2017',9,'In Hendrerit Consulting',29715663),('Mauris Foundation','16/08/2003','24/09/2013',16,'Tincidunt Tempus Risus LLP',42698033),('Ipsum Dolor Inc.','15/10/2008','06/05/2014',22,'Vulputate Velit Eu Associates',20817035),('Pede Sagittis Incorporated','02/02/2001','12/01/2015',89,'Praesent Company',88290140),('In Nec Orci Inc.','23/09/1996','12/02/2009',108,'At Ltd',10283170),('Enim Curabitur Ltd','27/01/1999','26/10/2010',99,'Velit Pellentesque Institute',55402992),('Enim Gravida Sit Corporation','03/07/1994','29/12/2012',52,'Scelerisque Industries',66533014),('Enim Curabitur Massa PC','20/07/2003','27/03/2017',17,'Phasellus Dapibus Quam Incorporated',82229020),('Nisi Company','26/05/1998','04/08/2011',2,'Fringilla LLC',39388821),('Faucibus Company','15/01/2006','18/08/2013',35,'Porttitor Eros Consulting',18445376),('Et Magna Praesent Ltd','16/01/1998','18/06/2009',81,'Integer In Magna Foundation',61343426),('Accumsan Limited','06/07/2008','23/10/2010',90,'Tempor Associates',54710453),('Sit Amet Ltd','16/08/2006','04/12/2009',82,'Aliquet Vel Industries',49151472),('Cum Sociis Company','07/08/2003','13/07/2014',130,'Nec Tellus Nunc PC',49792697),('Adipiscing Lacus Ut Limited','22/08/2000','28/12/2014',92,'Et Magnis Corporation',63430278),('Sed Nunc Inc.','31/05/1995','21/02/2010',3,'Lorem Associates',78132571),('In Associates','08/09/1994','31/12/2012',132,'Nec Quam Ltd',80221636),('Euismod Company','14/01/1995','20/12/2010',16,'Dictum Ultricies Industries',41601316),('Dapibus Associates','18/07/1992','14/06/2013',75,'Quam Elementum At Incorporated',83570641),('Augue Sed Company','17/08/2008','14/10/2019',1,'Nascetur Ridiculus Foundation',36010054),('Ac Orci Corporation','12/04/2002','17/12/2010',108,'Integer Limited',21932093),('Sem Elit Pharetra Industries','31/10/1995','01/10/2019',71,'Nascetur Ridiculus Mus Ltd',69448570),('Faucibus Morbi Corporation','19/04/2003','09/10/2015',133,'Mauris Morbi Non Industries',55151833),('Vitae Mauris Incorporated','12/03/2005','21/05/2014',130,'Placerat Ltd',57599531),('A Scelerisque Corporation','22/03/1999','20/05/2014',31,'Massa Vestibulum Corp.',3004193),('Magna Company','23/10/1997','17/05/2016',134,'Ut Nulla Industries',3389495),('Interdum Ltd','14/11/1998','13/02/2018',54,'Lobortis Incorporated',95923043),('Dictum Phasellus In Consulting','19/09/1999','24/01/2009',39,'Nec Ltd',15099148),('Vulputate Ltd','20/01/2001','29/07/2011',95,'Est Nunc Ullamcorper Industries',45693919),('Vulputate Ullamcorper Magna Incorporated','15/09/1999','05/02/2009',32,'Mauris Ut Mi LLC',97975457)
- ,('Integer Inc.','11/08/1996','20/02/2014',12,'Lectus A Ltd',36261776),('Magna Praesent Interdum Consulting','30/05/1999','30/04/2015',51,'Natoque Penatibus Associates',55771110),('Dui Nec LLP','19/12/1998','02/04/2010',46,'Parturient Montes Nascetur Limited',41656017),('Turpis Nulla Aliquet Corp.','25/05/1995','18/10/2019',98,'Accumsan Convallis Ante Incorporated',14051137),('Sit Amet Corporation','29/05/2008','23/03/2012',84,'Convallis Ligula Donec Company',11695341),('Ad Litora Torquent Limited','26/06/1994','20/09/2011',119,'Vel Turpis Aliquam LLP',65044721),('Nunc Ullamcorper Institute','05/07/2004','19/07/2014',16,'Erat Eget Inc.',89174783),('Libero Est Congue Limited','14/03/1998','10/04/2014',126,'Adipiscing Ligula Aenean Corp.',67803321),('Lectus Ante Dictum LLP','21/02/2005','05/07/2012',95,'Commodo Auctor Velit Industries',84910903),('Vel Convallis Industries','02/12/1998','23/12/2013',44,'A Aliquet Vel LLC',96783775),('Ultricies Limited','18/05/2007','19/11/2013',10,'Nisi A Odio Inc.',49905211),('Turpis LLP','12/03/1998','04/05/2014',77,'Suspendisse Foundation',30814164),('Rutrum Lorem PC','10/02/1993','17/06/2014',6,'Pede Ac Foundation',37949693),('Tristique Ac Eleifend PC','29/05/1993','13/09/2017',32,'Sit Amet Ltd',43027220),('Nonummy Ipsum Institute','21/11/1992','21/11/2011',26,'Tincidunt Nibh Institute',22892293),('Libero Industries','01/08/2004','03/12/2010',9,'Semper Et Limited',28291550),('Neque Associates','04/06/2005','02/08/2015',123,'Malesuada Malesuada Integer PC',40638938),('Dictum Ultricies Corp.','12/05/1993','05/10/2010',132,'Vulputate Dui Nec PC',87426474),('Nullam Associates','09/10/2005','15/10/2017',44,'Ut LLP',91425993),('Pede Blandit LLP','08/07/1998','14/10/2014',107,'Fermentum LLP',20177256),('Id LLP','05/04/1996','10/05/2011',76,'Feugiat Industries',82267990),('Dictum Phasellus Inc.','10/07/1992','04/10/2010',70,'Tellus Ltd',7640192),('Adipiscing Ltd','23/03/2005','21/05/2016',27,'Metus Institute',73505113),('Iaculis Lacus Corp.','27/04/1993','07/12/2011',101,'Pede Ac Institute',40616825),('Sed Pharetra Inc.','06/04/1995','12/07/2009',9,'Vitae Incorporated',71585377),('Sit Amet Orci Industries','26/08/2005','26/08/2019',98,'Dui Semper Et Industries',81740002),('Diam Inc.','15/01/1994','02/04/2018',129,'Ut Inc.',9650297),('Donec Company','17/01/1992','19/07/2014',124,'Ornare Placerat Incorporated',36767068),('Metus Vitae Ltd','24/03/2007','10/02/2017',43,'Diam Luctus Lobortis Ltd',9875066),('Integer Sem Corp.','16/09/1994','17/10/2009',45,'Tincidunt Corporation',37208274),('Mus Aenean Eget Limited','05/06/1998','13/04/2011',130,'Lobortis Tellus LLC',91534138),('Eu Eleifend LLC','30/09/1994','18/09/2012',100,'Mauris Corp.',95049917),('Auctor Velit LLC','18/05/1992','17/02/2013',48,'Neque LLC',80038305),('Odio Institute','23/07/1996','18/04/2009',2,'Felis Nulla Incorporated',44529837),('Ligula Consectetuer Rhoncus Company','29/11/1998','10/03/2017',135,'Ut Quam Vel Ltd',6620164),('Nunc Sollicitudin Commodo Company','24/07/2000','12/04/2017',18,'Odio Associates',8999792),('Eget Metus Eu Company','23/02/1993','31/03/2018',97,'Et LLC',46319007),('Nulla Institute','19/03/1996','04/07/2018',29,'Pretium Aliquet Metus Corp.',44642825),('Donec Egestas Associates','19/08/2002','06/02/2012',104,'Commodo Tincidunt LLP',70169767),('Lorem LLP','20/07/2003','19/08/2016',131,'Augue Incorporated',29139836),('Augue Porttitor Interdum LLC','26/02/2006','11/06/2011',61,'Aenean Sed Company',59588822),('Mollis Non Cursus LLP','20/04/2007','15/10/2019',126,'Felis Eget Inc.',66235769),('Dapibus Ligula Foundation','01/10/2004','13/07/2014',23,'Convallis In Cursus Incorporated',68994540),('Mattis Corp.','02/08/1991','30/09/2017',76,'Lobortis Quam Limited',87172951),('Massa Integer Associates','16/10/1994','31/12/2009',89,'Vulputate LLP',10123980),('Ligula Eu Enim Corp.','16/03/2000','30/05/2017',48,'Orci Donec Nibh PC',97489105),('Gravida Molestie Limited','23/03/1997','30/11/2010',58,'Ornare Inc.',7980058),('Nec Enim Nunc Associates','01/04/2003','17/05/2014',88,'Primis In Faucibus Institute',82893575),('Pede Blandit Congue Company','04/04/2003','19/12/2015',129,'Orci Luctus LLP',17812429),('Diam Pellentesque LLC','23/04/2006','28/10/2017',100,'Scelerisque Dui Consulting',49020224),('Eget Metus PC','12/04/1995','27/03/2012',87,'Id Associates',52682958),('Purus Maecenas Libero Inc.','19/06/2007','08/09/2017',58,'Integer LLC',19359271),('Velit Aliquam Nisl Inc.','03/04/1998','13/02/2019',76,'Semper Dui Lectus Incorporated',48522044),('A Nunc In LLP','10/07/2006','03/12/2014',46,'Pellentesque Ut Consulting',8136267),('Augue Sed Institute','17/12/2000','13/06/2015',11,'Mi Duis Associates',93212772),('Vitae Posuere At Foundation','16/10/2000','25/12/2018',92,'Arcu Corporation',287942),('Tincidunt Aliquam Consulting','13/11/2000','18/10/2018',32,'Luctus Foundation',97082475),('Lacus Corporation','16/06/1993','16/05/2014',73,'Penatibus Et Limited',71772172),('Metus Sit Company','24/07/1991','04/04/2012',95,'Vel Industries',43770024),('Eu Incorporated','05/06/2007','18/06/2018',5,'Lobortis Augue Corp.',61588742),('Maecenas Corp.','03/04/1994','27/10/2012',16,'Nullam Foundation',55930261),('Sem LLP','14/03/2006','20/08/2011',23,'Sed Auctor Associates',96873816),('Vestibulum Massa Industries','05/09/2002','04/04/2012',107,'Congue Elit Sed PC',76868492),('Lacinia Limited','04/08/2003','02/10/2012',80,'Non Arcu Vivamus Limited',87199212),('Metus In Limited','22/10/1992','29/07/2011',97,'Facilisis Corporation',71875298),('Eu Neque Pellentesque Corporation','18/08/1993','18/09/2019',10,'Donec Company',96716593),('Sit Foundation','17/04/2001','08/02/2009',37,'Egestas Sed Pharetra Ltd',61380029),('A Aliquet Institute','16/11/1993','01/12/2010',56,'Donec Elementum Lorem Institute',67915429),('Suspendisse Sagittis Nullam Company','22/08/2006','26/07/2011',56,'Pretium LLC',42756974),('Sem Semper Limited','10/08/2000','15/12/2016',25,'Pharetra Sed Hendrerit Institute',42578030),('Aliquam Company','11/03/1994','09/08/2015',98,'Nibh Donec PC',31105892),('Imperdiet Ornare LLC','05/08/2003','07/03/2009',15,'Enim Curabitur Massa Limited',46806329),('Mauris Magna Duis Foundation','09/02/1995','26/07/2014',140,'Sed Nunc Corporation',64439398),('Arcu Morbi Sit Associates','17/12/1995','24/04/2009',72,'Arcu Iaculis Corp.',13491898),('Cursus Et LLC','29/04/1999','06/12/2016',18,'Tempus Scelerisque Consulting',95771868),('Nulla Institute','24/08/2000','18/03/2009',92,'Congue Corp.',42113932),('Aliquet LLC','04/09/2008','11/06/2018',107,'Scelerisque Mollis Corp.',1468010),('Malesuada Integer Institute','11/01/1998','12/01/2018',130,'Ac Corporation',62437162),('Integer Ltd','06/03/1998','06/12/2013',114,'In Molestie LLC',25542074),('Id Enim Corporation','09/02/1996','31/05/2012',25,'Facilisis Corp.',63225007),('Sed Tortor Company','03/12/2003','03/03/2014',93,'Non Bibendum Ltd',17099378),('Phasellus Ornare Fusce Ltd','20/01/1993','13/10/2011',46,'Aliquet Institute',14107718),('Non Dapibus Rutrum Associates','11/04/2005','15/12/2019',85,'Lobortis Class Inc.',76587030),('Sapien Gravida Non PC','18/04/2005','13/09/2009',113,'Proin Non Company',41702137),('Orci Lobortis Augue LLP','10/05/2006','30/05/2019',64,'Mauris Corporation',20498726),('A Malesuada Id Ltd','16/01/2007','10/05/2016',79,'Quam Corporation',15109482),('Vestibulum Mauris LLC','25/12/2003','30/10/2017',122,'Et PC',30977676),('Ac Institute','10/11/2007','11/07/2011',3,'Pellentesque Sed Company',1501184),('Aliquam Nisl Nulla Industries','13/05/1997','01/03/2009',52,'Diam Consulting',59824836),('Facilisis LLP','01/01/2005','10/07/2019',113,'Netus Et Malesuada Foundation',80719982),('Non Leo LLC','29/11/2005','02/01/2012',105,'Gravida Inc.',37352752),('Dolor Fusce Feugiat LLC','14/08/2006','17/11/2019',43,'Pede Suspendisse Dui PC',68989842),('Vitae Mauris Sit Incorporated','27/03/2008','27/07/2016',35,'Feugiat Sed Incorporated',60689003),('Sem Pellentesque Industries','05/03/1999','31/10/2010',64,'Vulputate Mauris Sagittis Ltd',84907171),('Pellentesque Incorporated','25/09/1996','22/01/2019',115,'Id Risus Industries',56346528),('Vestibulum Accumsan Corp.','26/01/2008','22/02/2010',138,'Fringilla Inc.',74595816),('Elit Etiam Incorporated','12/02/1998','16/10/2010',32,'Neque Institute',76095079),('Morbi Tristique Associates','15/11/1993','14/02/2009',2,'Cras Inc.',85704753),('Molestie Tellus Industries','09/04/2005','28/04/2017',34,'Viverra Maecenas PC',53364007),('Non Cursus Non LLP','04/10/2004','05/09/2011',53,'In Molestie PC',77454450)
- ,('A Felis Industries','15/11/1999','28/02/2013',34,'Suscipit Est Ac Associates',17243818),('Eleifend Ltd','27/05/2003','11/07/2016',139,'Netus Et Malesuada Institute',9833777),('Gravida Nunc Associates','20/02/2005','19/07/2016',7,'Venenatis Associates',30661377),('Quisque Imperdiet Erat Incorporated','18/12/1998','04/02/2010',24,'Tempus Eu Corp.',90716200),('A Facilisis Consulting','10/05/2002','30/07/2015',30,'Auctor Consulting',91868224),('Nec Tellus Nunc Consulting','23/12/1999','15/06/2010',138,'Lorem Industries',4021708),('Non Magna Nam Company','13/01/1996','16/01/2014',11,'Adipiscing Elit LLP',3624895),('Hendrerit A Incorporated','25/01/1999','07/05/2018',22,'Pellentesque Habitant Corporation',42037660),('Malesuada Fames Ac Corp.','02/09/2001','30/01/2010',25,'Ac Libero Associates',48745538),('Pretium Neque Morbi Associates','16/08/2001','24/03/2013',122,'In LLC',79439582),('Auctor Odio Company','21/09/1998','30/06/2017',57,'Pellentesque LLP',72187242),('Tellus Imperdiet Non Institute','11/06/1997','10/04/2010',135,'Elementum LLC',25415389),('Ligula Aenean Gravida Consulting','02/09/2002','30/05/2014',22,'Et Ultrices Posuere LLC',65166950),('Quisque Inc.','14/06/2002','14/02/2010',10,'Eu Nulla PC',3047665),('Semper Industries','14/03/1996','25/09/2009',75,'In Dolor Corporation',33034286),('Pellentesque Eget Dictum Inc.','13/01/2006','07/11/2012',136,'Vitae Mauris Corporation',66855829),('Aptent Ltd','11/04/2000','22/05/2013',1,'Sem Company',13823026),('Eget Magna Limited','01/01/1997','12/01/2012',53,'Curabitur Ut Incorporated',45223261),('Ligula Limited','19/11/2005','12/06/2012',31,'Cursus A Enim Corporation',31960865),('Cras Associates','12/12/2004','30/06/2013',6,'Ipsum Curabitur Institute',61690011),('Quisque Libero PC','09/11/1992','08/12/2010',69,'Volutpat Nulla Facilisis Industries',73729771),('Fames Ac Consulting','27/02/1991','26/06/2012',102,'Quam Elementum Foundation',19861209),('Ante Blandit Industries','24/10/1991','31/01/2017',37,'Tellus Justo Sit Corporation',11907247),('Dui Semper Corp.','28/04/1998','26/10/2014',53,'Consectetuer Cursus Et Company',79842314),('Magna Associates','12/06/2003','31/07/2010',79,'Imperdiet Ornare In Associates',87404488),('Amet Limited','29/01/2002','01/11/2019',107,'Dictum Cursus Nunc Industries',30958793),('Tempor Foundation','18/03/1999','14/03/2013',36,'Nullam Suscipit Est LLC',91741618),('Non Lorem Foundation','30/05/1997','13/08/2010',103,'Non Quam Pellentesque Incorporated',22582731),('Sollicitudin Inc.','19/05/2001','08/03/2013',57,'Lorem Company',26616192),('Justo Proin Non Industries','16/11/1992','27/06/2012',100,'Vitae Orci Phasellus LLC',39467780),('Nulla Ltd','20/07/2000','06/08/2019',97,'Nunc Limited',88094160),('Dolor Sit Institute','14/04/1998','13/07/2015',60,'Morbi Tristique Senectus LLP',1511031),('Posuere Cubilia Curae; Limited','27/04/1997','18/08/2013',42,'Cras Industries',24846282),('Natoque Penatibus Et Associates','20/08/1998','10/04/2018',77,'Tempus Lorem Fringilla Industries',45697497),('Enim Nisl LLC','01/06/1995','08/08/2014',7,'Condimentum Donec Institute',27296292),('Lacus Quisque Imperdiet PC','25/09/2003','28/09/2012',119,'Luctus Ipsum Corp.',78947491),('Eu Odio Tristique LLC','30/10/1995','10/05/2010',24,'Laoreet Posuere Inc.',56845278),('Luctus Felis Ltd','21/03/1998','14/07/2010',48,'Dolor Company',18183830),('Arcu Iaculis Enim Associates','01/01/1994','11/07/2013',48,'Velit Aliquam Nisl Inc.',18450967),('Sociis Natoque Corporation','26/10/2002','18/04/2015',100,'Aenean LLC',97342750),('Lobortis Associates','12/08/1996','11/12/2017',9,'Luctus Limited',76100408),('Non Dapibus Incorporated','10/03/2000','30/06/2009',67,'Iaculis Associates',87468903),('Dignissim Magna A Associates','04/08/2004','07/06/2010',6,'Vestibulum Industries',88767394),('Magna Nec Quam Ltd','19/03/2007','25/07/2019',76,'Elit Industries',49558738),('Maecenas Libero Est Associates','17/06/2008','10/08/2012',36,'Erat Nonummy Ultricies LLC',89226000),('Ac Corp.','18/08/1997','04/02/2017',91,'Fringilla Mi Lacinia Associates',67723788),('Ac Metus Company','01/08/2007','10/04/2011',80,'Sem Consequat Associates',66377969),('Pellentesque A LLC','02/07/2008','02/02/2017',100,'Ante Ipsum Primis Institute',40726077),('Accumsan Neque Et LLP','08/06/1993','02/07/2016',97,'Ipsum Primis Incorporated',82981487),('Aliquet Corporation','23/06/2008','28/06/2009',11,'Et Eros Proin Incorporated',47251957),('Nisl Sem Corp.','24/08/1996','21/02/2014',108,'Massa Suspendisse Eleifend LLP',86546814),('Ultrices Institute','19/12/2005','24/01/2013',43,'Et Ultrices Posuere Incorporated',16285849),('Eu LLP','22/07/1992','09/03/2017',111,'Fringilla Euismod Enim Foundation',93728100),('Massa Incorporated','21/01/1991','17/10/2015',36,'Donec Elementum Lorem Company',20425072),('Pede LLP','26/04/2004','26/01/2011',140,'Purus Nullam LLC',58152456),('Mauris Blandit Enim Incorporated','07/12/1992','17/12/2010',31,'Dictum Eu Limited',94601104),('Pharetra Ut Pharetra Foundation','03/10/2001','23/03/2010',54,'Luctus Sit Amet Limited',84647492),('Felis Ullamcorper Inc.','02/09/1998','31/12/2011',64,'Aliquam Iaculis Ltd',41356954),('Egestas Fusce Aliquet Company','29/09/1997','14/04/2016',24,'Porta Elit A Limited',81879288),('Nec Ante Consulting','01/12/1997','23/10/2016',92,'Rutrum Urna Nec Incorporated',16149132),('Pede Cras Corporation','12/02/2004','12/10/2016',104,'A Odio Associates',74942052),('Penatibus Et Magnis Limited','30/10/2001','31/03/2013',16,'Risus Quisque Incorporated',75712150),('Adipiscing Mauris Molestie Associates','23/07/1994','13/03/2019',96,'Molestie Inc.',30126449),('Quisque Foundation','17/01/1995','02/04/2014',6,'Erat Semper LLP',63202677),('Sed Pede Cum Ltd','04/09/1994','07/09/2010',55,'Mauris PC',17219021),('Vestibulum Ante Institute','04/10/2006','16/08/2019',5,'Ligula Foundation',90993187),('Varius Et LLP','10/10/2007','05/03/2013',15,'Non Consulting',91317090),('Nec Urna Corp.','13/06/1992','19/05/2014',13,'Nullam Corporation',26654084),('Enim Corporation','07/04/2005','16/10/2014',75,'Sit Inc.',23962042),('Pharetra Limited','29/09/2000','14/08/2011',71,'Vulputate Nisi Sem Ltd',75196063),('Malesuada Limited','10/05/2000','25/09/2015',37,'Phasellus Foundation',50247349),('Duis A Mi Ltd','28/11/2004','04/11/2015',129,'Phasellus Inc.',88926188),('Pellentesque Massa Associates','24/09/2007','11/08/2017',54,'Curabitur Vel Lectus Limited',79331676),('Ridiculus Mus Proin Company','17/04/1994','10/05/2017',76,'Pellentesque Corp.',26478689),('Est Nunc Institute','14/02/2006','29/11/2010',2,'Iaculis Enim LLP',6868779),('Convallis Erat Corp.','08/04/2007','24/01/2014',81,'Egestas Inc.',17345189),('Vel Inc.','11/11/2005','22/03/2016',95,'Vitae Limited',25845754),('Eu Associates','03/03/2004','13/12/2014',138,'Accumsan Interdum Consulting',32067996),('Pellentesque Company','07/07/2008','19/01/2009',112,'Lectus LLC',73503472),('Ullamcorper Viverra Institute','20/07/1996','14/08/2016',24,'Metus Vitae Industries',7222397),('Consequat Purus LLC','04/07/1996','07/11/2015',125,'Lacus Pede Industries',24343954),('Purus Gravida Sagittis PC','18/09/1997','30/03/2019',96,'Turpis Institute',49846459),('A Industries','10/02/1995','14/07/2017',80,'Et Corp.',30427085),('Velit In Aliquet Industries','10/03/1997','22/08/2015',130,'Amet Consectetuer Limited',1874032),('Nibh Aliquam Associates','25/08/1999','22/05/2019',128,'Erat Neque Non Industries',20549612),('Et Netus Et Limited','18/11/2000','16/07/2013',7,'Placerat Cras Dictum PC',15150814),('Ornare LLC','04/10/2001','28/11/2014',59,'Molestie PC',20878149),('Eu Ltd','01/03/1992','02/07/2014',26,'Mauris LLC',2219499),('In Lorem Donec Company','01/01/2002','27/06/2012',66,'Consequat Nec Mollis Company',65319165),('Fermentum Convallis Ligula Associates','06/09/2003','10/04/2015',11,'At Velit Cras Limited',49114823),('Lacus Industries','28/06/1993','06/09/2019',65,'Eu Erat Semper Limited',95361280),('Urna Company','28/09/2000','19/08/2016',18,'Consectetuer Euismod Est Institute',20544946),('Libero Proin LLC','21/08/1994','24/03/2014',132,'Ut Cursus Luctus LLC',45460473),('Mus Ltd','10/05/1998','30/11/2010',101,'Sit Amet Dapibus Limited',93174676),('Sem Molestie Industries','25/06/1993','02/01/2019',44,'Ipsum Leo Elementum Company',7896116),('Phasellus At Institute','06/10/2004','28/05/2014',95,'Est Vitae Associates',2191626),('Risus Odio Consulting','05/04/1992','30/03/2018',98,'Cras Interdum Nunc Associates',9584274),('Proin Vel Nisl Associates','10/03/2007','03/02/2017',97,'Magnis Dis Parturient Industries',38644015),('In Dolor LLP','29/03/1997','29/07/2014',75,'Massa Suspendisse Limited',35724206),('Aliquam Iaculis Lacus Associates','06/11/2008','13/01/2010',104,'Purus Gravida Sagittis Institute',21036535)
- ;
- GO
- ==================================
- ===================================
- ==================================
- tabla cobranza
- USE [cubo9]
- GO
- /****** Object: Table [dbo].[Cobranza] Script Date: 11/12/2019 5:28:24 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Cobranza](
- [Id_Cobranza] [INT] IDENTITY(1,1) NOT NULL,
- [Id_Factura] [INT] NOT NULL,
- [Fecha_Cobro] [DATE] NOT NULL,
- [Id_Cliente] [INT] NOT NULL,
- [Monto_Cobrado] [INT] NOT NULL,
- CONSTRAINT [PK_Cobranza] PRIMARY KEY CLUSTERED
- (
- [Id_Cobranza] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[Cobranza] WITH CHECK ADD CONSTRAINT [FK_Cobranza_Cliente] FOREIGN KEY([Id_Cliente])
- REFERENCES [dbo].[Cliente] ([Id_Cliente])
- GO
- ALTER TABLE [dbo].[Cobranza] CHECK CONSTRAINT [FK_Cobranza_Cliente]
- GO
- ALTER TABLE [dbo].[Cobranza] WITH CHECK ADD CONSTRAINT [FK_Cobranza_Factura] FOREIGN KEY([Id_Factura])
- REFERENCES [dbo].[Ventas] ([Id_Factura])
- GO
- ALTER TABLE [dbo].[Cobranza] CHECK CONSTRAINT [FK_Cobranza_Factura]
- GO
- ALTER TABLE [dbo].[Cobranza] WITH CHECK ADD CONSTRAINT [FK_Cobranza_Fecha] FOREIGN KEY([Fecha_Cobro])
- REFERENCES [dbo].[Calendario] ([fecha])
- GO
- ALTER TABLE [dbo].[Cobranza] CHECK CONSTRAINT [FK_Cobranza_Fecha]
- GO
- USE [cubo9]
- GO
- INSERT INTO [dbo].[Cobranza]
- ([Id_Factura],
- [Fecha_Cobro],
- [Id_Cliente],
- [Monto_Cobrado])
- VALUES
- (540,'13/02/2012',99,32804495),(283,'21/03/2014',33,64856185),(653,'29/12/2007',138,89327294),(431,'13/12/2002',6,65258288),(708,'15/05/2004',75,77436851),(480,'30/06/2001',59,6563986),(469,'19/09/2013',80,49189719),(422,'19/07/2017',73,59551405),(776,'20/07/1998',114,30007823),(215,'22/07/1997',105,34070086),(93,'11/07/2008',79,75364110),(420,'22/12/2000',87,46868328),(748,'13/05/2009',111,61894108),(424,'11/06/2000',19,27873291),(319,'05/07/2006',56,55340372),(204,'23/04/1999',104,98815984),(612,'07/04/2010',50,47048873),(295,'11/01/1997',56,98667170),(470,'05/03/1995',59,73110509),(269,'08/06/2010',26,9515628),(532,'23/11/2005',54,67761820),(851,'24/05/2015',17,24882098),(308,'23/03/2004',136,5235530),(795,'02/05/2012',44,51111369),(997,'04/04/2009',99,59701173),(666,'04/08/2007',23,45615210),(187,'01/05/2015',15,63228616),(395,'27/08/1998',47,16306931),(895,'18/12/2003',128,61860917),(306,'29/03/2005',125,12301253),(189,'27/11/1996',85,70574021),(318,'08/10/2018',92,19829345),(611,'08/03/2012',7,10468690),(347,'03/12/2019',97,70955688),(485,'04/03/2017',126,52882182),(82,'23/06/2014',83,32506556),(116,'08/08/2006',19,11551623),(564,'22/01/2003',44,74920878),(544,'11/04/2017',96,29964764),(967,'02/02/2016',56,97030600),(918,'13/05/2009',13,38861937),(741,'29/08/1996',84,94412392),(830,'16/06/2006',15,74313584),(816,'24/08/2019',54,34438496),(778,'10/05/2010',125,47329729),(981,'12/11/2000',32,59027538),(444,'02/04/2007',107,40687340),(697,'07/08/2019',127,75391103),(403,'19/03/2008',18,91390114),(359,'21/01/1999',130,49276746),(924,'30/06/1995',50,28338185),(879,'27/09/2015',106,73171067),(624,'25/05/1999',3,92657829),(79,'11/12/2019',116,47512666),(565,'20/03/2009',62,41632504),(364,'17/09/2002',119,74195266),(655,'09/10/2017',15,68965918),(108,'07/03/2014',35,65888462),(940,'18/03/2005',100,5740831),(641,'24/12/2006',128,81043912),(310,'16/01/2012',40,30692282),(549,'17/05/2009',65,59997083),(735,'10/11/2015',17,30257394),(578,'19/07/2016',77,57045665),(191,'13/05/2009',140,63204545),(224,'27/11/2005',13,3160230),(699,'21/01/2009',42,77511674),(188,'16/01/2018',97,7533710),(623,'07/08/2010',80,8614760),(960,'01/01/1998',75,4311485),(928,'17/11/1996',126,53350573),(381,'01/07/2014',78,79456890),(696,'03/07/1999',109,67659028),(868,'05/09/2016',119,65548694),(436,'24/06/1996',128,41598126),(708,'10/06/2015',40,63122886),(722,'17/02/2006',68,7563449),(998,'21/07/2017',46,14941801),(765,'24/08/1997',5,98594097),(305,'03/04/2019',132,79244053),(817,'01/10/2003',103,22307971),(675,'19/01/2017',14,692978),(270,'09/03/2018',62,25930348),(272,'26/11/2018',12,55522214),(398,'27/02/2006',54,79355469),(668,'03/01/2010',88,97098758),(960,'19/06/2010',32,66264685),(804,'31/08/1998',7,14655103),(497,'17/11/1997',50,53854016),(367,'13/10/2017',95,40338594),(708,'11/10/2015',35,75576982),(498,'27/11/2019',97,84142970),(529,'23/03/2017',37,26836198),(787,'13/01/1999',49,72214044),(529,'23/11/2019',138,11560997),(483,'25/01/2010',56,40970988),(844,'10/11/2015',63,70943676),(530,'08/11/2005',124,38322400),(780,'18/01/2012',14,67711909),(666,'08/01/2002',55,51950327)
- ,(814,'27/01/2008',86,74192176),(675,'12/07/2009',65,1584342),(548,'22/02/2011',32,74359959),(254,'20/11/2006',6,6938732),(826,'21/03/1998',70,51347429),(537,'04/12/2000',73,24021426),(282,'06/03/2017',122,12099234),(336,'14/07/1997',83,14200792),(691,'08/10/2009',71,79586816),(469,'21/04/2001',53,62944018),(661,'06/04/1998',73,25266045),(712,'04/12/2000',106,65774032),(586,'17/08/2004',133,21659939),(675,'09/09/1998',32,65853468),(78,'17/04/2015',79,55925951),(274,'05/05/2016',135,37030143),(499,'14/02/2010',26,24423059),(801,'06/07/2002',138,78540085),(304,'16/02/2008',110,38953078),(411,'02/06/2003',53,23268280),(317,'18/09/2015',117,69467009),(254,'24/06/2010',118,14436155),(8,'17/03/2019',9,81359968),(13,'04/09/2015',26,7378850),(523,'26/02/2003',107,86145388),(987,'07/08/2006',22,62338015),(285,'05/02/2007',11,41952352),(777,'20/12/2012',127,69344155),(721,'11/12/2002',81,64980476),(507,'18/02/2004',14,60753143),(465,'09/02/1998',133,24257296),(556,'16/09/2014',66,31969527),(539,'11/01/2010',5,13301910),(131,'24/11/2002',122,66542644),(336,'28/02/1996',140,92277782),(415,'26/07/2001',128,52070717),(62,'27/03/1998',100,53742106),(275,'10/04/2009',138,56274837),(484,'22/10/1999',76,28052303),(730,'21/09/2004',60,25267763),(343,'22/09/2009',21,48419722),(340,'25/05/1997',55,13404696),(864,'24/12/2001',32,5502986),(288,'24/11/2006',62,84388256),(437,'25/04/2009',16,34744655),(454,'13/06/2015',74,31676957),(286,'11/02/2019',109,17151496),(592,'22/06/1999',68,655872),(928,'06/02/2010',39,6238130),(101,'04/01/2007',95,6005544),(181,'18/05/1995',3,65714169),(530,'13/11/2011',94,65322337),(975,'22/12/1996',37,85817810),(815,'12/07/2016',105,11803248),(342,'26/07/2000',6,74964641),(970,'02/10/2010',79,35394808),(246,'06/11/2012',51,5677672),(470,'06/12/2012',7,47900803),(700,'01/09/2000',73,95893344),(745,'11/03/2009',24,43311537),(127,'26/11/2014',126,6031580),(552,'03/09/2019',130,54197366),(575,'11/07/2016',139,86274357),(790,'28/08/2014',51,40371052),(870,'18/12/2005',26,61632884),(75,'15/11/1999',121,57272226),(408,'23/07/2000',123,64462396),(504,'07/12/2006',28,97170498),(722,'09/07/2019',59,57560168),(284,'09/04/1995',123,95301310),(281,'04/05/2009',118,10914538),(563,'21/06/2007',17,54231557),(131,'18/02/2005',91,97155644),(897,'01/08/1998',83,21007798),(834,'26/07/2006',109,89913919),(413,'10/02/2009',3,55051805),(689,'29/11/2019',120,78368284),(554,'15/09/2014',78,33533519),(271,'26/05/2013',93,17739207),(501,'12/10/2002',34,41112618),(29,'21/08/2001',56,26573971),(907,'02/01/2001',3,67725761),(602,'30/06/2018',96,79885357),(658,'30/12/2014',48,47331680),(322,'09/03/1999',101,74052130),(1,'11/12/2016',110,65264127),(816,'13/11/1996',120,45050372),(599,'15/03/2008',100,42140451),(747,'17/08/2018',123,87367266),(800,'13/11/2007',96,82181084),(170,'12/04/1995',62,37402270),(47,'21/12/1998',95,87544243),(372,'29/08/2011',39,64640226),(752,'12/08/2006',84,87118943),(620,'29/06/2005',77,78997058),(530,'05/02/1995',102,42906376),(544,'05/03/2002',66,7022099),(695,'13/01/2010',92,72113325),(572,'01/04/2008',21,11069479),(787,'22/09/2016',15,21271183)
- ,(118,'30/04/2013',129,1007093),(120,'23/07/2001',21,27748362),(790,'19/03/2009',38,85948802),(838,'23/01/1996',139,37290841),(937,'20/06/1995',104,9032596),(349,'25/10/2018',126,4449340),(952,'06/12/2015',125,18357014),(492,'18/12/2008',87,83716830),(416,'02/12/1999',72,79525906),(210,'19/10/2005',113,74849132),(238,'20/09/2001',42,9781495),(868,'22/11/2007',67,24725762),(538,'17/07/2001',73,77734572),(685,'12/01/2001',6,21225018),(808,'02/07/2008',46,47903187),(416,'19/05/2010',111,65866528),(69,'08/10/2005',33,62324479),(795,'10/10/2006',56,20951952),(417,'26/08/2016',46,46297102),(477,'15/05/2003',101,9830256),(122,'09/07/2013',82,45678653),(768,'12/02/2002',3,68379741),(683,'27/02/2001',56,30136340),(666,'04/08/1999',130,98636869),(904,'06/06/2002',62,65722398),(601,'22/07/1999',26,31896391),(11,'24/05/1997',99,29236995),(28,'26/12/2001',72,4004517),(296,'01/09/2014',80,65668229),(898,'17/05/2013',28,8942962),(287,'25/01/2006',31,89692773),(467,'27/04/2014',17,68160323),(77,'19/04/2009',131,21329283),(100,'02/01/2018',74,62692606),(709,'22/08/1995',28,87697857),(87,'27/04/2019',97,33707602),(871,'07/11/2017',14,34623156),(305,'28/10/2008',80,77404203),(265,'10/03/2013',136,29214501),(953,'05/04/2010',106,36649278),(538,'29/05/2013',66,5169427),(607,'27/05/2000',28,90198782),(782,'01/06/2012',34,25643834),(58,'07/11/2000',82,77569465),(852,'25/12/2007',16,74535418),(953,'30/01/1995',23,20139401),(562,'22/10/1996',39,90176460),(499,'26/08/1995',35,94013431),(177,'21/10/2007',85,15007632),(206,'15/10/2001',85,14291552),(362,'26/06/2015',41,85600205),(415,'28/06/1997',121,39139217),(186,'21/08/2008',134,41337139),(163,'24/08/1998',124,60297951),(694,'19/10/2018',4,81724866),(673,'07/11/2018',128,56686091),(937,'13/04/2018',33,47877172),(411,'06/08/2016',20,50107279),(979,'25/11/1999',108,11711404),(671,'09/02/2017',58,31378722),(57,'24/08/2007',46,73928023),(343,'27/12/2012',32,21879226),(521,'23/04/1995',4,28397773),(405,'06/11/2014',73,25799447),(831,'16/11/2009',7,14435040),(1,'26/06/2008',6,47039249),(402,'22/07/2012',111,72727495),(849,'02/08/2008',104,46286884),(883,'29/04/2015',140,68049586),(64,'28/01/2011',92,35445288),(169,'05/04/2011',44,60382167),(531,'16/11/2005',1,34266649),(979,'17/10/1998',140,9465442),(184,'09/07/2013',58,40798182),(203,'06/07/1999',82,26299371),(888,'06/06/2018',33,86536450),(997,'27/11/2009',122,7213270),(23,'27/06/2009',49,54769527),(945,'16/07/2007',79,53778508),(464,'15/10/2018',16,82814267),(934,'30/06/1996',19,29678453),(13,'18/08/1996',87,69604633),(340,'14/10/2013',96,97895003),(645,'17/05/2012',120,22810178),(548,'14/09/2018',4,85437598),(223,'06/02/2006',34,84970751),(911,'19/12/2011',69,62738366),(478,'05/08/2002',11,9213730),(750,'18/08/2001',113,6902952),(491,'23/03/2003',30,27694509),(565,'02/04/2004',10,72177317),(860,'12/01/2001',96,56155897),(522,'14/12/2019',136,66273998),(407,'26/12/2009',50,86658468),(958,'26/07/2009',79,87147390),(548,'11/08/1998',108,22664296),(256,'31/10/2016',82,27179723),(941,'10/04/2013',49,90174730),(78,'02/04/2004',15,80233079),(702,'13/06/2017',73,10332308)
- ,(243,'04/03/2018',134,95432376),(776,'20/03/1997',121,35638205),(333,'21/06/2009',139,68902706),(913,'23/11/2002',10,12110443),(625,'25/06/1995',130,65595277),(592,'11/09/2017',3,65524019),(194,'14/09/2001',132,95712207),(651,'10/01/2002',103,71492596),(738,'17/09/2018',49,80026323),(621,'28/04/2007',16,97315202),(429,'06/05/2011',136,48617787),(741,'28/11/2010',56,14236401),(495,'12/12/2004',89,34067955),(279,'07/12/2009',8,6759390),(158,'19/01/2015',99,85443917),(676,'19/06/2002',91,19202380),(340,'21/03/2014',129,63492687),(887,'25/06/2000',25,79847934),(605,'05/06/1998',91,878506),(88,'29/01/1999',63,64079891),(616,'23/03/2001',121,93700338),(994,'10/11/1995',107,70286245),(492,'21/01/2004',119,73277125),(287,'02/04/2004',71,31833285),(603,'25/11/2009',82,42298394),(566,'26/09/1995',5,54590308),(581,'05/12/2006',46,87054897),(104,'26/03/2001',36,13233670),(808,'11/02/1997',134,91287653),(43,'23/08/2012',114,63196669),(423,'17/06/2015',88,16663179),(236,'01/05/2002',123,53164661),(766,'07/09/2012',6,6680682),(486,'14/03/2007',8,39494967),(904,'11/03/2013',13,73693863),(562,'07/03/2018',79,94413326),(10,'03/08/2008',52,97703160),(180,'27/09/2002',42,64057829),(931,'02/05/2004',131,73371679),(71,'18/07/2002',110,39617026),(434,'01/11/2019',54,43556039),(443,'15/08/2018',107,9524949),(134,'24/06/2003',113,70665064),(829,'30/11/2017',109,67091823),(50,'12/06/2006',93,39026654),(644,'08/06/2013',40,67984962),(986,'16/07/2019',47,59460564),(37,'18/12/2000',105,96911925),(40,'03/04/2004',76,88282398),(949,'18/10/2009',57,53180787),(171,'03/10/1999',129,69751489),(157,'11/04/2011',15,31024966),(803,'11/09/2008',9,4513166),(124,'06/08/2016',104,67526457),(874,'24/09/2013',35,17473837),(374,'24/03/2004',38,86952699),(687,'12/02/2013',12,46098453),(8,'09/04/2001',10,71153374),(626,'20/12/2019',91,24785935),(408,'08/06/2000',79,63464155),(786,'22/08/2008',78,60128429),(66,'22/12/2019',92,87033344),(386,'10/08/2009',52,68638861),(522,'26/09/2011',124,22532479),(101,'20/09/2004',98,42126690),(575,'24/11/2005',42,89717720),(286,'14/07/1997',119,65579527),(267,'03/01/1998',130,83716994),(607,'22/04/1996',130,77529717),(777,'08/04/1996',90,13817863),(329,'09/02/2006',51,69852590),(270,'20/10/2003',19,70880665),(164,'08/10/2010',83,93788368),(776,'24/04/2013',23,61279411),(205,'07/06/2011',107,48986349),(87,'04/05/2004',135,61611396),(310,'08/08/2005',85,11684308),(929,'02/08/2005',38,96209183),(992,'19/06/2000',130,43022653),(39,'19/08/2005',17,26426725),(110,'07/06/2011',68,36402091),(896,'04/03/2017',94,15254286),(289,'26/03/1998',138,11284908),(716,'01/11/2001',69,86261281),(36,'17/01/2004',69,43832067),(272,'25/10/2009',66,74525097),(680,'29/01/1996',90,76379244),(790,'31/05/2004',81,67800833),(367,'11/04/1997',87,36151834),(683,'15/09/2012',84,69345300),(904,'25/01/2002',62,58940737),(305,'21/08/1997',29,55867478),(269,'28/12/2015',58,21079152),(509,'05/08/2007',75,17393738),(595,'15/07/2017',75,23460101),(577,'13/06/2010',27,88108809),(685,'06/11/2009',131,33167111),(837,'17/11/2010',108,43451955),(893,'16/05/2018',98,88934179),(743,'12/07/2008',132,59799320)
- ,(568,'12/05/2008',99,11272323),(428,'13/01/2005',103,96841584),(642,'21/09/2003',26,12992584),(906,'16/04/2001',98,49256896),(553,'16/01/2007',127,14330649),(193,'17/06/2004',27,18389215),(99,'04/10/2009',130,60451964),(548,'18/07/2014',101,14200799),(811,'29/09/2012',16,53336145),(863,'20/07/2012',10,85447970),(528,'14/05/1999',53,3692488),(885,'13/03/1996',15,27303940),(396,'31/05/2001',84,23837874),(397,'14/10/2006',7,44356034),(698,'16/01/2012',91,83012057),(902,'12/11/2000',47,98301171),(157,'02/11/2010',103,1452306),(14,'08/05/1996',105,98603003),(289,'05/07/2007',42,61599293),(377,'30/03/1995',101,33051528),(800,'01/06/1998',86,5657719),(764,'30/04/2011',31,23674475),(881,'22/03/2018',2,24110024),(900,'16/05/2019',11,75032771),(895,'12/08/2015',110,13866722),(993,'15/02/2017',35,18912099),(23,'01/07/2003',68,80555786),(339,'10/09/2003',13,69256435),(284,'09/03/2007',117,42621567),(820,'05/09/1997',39,40336675),(626,'12/01/2013',96,94892062),(506,'29/03/2012',33,34208685),(249,'03/03/2009',102,88559911),(736,'23/01/2012',7,51393583),(73,'27/07/2011',95,69018377),(266,'17/06/2005',105,84060189),(152,'13/06/2018',108,37898507),(514,'11/12/2009',88,52465616),(583,'03/08/2001',88,38840625),(154,'22/12/1996',2,10491566),(514,'15/02/2015',127,12950475),(740,'30/10/2004',97,78886404),(169,'14/02/2006',105,27712850),(871,'15/07/2002',114,17887750),(58,'19/04/2007',81,39424533),(953,'09/09/2010',63,87113970),(194,'02/02/1998',30,97425976),(147,'19/05/2006',97,71899016),(977,'05/12/2001',78,21454111),(893,'14/11/2000',43,23462203),(920,'13/03/2007',111,12330144),(266,'26/01/2004',121,57605687),(308,'10/02/2016',54,7295745),(430,'23/02/2014',50,41827559),(989,'06/09/2011',75,70677583),(895,'31/08/1999',99,75692013),(908,'29/05/2000',134,73351233),(878,'10/07/2008',19,73071510),(874,'26/02/1995',131,50533970),(37,'24/04/2016',42,43224199),(828,'13/12/2011',138,97420921),(646,'07/11/1995',66,93264107),(848,'01/07/2012',109,50041057),(77,'04/10/1995',82,57126189),(25,'18/06/2006',100,75523066),(863,'02/03/2015',46,97322333),(335,'18/05/2007',48,86500837),(465,'29/04/1996',71,57987398),(772,'13/10/2008',9,26472173),(390,'16/02/1999',119,38084526),(906,'30/01/1996',128,95144117),(368,'10/04/2006',63,59386709),(970,'14/11/2004',107,89898385),(870,'15/05/1998',26,44952814),(974,'04/01/2019',42,62673657),(855,'11/12/1997',131,92347247),(245,'10/09/1995',35,50555180),(45,'31/05/2019',4,58536280),(221,'06/04/2012',70,52471064),(441,'12/09/1999',82,35272819),(781,'26/02/2016',98,31951519),(900,'16/11/2014',102,1197343),(942,'20/02/2017',122,39140114),(189,'30/04/2003',49,9786484),(453,'05/09/2015',82,45113881),(739,'01/10/2009',37,63049115),(90,'26/03/1998',137,35454598),(929,'28/08/1997',25,35992537),(220,'10/04/2014',26,53732027),(676,'26/01/2005',58,83835092),(114,'24/12/2017',123,14449057),(314,'13/04/2007',118,47210601),(8,'13/06/2002',125,63940693),(184,'16/12/2017',71,92157386),(367,'14/04/2015',28,47846008),(926,'24/02/2010',95,7403582),(734,'16/12/1996',122,28939999),(79,'29/04/2010',32,51851937),(757,'06/02/1998',88,67686039),(192,'28/10/2004',118,61077588)
- ,(562,'24/02/2014',80,28846769),(691,'02/10/2017',114,93760749),(541,'02/12/2017',50,2159504),(860,'13/03/2010',80,95487075),(996,'23/12/2004',53,61557443),(115,'07/03/1996',124,36762805),(869,'06/02/2014',15,14953756),(661,'16/08/1996',134,2777713),(530,'21/12/1997',50,35030189),(727,'01/02/2003',28,40265776),(766,'12/09/2017',136,51590328),(975,'28/09/2002',137,71575724),(774,'22/06/2007',113,12554270),(503,'07/11/1999',86,17623174),(153,'17/03/2006',57,51318730),(851,'15/02/2010',36,89838606),(655,'21/12/2008',49,16351939),(520,'01/04/2012',19,97268597),(309,'26/08/2012',122,70551372),(564,'01/01/2013',110,63743347),(208,'16/04/2003',53,73249619),(123,'14/11/1999',66,37422422),(440,'02/08/1997',69,27600702),(477,'03/05/2017',12,81040993),(734,'28/07/2019',93,34154861),(1,'12/09/2016',57,12965830),(758,'09/08/2016',81,18985348),(217,'17/04/2003',27,45789524),(717,'11/12/1997',84,87029849),(183,'01/11/2013',39,19849453),(957,'12/12/2009',57,43341027),(443,'05/09/2010',118,81443800),(748,'16/06/2019',58,9493946),(991,'02/07/2009',83,23143764),(355,'03/07/2013',109,24540876),(771,'03/10/2013',84,80516305),(413,'13/07/2002',82,49664995),(946,'08/12/1998',87,74244507),(298,'23/07/2015',57,72091587),(779,'09/03/2016',54,220166),(478,'04/01/1997',106,60575071),(407,'18/02/2013',50,62072112),(736,'31/08/2017',119,16239200),(582,'04/05/2011',112,41113752),(155,'23/10/2001',101,53817488),(69,'08/08/2017',20,85831560),(430,'18/11/2014',12,59447018),(922,'17/12/2019',35,16647802),(759,'23/01/2005',66,40868321),(616,'24/03/2017',53,23947033),(265,'07/04/2008',48,14362201),(224,'27/12/2007',57,89904748),(248,'27/08/2011',104,24243391),(613,'12/01/1999',89,43868224),(34,'16/04/2010',2,20326732),(611,'09/06/1996',79,13625882),(580,'03/07/2017',119,94538880),(72,'08/05/2014',27,52818497),(99,'02/04/2007',110,14476544),(105,'15/09/1998',87,84772147),(284,'06/11/2013',18,98414712),(391,'01/03/2015',116,44465504),(646,'07/05/2018',56,27626009),(686,'29/06/2019',22,45446404),(579,'25/10/1996',89,83099933),(84,'30/12/2007',61,98568251),(838,'25/04/1998',88,55348555),(301,'08/07/2011',84,50934094),(254,'04/06/2007',34,936487),(70,'20/09/1997',90,62525238),(374,'23/11/1999',42,91770712),(300,'10/04/2014',16,20994925),(73,'31/07/2009',62,85731763),(323,'07/05/2009',119,40910249),(952,'07/08/2008',22,54371791),(469,'02/02/2008',124,84829490),(948,'01/03/1995',75,15695948),(145,'06/04/2011',48,35295893),(842,'17/12/2019',17,48357376),(982,'30/01/2006',56,27655802),(102,'06/02/1997',14,44600442),(228,'10/04/2012',21,95301772),(697,'12/01/2009',58,74933959),(903,'29/11/2001',130,7281204),(819,'18/06/2001',78,16175552),(514,'25/08/1999',100,17506314),(526,'19/10/2018',74,69125541),(363,'25/04/1998',67,50846464),(941,'15/05/1998',8,38566310),(637,'17/07/2014',118,70963791),(593,'03/05/2010',121,27286066),(475,'01/03/2004',107,45621620),(441,'07/04/2002',133,84203419),(926,'22/11/2001',76,75125662),(528,'28/08/2000',70,52174457),(168,'24/01/2014',50,68377818),(500,'26/05/2015',76,25547534),(214,'08/02/2006',8,10183146),(214,'06/12/2016',119,25062529),(714,'02/04/2017',38,73801342)
- ;
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
