BEGIN TRAN
	IF OBJECT_ID('tempdb..#Tichete') IS NOT NULL
		DROP TABLE #Tichete

	CREATE TABLE #Tichete
				(
					Id INT IDENTITY(1,1)
				,	IncasareBonuriID INT
				,	FirmaId INT
				,	DivizieId INT
				,	CapIesireId INT
				,	TichetId INT
				,	CantitateBonuri INT
				,	ValoareBon DECIMAL(18,2)
				,	UserCreareID INT
				,	DataCreare DATETIME
				,	Prelucrat BIT
				,	Identificator NVARCHAR(200)
				,	CodServer NVARCHAR(200)
				,	ModPlataId INT
				,	IesCapInseratId INT
				)

	INSERT INTO #Tichete
				(
					IncasareBonuriID
				,	FirmaId
				,	DivizieId
				,	CapIesireId
				,	TichetId
				,	CantitateBonuri
				,	ValoareBon
				,	UserCreareID
				,	DataCreare
				,	Prelucrat
				,	Identificator
				,	CodServer
				,	ModPlataId
				,	IesCapInseratId
				)

			SELECT
				b.IncasareBonuriID
			,	b.FirmaID
			,	b.DivizieID
			,	b.CapIesireID
			,	b.TichetID
			,	b.CantitateBonuri
			,	b.ValoareBon
			,	b.UserCreareID
			,	b.DataCreare
			,	0
			,	b.Identificator
			,	b.CodServer
			,	b.ModPlataId
			,	bonuri.IesCapId
			FROM Retail.BufferTichete b ( NOLOCK )
				INNER JOIN inv.IesCap bonuri
					ON bonuri.FirmaId = b.FirmaId
					AND bonuri.DivizieId = b.DivizieId
					AND bonuri.RetailCapIesireId = b.CapIesireId
					AND bonuri.DataValidare = b.DataCreare
					AND bonuri.CodServer = b.CodServer
					AND bonuri.CodCalc = b.Identificator
			WHERE ISNULL(b.Prelucrat,0) <> 1

	INSERT dbo.IesCapTichete
					(
						FirmaId
					,	DivizieId
					,	IescapId
					,	ModPlataId
					,	TichetId
					,	ValoareBon
					,	Cantitate
					,	UserCreareId
					,	DataCreare
					--,	RetailIncasareBonuriId
					,	RetailCapIesireId
					)
				--OUTPUT inserted.IesCapTichetID INTO @ict(IesCapTichetID)
				SELECT
					temp.FirmaId
				,	temp.DivizieId
				,	temp.IesCapInseratId --ies.IesCapId
				,	temp.ModPlataId
				,	temp.TichetId
				,	temp.ValoareBon
				,	SUM(temp.CantitateBonuri)
				,	temp.UserCreareID
				,	temp.DataCreare
				--,	temp.IncasareBonuriID
				,	temp.CapIesireId
				FROM #Tichete temp
				GROUP BY
					temp.FirmaId
				,	temp.DivizieId
				,	temp.IesCapInseratId --ies.IesCapId
				,	temp.ModPlataId
				,	temp.TichetId
				,	temp.ValoareBon
				,	temp.UserCreareId
				,	temp.DataCreare
				,	temp.CapIesireId

				update bt
					set bt.Prelucrat = 1
				from #Tichete temp
					inner join retail.BufferTichete bt
						on bt.IncasareBonuriID = temp.IncasareBonuriID
				where isnull(bt.Prelucrat,0) = 0
ROLLBACK