;with 
	-- Using the query for the cursor
	cursorReplacement AS ( 
		SELECT 	referencia, TAMANHO, LEFT(NEWID(),23) as sgtstamp,
			min(QTD) AS SORTIMENTO,
			ROW_NUMBER() OVER(PARTITION BY referencia ORDER BY referencia,tamanho ASC) AS Rownumb
		FROM arttamcor WHERE referencia = '30110'--IN('29913','30110')
		GROUP BY referencia, TAMANHO
	),
	-- select the tam for each row in the cursor replacement.  Only used for the NOT EQUAL query
	tam as (
		select isnull(tam,'#') tam
		from sgt s
			left outer join cursorReplacement c ON s.ref = c.referencia
		where tam = 'Y'
	),
	-- return a row for insert from cursor replacement with tam set to 'Y'
	tamanhoNEtam AS (
		select sgtstamp, referencia as ref, 'Y' as tam, 
			rownumb as pos, sortimento as dimcol, 
			CONVERT(date,GETDATE()) as ousrdata,CONVERT(time, GETDATE()) as ousrhora,'ADM' as ousrinis, 
			CONVERT(date,GETDATE()) as usrdata,CONVERT(time,GETDATE()) as usrhora,'ADM' as usrinis
		from cursorReplacement c
		where not exists ( select 1 from tam t WHERE t.tam = c.tamanho )
	),
	-- return a row for the insert from the cursor replacement (covers the second insert for the IF NOT EQUAL as well as the IF EQUAL insert)
	tamanhotam AS (
		select sgtstamp, referencia as ref, tamanho as tam, 
			rownumb as pos, sortimento as dimcol, 
			CONVERT(date,GETDATE()) as ousrdata,CONVERT(time, GETDATE()) as ousrhora,'ADM' as ousrinis, 
			CONVERT(date,GETDATE()) as usrdata,CONVERT(time,GETDATE()) as usrhora,'ADM' as usrinis
		from cursorReplacement c
	)
-- INSERT INTO SGT(sgtstamp, ref, Tam,pos,dimcol, ousrdata, ousrhora, ousrinis, usrdata, usrhora, usrinis)
SELECT *
FROM tamanhoNEtam
UNION ALL
SELECT *
FROM tamanhotam

SELECT 
	referencia	= RTRIM(referencia), 
	TAMANHO		= RTRIM(TAMANHO), 
	sgtstamp	= RTRIM(LEFT(NEWID(),23)),
	SORTIMENTO	= min(QTD),
	Rownumb		= ROW_NUMBER() OVER(PARTITION BY referencia ORDER BY referencia,tamanho ASC) 
INTO #arttamcor
FROM arttamcor 
WHERE referencia = '30110' --IN('29913','30110')
GROUP BY referencia, TAMANHO

-- insert tam = 'Y' rows into SGT where they don't already exist
INSERT INTO SGT (
	sgtstamp, 
	ref, 
	Tam,
	pos,
	dimcol, 
	ousrdata, 
	ousrhora, 
	ousrinis, 
	usrdata, 
	usrhora, 
	usrinis)
SELECT 
	sgtstamp, 
	referencia, 
	'Y',
	rownumb,
	SORTIMENTO, 
	CAST(GETDATE() AS DATE), 
	CONVERT (time, GETDATE()),
	'ADM', 
	CAST(GETDATE() AS DATE),
	CONVERT (time, GETDATE()),
	'ADM'
FROM #arttamcor a
WHERE NOT EXISTS (SELECT 1 FROM SGT s WHERE s.ref = a.ref AND s.tam = 'Y')

-- insert all of the rows
INSERT INTO SGT(
	sgtstamp, 
	ref, 
	Tam,
	pos,
	dimcol, 
	ousrdata, 
	ousrhora, 
	ousrinis, 
	usrdata, 
	usrhora, 
	usrinis)
SELECT
	sgtstamp,
	referencia, 
	Tamanho,
	rownumb,
	SORTIMENTO, 
	CAST(GETDATE() AS DATE),
	CONVERT (time, GETDATE()),
	'ADM', 
	CAST(GETDATE() AS DATE),
	CONVERT (time, GETDATE()),
	'ADM'
FROM #arttamcor a