Marco Hernandez marcoah

## video.html
<video id="example_video_1" class="video-js vjs-default-skin"
 controls preload="auto" width="640" height="480"
 poster="http://video-js.zencoder.com/oceans-clip.png"
 data-setup='{"example_option":true}'>
<source src="rtmp://localhost/live/test" type="rtmp/flv">
</video>

## importarcsv.sql
LOAD DATA LOCAL INFILE 'C:/CompartidoMarcoAntonio/PlanCuentas.csv' INTO TABLE contab.ad010
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\r\n';

## mapa-google.html
<!DOCTYPE html>
<html>
  <head>
    <style type="text/css">
      html, body { height: 100%; margin: 0; padding: 0; }
      #map { height: 100%; }
    </style>
  </head>
  <body>
    <div id="map"></div>

## consulta_histograma.sql
Select CASE WHEN prof < 10  THEN 'Menor a 10'
WHEN prof between 10 AND 20 THEN 'Entre 10 y 20'
ELSE 'Mayor a 20' END as Rango, Count(*) as Cantidad
FROM Perforaciones group by Rango

## PasarCoordenadasDoubleaGeography.sql
UPDATE  perforaciones SET POSICION = GeomFromText(CONCAT('POINT (', LON, ' ', LAT, ')'))

## CoordenadaDoubleaGeography.sql
UPDATE [dbo].[Perforaciones]
SET [Posicion] = Geography::STPointFromText('POINT(' + CAST([LON] AS VARCHAR(20)) + ' ' + CAST([LAT] AS VARCHAR(20)) + ')', 4326)
GO
	<video id="example_video_1" class="video-js vjs-default-skin"
	controls preload="auto" width="640" height="480"
	poster="http://video-js.zencoder.com/oceans-clip.png"
	data-setup='{"example_option":true}'>
	<source src="rtmp://localhost/live/test" type="rtmp/flv">
	</video>
	LOAD DATA LOCAL INFILE 'C:/CompartidoMarcoAntonio/PlanCuentas.csv' INTO TABLE contab.ad010
	FIELDS TERMINATED BY ';'
	LINES TERMINATED BY '\r\n';
	<!DOCTYPE html>
	<html>
	<head>
	<style type="text/css">
	html, body { height: 100%; margin: 0; padding: 0; }
	#map { height: 100%; }
	</style>
	</head>
	<body>
	<div id="map"></div>
	Select CASE WHEN prof < 10 THEN 'Menor a 10'
	WHEN prof between 10 AND 20 THEN 'Entre 10 y 20'
	ELSE 'Mayor a 20' END as Rango, Count(*) as Cantidad
	FROM Perforaciones group by Rango
	UPDATE [dbo].[Perforaciones]
	SET [Posicion] = Geography::STPointFromText('POINT(' + CAST([LON] AS VARCHAR(20)) + ' ' + CAST([LAT] AS VARCHAR(20)) + ')', 4326)
	GO