Juan José Ruiz de Castilla tkMageztik

## gist:1985202bdc36d6a7e9c9
http://sqlperformance.com/2013/02/t-sql-queries/halloween-problem-part-1
http://es.stackoverflow.com/questions/3283/orden-de-ejecuci%C3%B3n-de-varios-update-con-sql-server

## tablas_email_sqlserver2008r2.sql
USE msdb
GO

sysmail_help_queue_sp @queue_type = 'Mail' ;

SELECT * FROM sysmail_allitems ORDER BY send_request_date DESC
SELECT * FROM sysmail_sentitems ORDER BY send_request_date DESC
SELECT * FROM sysmail_unsentitems
SELECT * FROM sysmail_faileditems
SELECT * FROM sysmail_event_log ORDER BY log_date DESC

## troubleshotting_correo.sql
-- ACTIVA EL MOSTRAR OPCIONES AVANZADAS EN SP_CONFIGURE
sp_configure 'show advanced', 1;
GO
-- COMO UN COMMIT PARA EL SCRIPT ANTERIOR
RECONFIGURE;
GO
-- MUESTRA LAS OPCIONES DE SP_CONFIGURE
sp_configure;
GO

## gist:a8b641f5e3fc641fb310
1)
http://vishaljoshi.blogspot.com/2009/08/web-application-project-vs-web-site.html

2) De donde se sacó la información y relativo al primer link.
http://stackoverflow.com/questions/7233521/reference-folder-in-solution-explorer-not-showing-vs2010

## importante_sobre_mail.sql
-- ACTIVA EL MOSTRAR OPCIONES AVANZADAS EN SP_CONFIGURE
sp_configure 'show advanced', 1;
GO
-- COMO UN COMMIT PARA EL SCRIPT ANTERIOR
RECONFIGURE;
GO
-- MUESTRA LAS OPCIONES DE SP_CONFIGURE
sp_configure;
GO

## gist:5170668457bae1e48d1b
First of all, you need to decide what is the duplicate criteria that you will use. For example I want to check if the phone number is duplicate in the same Org Nro, company Name and postalcode. I can do this:

First table for test

CREATE TABLE TEST
(
id int,
phonenumber int,
orgno int,
companyname varchar(100),

## gen_drop_script

SELECT
    'ALTER TABLE ' +  OBJECT_SCHEMA_NAME(parent_object_id) +
    '.[' + OBJECT_NAME(parent_object_id) +
    '] DROP CONSTRAINT ' + name
FROM sys.foreign_keys
WHERE referenced_object_id = object_id('Mantenimiento.SIC_T_ALMACEN')

## gist:8308846

DECLARE I INT

SET I = 0

DBCC CHECKIDENT('TABLA', RESEED, I)

## ADV_FS_NUM_LETRAS.sql
CREATE FUNCTION [dbo].[ADV_FS_NUM_LETRAS](
@Numero NUMERIC(20,2) )
RETURNS VARCHAR(MAX)
AS
BEGIN

 DECLARE @ImpLetra Varchar(180)
        DECLARE @lnEntero INT,
                        @lcRetorno VARCHAR(512),
                        @lnTerna INT,

## gist:7308995
http://www.dofactory.com/Patterns/PatternAdapter.aspx#_self1
	http://sqlperformance.com/2013/02/t-sql-queries/halloween-problem-part-1
	http://es.stackoverflow.com/questions/3283/orden-de-ejecuci%C3%B3n-de-varios-update-con-sql-server
	USE msdb
	GO

	sysmail_help_queue_sp @queue_type = 'Mail' ;

	SELECT * FROM sysmail_allitems ORDER BY send_request_date DESC
	SELECT * FROM sysmail_sentitems ORDER BY send_request_date DESC
	SELECT * FROM sysmail_unsentitems
	SELECT * FROM sysmail_faileditems
	SELECT * FROM sysmail_event_log ORDER BY log_date DESC
	-- ACTIVA EL MOSTRAR OPCIONES AVANZADAS EN SP_CONFIGURE
	sp_configure 'show advanced', 1;
	GO
	-- COMO UN COMMIT PARA EL SCRIPT ANTERIOR
	RECONFIGURE;
	GO
	-- MUESTRA LAS OPCIONES DE SP_CONFIGURE
	sp_configure;
	GO
	1)
	http://vishaljoshi.blogspot.com/2009/08/web-application-project-vs-web-site.html

	2) De donde se sacó la información y relativo al primer link.
	http://stackoverflow.com/questions/7233521/reference-folder-in-solution-explorer-not-showing-vs2010
	First of all, you need to decide what is the duplicate criteria that you will use. For example I want to check if the phone number is duplicate in the same Org Nro, company Name and postalcode. I can do this:

	First table for test

	CREATE TABLE TEST
	(
	id int,
	phonenumber int,
	orgno int,
	companyname varchar(100),

	SELECT
	'ALTER TABLE ' + OBJECT_SCHEMA_NAME(parent_object_id) +
	'.[' + OBJECT_NAME(parent_object_id) +
	'] DROP CONSTRAINT ' + name
	FROM sys.foreign_keys
	WHERE referenced_object_id = object_id('Mantenimiento.SIC_T_ALMACEN')
	CREATE FUNCTION [dbo].[ADV_FS_NUM_LETRAS](
	@Numero NUMERIC(20,2) )
	RETURNS VARCHAR(MAX)
	AS
	BEGIN

	DECLARE @ImpLetra Varchar(180)
	DECLARE @lnEntero INT,
	@lcRetorno VARCHAR(512),
	@lnTerna INT,