Conta dinámica, super útil

dynamic_accounting.sql

DECLARE @STRSQL NVARCHAR(MAX)
SET @STRSQL = 
(
	SELECT
	CONVERT(NVARCHAR(MAX),
	(SELECT 
	'SELECT IdTranFin,FecTran,'
	+ B.M03_TIPO_MOVIMIENTO + ' AS ''TIPO_MOVIMIENTO'','
	+ B.M03_BANCO + ' AS ''BANCO'','
	+ B.M03_OFICINA + ' AS ''OFICINA'','
	+ 'dbo.BFFN_COD_IBS(' + B.M03_NRO_CLIENTE + ') AS ''NRO_CLIENTE'','
	+ 'dbo.BFFN_NRO_CTA_IBS(' + B.M03_NRO_CUENTA + ') AS ''NRO_CUENTA'','
	+ B.M03_NRO_CELULAR_TIT + ' AS ''NRO_CELULAR_TIT'','
	+ B.M03_MONEDA + ' AS ''MONEDA'','
	+ B.M03_OPERACION + ' AS ''OPERACION'','
	+ 'RIGHT(''000000000000000''+REPLACE(ISNULL(Monto,0),''.'',''''),15) AS ''IMPORTE'',' 
	+ 'dbo.BFFN_NRO_CTA_IBS('+ B.M03_CUENTA_DESTINO + ') AS ''CUENTA_DESTINO'','
	+ 'CONVERT(VARCHAR(9),'+ B.M03_CELULAR_DESTINO + ') AS ''CELULAR_DESTINO'','
	+ B.M03_TIPO_COMISION + ' AS ''TIPO_COMISION'' FROM TRANFIN WHERE IdTranFin=' + CONVERT(VARCHAR(21),A.IdTranFin) + ' AND IdTranFin2=' + CONVERT(VARCHAR(21),A.IdTranFin2) + ' UNION ALL '

	FROM TRANFIN A INNER JOIN 
	--CLIENTES B INNER JOIN
	BFBMM03_CONFIG_TRANFIN_IBS B
	--ON A.PerFrom LIKE C.M03_PERFIL_FROM

	ON A.PerFrom LIKE B.M03_PERFIL_FROM
	AND A.PerTo LIKE B.M03_PERFIL_TO
	WHERE CodTran IN (104)
	AND (CONVERT(VARCHAR(8),FecTran,112) = @FecTran OR @FecTran = '')
	AND FecIBS IS NULL
	AND HorIBS IS NULL
	FOR XML PATH ('')))
)
SET @STRSQL = SUBSTRING(@STRSQL,0,LEN(@STRSQL)-9)

INSERT INTO @TEMP
EXEC SP_EXECUTESQL @STRSQL