USE [master]
GO
/****** Object:  Database [data_hmi]    Script Date: 12/12/2018 16:28:55 ******/
CREATE DATABASE [data_hmi]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'data_hmi', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\data_hmi.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'data_hmi_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\data_hmi_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [data_hmi] SET COMPATIBILITY_LEVEL = 140
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [data_hmi].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [data_hmi] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [data_hmi] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [data_hmi] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [data_hmi] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [data_hmi] SET ARITHABORT OFF 
GO
ALTER DATABASE [data_hmi] SET AUTO_CLOSE ON 
GO
ALTER DATABASE [data_hmi] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [data_hmi] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [data_hmi] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [data_hmi] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [data_hmi] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [data_hmi] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [data_hmi] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [data_hmi] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [data_hmi] SET  ENABLE_BROKER 
GO
ALTER DATABASE [data_hmi] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [data_hmi] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [data_hmi] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [data_hmi] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [data_hmi] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [data_hmi] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [data_hmi] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [data_hmi] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [data_hmi] SET  MULTI_USER 
GO
ALTER DATABASE [data_hmi] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [data_hmi] SET DB_CHAINING OFF 
GO
ALTER DATABASE [data_hmi] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [data_hmi] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [data_hmi] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [data_hmi] SET QUERY_STORE = OFF
GO
USE [data_hmi]
GO
/****** Object:  User [NT AUTHORITY\IUSR]    Script Date: 12/12/2018 16:28:55 ******/
CREATE USER [NT AUTHORITY\IUSR] FOR LOGIN [NT AUTHORITY\IUSR]
GO
ALTER ROLE [db_owner] ADD MEMBER [NT AUTHORITY\IUSR]
GO
/****** Object:  Table [dbo].[rollizos]    Script Date: 12/12/2018 16:28:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[rollizos](
	[rollizo] [int] IDENTITY(1,1) NOT NULL,
	[largo] [float] NULL,
	[diametro] [int] NULL,
	[volumen] [float] NULL,
	[categoria] [varchar](50) NULL,
	[fecha] [date] NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[rollizos] ON 

INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1, 0.244, 23, 101.3761, N'categoria1', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2, 0.244, 25, 119.7732, N'categoria1', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3, 0.244, 48, 441.532, N'rechazado', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (4, 0.244, 30, 172.4734, N'categoria1', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (5, 0.244, 47, 423.3265, N'rechazado', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (6, 0.244, 24, 110.383, N'categoria1', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (7, 0.244, 34, 221.5326, N'categoria1', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (8, 0.244, 21, 84.51199, N'categoria1', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (9, 0.244, 23, 101.3761, N'categoria1', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (10, 0.244, 21, 84.51199, N'categoria1', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (11, 0.244, 17, 55.38314, N'categoria2', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (12, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-10-31' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (13, 0.244, 15, 43.11836, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (14, 0.244, 16, 49.05911, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (15, 0.244, 18, 62.09044, N'categoria2', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (16, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (17, 0.244, 29, 161.1669, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (18, 0.244, 29, 161.1669, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (19, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (20, 0.244, 31, 184.1633, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (21, 0.244, 33, 208.6929, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (22, 0.244, 35, 234.7555, N'rechazado', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (23, 0.244, 22, 92.75239, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (24, 0.244, 25, 119.7732, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (25, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (26, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (27, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (28, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (29, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (30, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (31, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (32, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (33, 0.244, 9, 15.52261, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (34, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (35, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (36, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (37, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (38, 0.244, 21, 84.51199, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (39, 0.244, 31, 184.1633, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (40, 0.244, 30, 172.4734, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (41, 0.244, 30, 172.4734, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (42, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (43, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (44, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (45, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (46, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (47, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (48, 0.244, 24, 110.383, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (49, 0.244, 21, 84.51199, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (50, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (51, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (52, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (53, 0.244, 25, 119.7732, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (54, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (55, 0.244, 29, 161.1669, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (60, 0.244, 30, 172.4734, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (61, 0.244, 20, 76.65486, N'categoria2', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (62, 0.244, 48, 441.532, N'rechazado', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (63, 0.244, 21, 84.51199, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (64, 0.244, 12, 27.59575, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (67, 0.244, 39, 291.4801, N'rechazado', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (68, 0.244, 31, 184.1633, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (69, 0.244, 12, 27.59575, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (70, 0.244, 22, 92.75239, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (71, 0.244, 20, 76.65486, N'categoria2', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (72, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (73, 0.244, 30, 172.4734, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (74, 0.244, 31, 184.1633, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (75, 0.244, 38, 276.7241, N'rechazado', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (76, 0.244, 25, 119.7732, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (77, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (78, 0.244, 23, 101.3761, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (79, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (80, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (81, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (84, 0.244, 21, 84.51199, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (85, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (87, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (88, 0.244, 32, 196.2365, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (89, 0.244, 31, 184.1633, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (90, 0.244, 36, 248.3618, N'rechazado', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (91, 0.244, 31, 184.1633, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (92, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (93, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (110, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (111, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (112, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (113, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (114, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (115, 0.244, 12, 27.59575, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (116, 0.244, 37, 262.3513, N'rechazado', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (117, 0.244, 29, 161.1669, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (118, 0.244, 29, 161.1669, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (119, 0.244, 34, 221.5326, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (120, 0.244, 31, 184.1633, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (121, 0.244, 21, 84.51199, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (122, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (123, 0.244, 46, 405.5042, N'rechazado', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (124, 0.244, 34, 221.5326, N'categoria1', CAST(N'2018-11-01' AS Date))
GO
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (125, 0.244, 32, 196.2365, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (126, 0.244, 24, 110.383, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (127, 0.244, 29, 161.1669, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (128, 0.244, 52, 518.1869, N'rechazado', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (129, 0.244, 12, 27.59575, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (130, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (131, 0.244, 12, 27.59575, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (132, 0.244, 32, 196.2365, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (133, 0.244, 44, 371.0096, N'rechazado', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (134, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (135, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (136, 0.244, 25, 119.7732, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (137, 0.244, 27, 139.7035, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (138, 0.244, 31, 184.1633, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (139, 0.244, 24, 110.383, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (140, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1133, 0, 11, 0, N'categoria3', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1134, 0, 11, 0, N'categoria3', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1135, 0, 11, 0, N'categoria3', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1136, 0, 12, 0, N'categoria3', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1137, 0, 12, 0, N'categoria3', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1138, 0, 19, 0, N'categoria2', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1140, 0, 25, 0, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1141, 0, 29, 0, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1142, 0.24, 26, 127.423, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1143, 0.24, 17, 54.47522, N'categoria2', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1144, 0.24, 52, 509.692, N'rechazado', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1145, 0.24, 27, 137.4133, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1146, 0.24, 35, 230.9071, N'rechazado', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1147, 0.24, 21, 83.12655, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1148, 0.24, 34, 217.9009, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1149, 0.24, 24, 108.5734, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1150, 0.24, 26, 127.423, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1151, 0.24, 26, 127.423, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1152, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1153, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1154, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1155, 0.24, 30, 169.646, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1156, 0.24, 26, 127.423, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1157, 0.24, 28, 147.7805, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1158, 0.24, 26, 127.423, N'categoria1', CAST(N'2018-11-07' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2158, 0.24, 23, 99.71416, N'categoria1', CAST(N'2018-11-08' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2159, 0.24, 35, 230.9071, N'rechazado', CAST(N'2018-11-08' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2160, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-11-08' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2161, 0.24, 29, 158.5248, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2162, 0.24, 43, 348.5283, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2163, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2164, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2165, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2166, 0.24, 32, 193.0195, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2167, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2168, 0.24, 20, 75.39823, N'categoria2', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2169, 0.24, 43, 348.5283, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2170, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2171, 0.24, 42, 332.5062, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2172, 0.24, 43, 348.5283, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (56, 0.244, 26, 129.5467, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (57, 0.244, 28, 150.2435, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (58, 0.244, 15, 43.11836, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (59, 0.244, 15, 43.11836, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (65, 0.244, 20, 76.65486, N'categoria2', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (66, 0.244, 25, 119.7732, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (82, 0.244, 24, 110.383, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (83, 0.244, 22, 92.75239, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (86, 0.244, 30, 172.4734, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (94, 0.244, 30, 172.4734, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (95, 0.244, 29, 161.1669, N'categoria1', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (96, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (97, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (98, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (99, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (100, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (101, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (102, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (103, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (104, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (105, 0.244, 10, 19.16372, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (106, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (107, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (108, 0.244, 12, 27.59575, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (109, 0.244, 11, 23.1881, N'categoria3', CAST(N'2018-11-01' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (1139, 0, 24, 0, N'categoria1', CAST(N'2018-11-06' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2173, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2174, 0.24, 43, 348.5283, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2175, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2176, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2177, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2178, 0.24, 42, 332.5062, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2179, 0.24, 42, 332.5062, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2180, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2181, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2182, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2183, 0.24, 42, 332.5062, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (2184, 0.24, 32, 193.0195, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3161, 0.24, 48, 434.2938, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3162, 0.24, 31, 181.1442, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3163, 0.24, 21, 83.12655, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3164, 0.24, 47, 416.3867, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3165, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3166, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-12-10' AS Date))
GO
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3167, 0.24, 16, 48.25487, N'categoria3', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3168, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3169, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3170, 0.24, 34, 217.9009, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3171, 0.24, 22, 91.23186, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3172, 0.24, 17, 54.47522, N'categoria2', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3173, 0.24, 21, 83.12655, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3174, 0.24, 36, 244.2903, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3175, 0.24, 26, 127.423, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3176, 0.24, 22, 91.23186, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3177, 0.24, 45, 381.7035, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3178, 0.24, 32, 193.0195, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3179, 0.24, 45, 381.7035, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3180, 0.24, 45, 381.7035, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3181, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3182, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3183, 0.24, 24, 108.5734, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3184, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3185, 0.24, 32, 193.0195, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3186, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3187, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3188, 0.24, 45, 381.7035, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3189, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3190, 0.24, 27, 137.4133, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3191, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3192, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3193, 0.24, 28, 147.7805, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3194, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3195, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3196, 0.24, 24, 108.5734, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3197, 0.24, 12, 27.14336, N'categoria3', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3198, 0.24, 32, 193.0195, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3199, 0.24, 18, 61.07257, N'categoria2', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3200, 0.24, 20, 75.39823, N'categoria2', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3201, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3202, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3203, 0.24, 47, 416.3867, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3204, 0.24, 43, 348.5283, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3205, 0.24, 31, 181.1442, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3206, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3207, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3208, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3209, 0.24, 42, 332.5062, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3210, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3211, 0.24, 45, 381.7035, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3212, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3213, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3214, 0.24, 26, 127.423, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3215, 0.24, 31, 181.1442, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3216, 0.24, 27, 137.4133, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3217, 0.24, 27, 137.4133, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3218, 0.24, 47, 416.3867, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3219, 0.24, 34, 217.9009, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3220, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3221, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3222, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3223, 0.24, 46, 398.8566, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3224, 0.24, 33, 205.2717, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3225, 0.24, 43, 348.5283, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3226, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3227, 0.24, 32, 193.0195, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3228, 0.24, 25, 117.8097, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3229, 0.24, 16, 48.25487, N'categoria3', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3230, 0.24, 43, 348.5283, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3231, 0.24, 44, 364.9274, N'rechazado', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3232, 0.24, 30, 169.646, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3233, 0.24, 26, 127.423, N'categoria1', CAST(N'2018-12-10' AS Date))
INSERT [dbo].[rollizos] ([rollizo], [largo], [diametro], [volumen], [categoria], [fecha]) VALUES (3234, 0.24, 19, 68.0469, N'categoria2', CAST(N'2018-12-10' AS Date))
SET IDENTITY_INSERT [dbo].[rollizos] OFF
USE [master]
GO
ALTER DATABASE [data_hmi] SET  READ_WRITE 
GO
