USE [EXXXXXHE]
GO

/****** Object:  StoredProcedure [dbo].[exsp_Process_Exxxxxhe]    Script Date: 12/22/2011 11:21:44 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[exsp_Process_Exxxxxhe]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[exsp_Process_Exxxxxhe]
GO

USE [EXXXXXHE]
GO

/****** Object:  StoredProcedure [dbo].[exsp_Process_Exxxxxhe]    Script Date: 12/22/2011 11:21:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- =============================================
-- Author:		ZY
-- Create date: Dec 1, 2011
-- Description:	Converted from Will's Access VBA
-- =============================================
CREATE PROCEDURE [dbo].[exsp_Process_Exxxxxhe] 
	-- Add the parameters for the stored procedure here
	@inContract_Number varchar(12) = NULL
	--,@inProd_Month Datetime
	--,@inAcct_Month Datetime
	--,@Cursor_Count Int Output 
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

print 'start exsp_Process_Exxxxxhe for ' + @inContract_Number

-- declare variables for current rows
declare 
@c_Owner_Contract_Number Varchar(12),
@c_Accounting_Month datetime,
@c_Production_Month datetime,
@c_StationId Varchar(10),
@c_ContractNumber Varchar(12),
@c_AcctMonth datetime,
@c_RecoveryMode bit,
@c_ProcessFlag bit,
@c_PlantFuel Float,
@c_CustomerName Varchar(100),
@c_NGPriceIndex int,
@c_NGLPriceIndex int,
@c_ContractH2OBasis Varchar(1),
@c_PriceNG Float,
@c_PriceNGL_C2Purity Float,
@c_PriceNGL_C2 Float,
@c_PriceNGL_C3 Float,
@c_PriceNGL_IC4 Float,
@c_PriceNGL_NC4 Float,
@c_PriceNGL_IC5 Float,
@c_PriceNGL_NC5 Float,
@c_PriceNGL_C6Plus Float,
@c_PlantRecTerm Varchar(24),
@c_BeginDate datetime,
@c_EndDate datetime,
@c_Description Varchar(255),
@c_ProcessGas bit,
@c_BypassPct Float,
@c_RecC2Pct Float,
@c_RecC3Pct Float,
@c_ReciC4Pct Float,
@c_RecnC4Pct Float,
@c_ReciC5Pct Float,
@c_RecnC5Pct Float,
@c_RecC6Pct Float,
@c_RejC2Pct Float,
@c_RejC3Pct Float,
@c_RejiC4Pct Float,
@c_RejnC4Pct Float,
@c_RejiC5Pct Float,
@c_RejnC5Pct Float,
@c_RejC6Pct Float,
@c_GatheringFee Float,
@c_CompFee Float,
@c_ProcessingFee Float,
@c_OtherFee Float,
@c_C2TnFCharge Float,
@c_C3PlusTnFCharge Float,
@c_FnECharge Float,
@c_BTURequired int,
@c_Stages_Of_Compression  numeric(10,0),
@c_MeasurementBasis Varchar(3),
@c_Dry_Contract_Btu  numeric(10,3),
@c_GrossMmbtu  numeric(22,10),
@c_GrossVolume  numeric(22,10),
@c_Compression_Fuel_Percent  numeric(10,5),
@c_Compression_Rate  numeric(10,5),
@c_System_Fuel_Percent  numeric(10,5),
@c_Gathering_Transmission_Rate  numeric(10,5),
@c_Btu_Dry numeric(10,3),
@c_Nitrogen_MP  numeric(8,4),
@c_Co2_MP  numeric(8,4),
@c_Methane_MP  numeric(8,4),
@c_Ethane_MP  numeric(8,4),
@c_Propane_MP  numeric(8,4),
@c_Isobutane_MP  numeric(8,4),
@c_NButane_MP  numeric(8,4),
@c_Isopentane_MP  numeric(8,4),
@c_NPentane_MP  numeric(8,4),
@c_HexanePlus_MP  numeric(8,4),
@c_FlowingTemp Float,
@c_FlowingPress Float,
@c_DataProcessStatus Varchar(255),
@c_nProcessError bit,
@c_nGenerateNGLStatement bit,
@c_BillingDetail_ID int,

	@ErrorMsg Varchar(255),
	@UpdateBDSQL1 VARCHAR(MAX),
	@UpdateBDSQL2 VARCHAR(MAX),
	@Update_count int,
-- variables for debugging only
	@debug_var_int int,
	@debug_var_varchar varchar(255),
	@debug_var_float float
-- end variables for debugging only
SET @Update_count =0

if UPPER(@inContract_Number) = 'ALL' or @inContract_Number is NULL
	begin
		Declare Column_Cursor Cursor SCROLL--FORWARD_ONLY -- 
		FOR SELECT * from [dbo].[vBillingDetail_b4DataProcess] order by stationid
	end
else
	begin
		Declare Column_Cursor Cursor SCROLL--FORWARD_ONLY -- 
		FOR SELECT * from [dbo].[vBillingDetail_b4DataProcess] where Owner_Contract_Number = @inContract_Number order by stationid
	end

Open Column_Cursor
Fetch Next From Column_Cursor into 
	@c_Owner_Contract_Number ,
	@c_Accounting_Month ,
	@c_Production_Month ,
	@c_StationId ,
	@c_ContractNumber ,
	@c_AcctMonth ,
	@c_RecoveryMode ,
	@c_ProcessFlag ,
	@c_PlantFuel ,
	@c_CustomerName ,
	@c_NGPriceIndex ,
	@c_NGLPriceIndex ,
	@c_ContractH2OBasis ,
	@c_PriceNG ,
	@c_PriceNGL_C2Purity ,
	@c_PriceNGL_C2 ,
	@c_PriceNGL_C3 ,
	@c_PriceNGL_IC4 ,
	@c_PriceNGL_NC4 ,
	@c_PriceNGL_IC5 ,
	@c_PriceNGL_NC5 ,
	@c_PriceNGL_C6Plus ,
	@c_PlantRecTerm ,
	@c_BeginDate ,
	@c_EndDate ,
	@c_Description ,
	@c_ProcessGas ,
	@c_BypassPct ,
	@c_RecC2Pct ,
	@c_RecC3Pct ,
	@c_ReciC4Pct ,
	@c_RecnC4Pct ,
	@c_ReciC5Pct ,
	@c_RecnC5Pct ,
	@c_RecC6Pct ,
	@c_RejC2Pct ,
	@c_RejC3Pct ,
	@c_RejiC4Pct ,
	@c_RejnC4Pct ,
	@c_RejiC5Pct ,
	@c_RejnC5Pct ,
	@c_RejC6Pct ,
	@c_GatheringFee ,
	@c_CompFee ,
	@c_ProcessingFee ,
	@c_OtherFee ,
	@c_C2TnFCharge ,
	@c_C3PlusTnFCharge ,
	@c_FnECharge ,
	@c_BTURequired ,
	@c_Stages_Of_Compression ,
	@c_MeasurementBasis ,
	@c_Dry_Contract_Btu ,
	@c_GrossMmbtu ,
	@c_GrossVolume ,
	@c_Compression_Fuel_Percent ,
	@c_Compression_Rate ,
	@c_System_Fuel_Percent ,
	@c_Gathering_Transmission_Rate ,
	@c_Btu_Dry ,
	@c_Nitrogen_MP ,
	@c_Co2_MP ,
	@c_Methane_MP ,
	@c_Ethane_MP ,
	@c_Propane_MP ,
	@c_Isobutane_MP ,
	@c_NButane_MP ,
	@c_Isopentane_MP ,
	@c_NPentane_MP ,
	@c_HexanePlus_MP ,
	@c_FlowingTemp ,
	@c_FlowingPress ,
	@c_DataProcessStatus ,
	@c_nProcessError ,
	@c_nGenerateNGLStatement ,
	@c_BillingDetail_ID
While @@FETCH_STATUS=0
BEGIN
	-- ** declare variables for Exxxxxhe calculations
	declare @zStatusMsg	varchar(255)
			,@bErrFlag	bit
			,@dFWV	float
			,@dAsDelMMBTU	float
			,@dAsDelMCF	float
			,@dDryToAsDelMMBTU	float
			,@dAsDelBTU	float
			,@dNetGatheredAsDelMMBTU	float
			,@dNetGatheredMCF	float
			,@dPriceNG	float
			,@dPriceNGLs_C2	float
			,@dPriceNGLs_C3	float
			,@dPriceNGLs_iC4	float
			,@dPriceNGLs_nC4	float
			,@dPriceNGLs_iC5	float
			,@dPriceNGLs_nC5	float
			,@dPriceNGLs_C6	float
			,@dGathFee	float
			,@dGatheringValue	float
			,@dCompFee	float
			,@dCompressionValue	float
			,@dCompressionFuelMCF	float
			,@dCompressionFuelMMBtu	float
			,@dSystemFuelMCF	float
			,@dSystemFuelMMBtu	float
			,@dDelToPlantMCF	float --result will be saved as INT, but calculations need to be float
			,@dDelToPlantMMBtu	float --result will be saved as INT, but calculations need to be float
			,@dBypassPct	float
			,@dBypassMMBtu	float
			,@dBypassMCF	float
			,@dProcFee	float
			,@dProcessFeeValue	float
			,@dOtherFee	float
			,@dOtherFeeValue	float
			,@dTtlGnPValue	float
			,@dNetNGLValue	float
			,@bRecMode	varchar(12)
			,@dC1MP_AsDel	float
			,@dC2MP_AsDel	float
			,@dC3MP_AsDel	float
			,@diC4MP_AsDel	float
			,@dnC4MP_AsDel	float
			,@diC5MP_AsDel	float
			,@dnC5MP_AsDel	float
			,@dC6MP_AsDel	float
			,@dN2MP_AsDel	float
			,@dCO2MP_AsDel	float
			,@dH2OMP	float
			,@dTotalMP	float
			,@dGPM_C2	float
			,@dTheoGals_C2	float
			,@dRecoveries_C2	float
			,@dRecoveredGals_C2	float
			,@dNGLValue_C2	float
			,@dGPM_C3	float
			,@dTheoGals_C3	float
			,@dRecoveries_C3	float
			,@dRecoveredGals_C3	float
			,@dNGLValue_C3	float
			,@dGPM_iC4	float
			,@dTheoGals_iC4	float
			,@dRecoveries_iC4	float
			,@dRecoveredGals_iC4	float
			,@dNGLValue_iC4	float
			,@dGPM_nC4	float
			,@dTheoGals_nC4	float
			,@dRecoveries_nC4	float
			,@dRecoveredGals_nC4	float
			,@dNGLValue_nC4	float
			,@dGPM_iC5	float
			,@dTheoGals_iC5	float
			,@dRecoveries_iC5	float
			,@dRecoveredGals_iC5	float
			,@dNGLValue_iC5	float
			,@dGPM_nC5	float
			,@dTheoGals_nC5	float
			,@dRecoveries_nC5	float
			,@dRecoveredGals_nC5	float
			,@dNGLValue_nC5	float
			,@dGPM_C6	float
			,@dTheoGals_C6	float
			,@dRecoveries_C6	float
			,@dRecoveredGals_C6	float
			,@dNGLValue_C6	float
			,@dTtlGPMs	float
			,@dTtlTheoGals	float
			,@dTtlRecoveredGals	float
			,@dTtlNGLValue	float
			,@dzFactor	float
			,@dShrinkMMBtu_C2	float
			,@dShrinkMMBtu_C3	float
			,@dShrinkMMBtu_iC4	float
			,@dShrinkMMBtu_nC4	float
			,@dShrinkMMBtu_iC5	float
			,@dShrinkMMBtu_nC5	float
			,@dShrinkMMBtu_C6	float
			,@dTtlShrinkMMBtu	float
			,@dPlantFuelPct	float
			,@dPlantFuelMMBtu	float
			,@dPTRMMBtu	float
			,@dPlantResidueMMBtu	float
			,@bGenNGLStatement	bit
	-- ** end variables declaration for Exxxxxhe calculations
	Set @ErrorMsg = @c_StationId
	if @c_PriceNG IS NULL 
	begin
		Set @ErrorMsg =  @ErrorMsg + ': No NG Price'
	end
	if @c_PriceNGL_C2 IS NULL
	begin
		Set @ErrorMsg =  @ErrorMsg + ': No NGL Price'
	end
	if @c_PlantRecTerm IS NULL
	begin
		Set @ErrorMsg =  @ErrorMsg + ': No PlantRecTerm'
	end
	if @c_Methane_MP IS NULL
	begin
		Set @ErrorMsg =  @ErrorMsg + ': No Mole Percent Data'
	end
	
	if	@c_PriceNG IS NOT NULL and @c_PriceNGL_C2 IS NOT NULL and 
		@c_PlantRecTerm IS NOT NULL and @c_Methane_MP IS NOT NULL
	begin
	-- for debugging using 1 station only
	if ltrim(@c_StationId) = '03560'
	begin
		SET @UpdateBDSQL1 = ''
		SET @UpdateBDSQL2 = ''


		-- Exxxxxhe Calculations
		SET @dFWV	 = [...calcuation code...]
		SET @dAsDelMMBTU	 = [...calcuation code...]
		SET @dAsDelMCF	 = [...calcuation code...]
		SET @dDryToAsDelMMBTU	 = [...calcuation code...]
		SET @dAsDelBTU	= [...calcuation code...]
		SET @dPriceNG	 = [...calcuation code...]
		SET @dPriceNGLs_C2	 = [...calcuation code...]

		[[...calcuation code... for the rest of the @dxxxxx variables]

		SET @dPlantFuelMMBtu	 =  [...calcuation code...]
		SET @dPTRMMBtu	 = [...calcuation code...]
		SET @dPlantResidueMMBtu	 = [...calcuation code...]

		-- end Exxxxxhe Calculations
		SET @Update_count = @Update_count + 1
		SET @UpdateBDSQL1 =  'UPDATE [dbo].[BillingDetail] set measdata_key = ''Processed'' ' + 
			', nFWV = ' + str(@dFWV, 25,17) + 
			', nAsDelMMBTU = ' + str(@dAsDelMMBTU, 25,17) + 
			', nAsDelMCF = ' + str(@dAsDelMCF, 25,17) + 
			', nDryToAsDelMMBTU = ' + str(@dDryToAsDelMMBTU, 25,17) + 
			', nAsDelBTU = ' + str(@dAsDelBTU, 25,17) + 
			', nNetGthMMBTU = ' + str(@dNetGatheredAsDelMMBTU, 25,17) + 
			', nNetGthMCF = ' + str(@dNetGatheredMCF, 25,17) + 
			', nNatGasPrice = ' + str(@dPriceNG, 25,17) + 
			', nC2Price = ' + str(@dPriceNGLs_C2, 25,17) + 
			', nC3Price = ' + str(@dPriceNGLs_C3, 25,17) + 
			', niC4Price = ' + str(@dPriceNGLs_iC4, 25,17) + 
			', nnc4Price = ' + str(@dPriceNGLs_nC4, 25,17) + 
			', niC5Price = ' + str(@dPriceNGLs_iC5, 25,17) + 
			', nnC5Price = ' + str(@dPriceNGLs_nC5, 25,17) + 
			', nC6Price = ' + str(@dPriceNGLs_C6, 25,17) + 
			', nGatheringFee = ' + str(@dGathFee, 25,17) + 
			', nGatheringValue = ' + str(@dGatheringValue, 25,17) + 
			', nCompressionFee = ' + str(@dCompFee, 25,17) + 
			', nCompressionValue = ' + str(@dCompressionValue, 25,17) + 
			', nCompressorFuelMCF = ' + str(@dCompressionFuelMCF, 25,17) + 
			', nCompressorFuelMMBtu = ' + str(@dCompressionFuelMMBtu, 25,17) + 
			', nSystemFuelMCF = ' + str(@dSystemFuelMCF, 25,17) + 
			', nSystemFuelMMBTU = ' + str(@dSystemFuelMMBtu, 25,17) + 
			', nDeliveredToPlantMCF = ' + str(@dDelToPlantMCF, 10,2) + 
			', nDeliveredToPlantMMBTU = ' + str(@dDelToPlantMMBtu, 10,2) + 
			', nBypassPct = ' + str(@dBypassPct, 25,17) + 
			', nBypassMMBtu = ' + str(@dBypassMMBtu, 25,17) + 
			', nBypassMCF = ' + str(@dBypassMCF, 25,17) + 
			', nProcessingFee = ' + str(@dProcFee, 25,17) + 
			', nProcessingValue = ' + str(@dProcessFeeValue, 25,17) + 
			', nOtherFee = ' + str(@dOtherFee, 25,17) + 
			', nOtherValue = ' + str(@dOtherFeeValue, 25,17) + 
			', nTotalGnPValue = ' + str(@dTtlGnPValue, 25,17) + 
			', nNetNGLSettlementValue = ' + str(@dNetNGLValue, 25,17) --+
		SET @UpdateBDSQL2 =   
			', nRecMode = ''' + @bRecMode + '''' +
			', nC1MP = ' + str(@dC1MP_AsDel, 25,17) + 
			', nC2MP = ' + str(@dC2MP_AsDel, 25,17) + 
			', nC3MP = ' + str(@dC3MP_AsDel, 25,17) + 
			', niC4MP = ' + str(@diC4MP_AsDel, 25,17) + 
			', nnC4MP = ' + str(@dnC4MP_AsDel, 25,17) + 
			', niC5MP = ' + str(@diC5MP_AsDel, 25,17) + 
			', nnC5MP = ' + str(@dnC5MP_AsDel, 25,17) + 
			', nC6MP = ' + str(@dC6MP_AsDel, 25,17) + 
			', nN2MP = ' + str(@dN2MP_AsDel, 25,17) + 
			', nCO2MP = ' + str(@dCO2MP_AsDel, 25,17) + 
			', nH2OMP = ' + str(@dH2OMP, 25,17) + 
			', nTotalMP = ' + str(@dTotalMP, 25,17) + 
			', nC2GPM = ' + str(@dGPM_C2, 25,17) + 
			', nC2TheoGals = ' + str(@dTheoGals_C2, 25,17) + 
			', nC2RecPct = ' + str(@dRecoveries_C2, 25,17) + 
			', nC2RecGals = ' + str(@dRecoveredGals_C2, 25,17) + 
			', nC2SettlementPrice = ' + str(@dPriceNGLs_C2, 25,17) + 
			', nC2Value = ' + str(@dNGLValue_C2, 25,17) + 
			', nC3GPM = ' + str(@dGPM_C3, 25,17) + 
			', nC3TheoGals = ' + str(@dTheoGals_C3, 25,17) + 
			', nC3RecPct = ' + str(@dRecoveries_C3, 25,17) + 
			', nC3RecGals = ' + str(@dRecoveredGals_C3, 25,17) + 
			', nC3SettlementPrice = ' + str(@dPriceNGLs_C3, 25,17) + 
			', nC3Value = ' + str(@dNGLValue_C3, 25,17) + 
			', niC4GPM = ' + str(@dGPM_iC4, 25,17) + 
			', niC4TheoGals = ' + str(@dTheoGals_iC4, 25,17) + 
			', niC4RecPct = ' + str(@dRecoveries_iC4, 25,17) + 
			', niC4RecGals = ' + str(@dRecoveredGals_iC4, 25,17) + 
			', niC4SettlementPrice = ' + str(@dPriceNGLs_iC4, 25,17) + 
			', niC4Value = ' + str(@dNGLValue_iC4, 25,17) + 
			', nnC4GPM = ' + str(@dGPM_nC4, 25,17) + 
			', nnC4TheoGals = ' + str(@dTheoGals_nC4, 25,17) + 
			', nnC4RecPct = ' + str(@dRecoveries_nC4, 25,17) + 
			', nnC4RecGals = ' + str(@dRecoveredGals_nC4, 25,17) + 
			', nnC4SettlementPrice = ' + str(@dPriceNGLs_nC4, 25,17) + 
			', nnC4Value = ' + str(@dNGLValue_nC4, 25,17) + 
			', niC5GPM = ' + str(@dGPM_iC5, 25,17) + 
			', niC5TheoGals = ' + str(@dTheoGals_iC5, 25,17) + 
			', niC5RecPct = ' + str(@dRecoveries_iC5, 25,17) + 
			', niC5RecGals = ' + str(@dRecoveredGals_iC5, 25,17) + 
			', niC5SettlementPrice = ' + str(@dPriceNGLs_iC5, 25,17) + 
			', niC5Value = ' + str(@dNGLValue_iC5, 25,17) + 
			', nnC5GPM = ' + str(@dGPM_nC5, 25,17) + 
			', nnC5TheoGals = ' + str(@dTheoGals_nC5, 25,17) + 
			', nnC5RecPct = ' + str(@dRecoveries_nC5, 25,17) + 
			', nnC5RecGals = ' + str(@dRecoveredGals_nC5, 25,17) + 
			', nnC5SettlementPrice = ' + str(@dPriceNGLs_nC5, 25,17) + 
			', nnC5Value = ' + str(@dNGLValue_nC5, 25,17) + 
			', nC6GPM = ' + str(@dGPM_C6, 25,17) + 
			', nC6TheoGals = ' + str(@dTheoGals_C6, 25,17) + 
			', nC6RecPct = ' + str(@dRecoveries_C6, 25,17) + 
			', nC6RecGals = ' + str(@dRecoveredGals_C6, 25,17) + 
			', nC6SettlementPrice = ' + str(@dPriceNGLs_C6, 25,17) + 
			', nC6Value = ' + str(@dNGLValue_C6, 25,17) + 
			', nTtlGPM = ' + str(@dTtlGPMs, 25,17) + 
			', nTtlTheoGals = ' + str(@dTtlTheoGals, 25,17) + 
			', nTtlRecGals = ' + str(@dTtlRecoveredGals, 25,17) + 
			', nTtlNGLValue = ' + str(@dTtlNGLValue, 25,17) + 
			', nZFactor = ' + str(@dzFactor, 25,17) + 
			', nC2ShrinkMMBtu = ' + str(@dShrinkMMBtu_C2, 25,17) + 
			', nC3ShrinkMMBtu = ' + str(@dShrinkMMBtu_C3, 25,17) + 
			', niC4ShrinkMMBtu = ' + str(@dShrinkMMBtu_iC4, 25,17) + 
			', nnC4ShrinkMMBtu = ' + str(@dShrinkMMBtu_nC4, 25,17) + 
			', niC5ShrinkMMBtu = ' + str(@dShrinkMMBtu_iC5, 25,17) + 
			', nnC5ShrinkMMBtu = ' + str(@dShrinkMMBtu_nC5, 25,17) + 
			', nC6ShrinkMMBtu = ' + str(@dShrinkMMBtu_C6, 25,17) + 
			', nTtlShrinkMMBtu = ' + str(@dTtlShrinkMMBtu, 25,17) + 
			', nPlantFuelPct = ' + str(@dPlantFuelPct, 25,17) + 
			', nPlantFuelMMBtu = ' + str(@dPlantFuelMMBtu, 25,17) + 
			', nPTRMMBtu = ' + str(@dPTRMMBtu, 25,17) + 
			', nResidueMMBtu = ' + str(@dPlantResidueMMBtu, 25,17) + 
			' WHERE ID = ' + str(@c_BillingDetail_ID,10,0)
		print str(@Update_count) +'-'+ @c_StationId + ':- '
--PRINT @UpdateBDSQL1
--PRINT @UpdateBDSQL2
		if @Update_count <= 20 Exec(@UpdateBDSQL1 + @UpdateBDSQL2)  --limit to 20 for debugging
	end
	-- end debugging 
		
	end
	--else
		--Print @ErrorMsg  

--get next row from view
	Fetch Next From Column_Cursor into 
		@c_Owner_Contract_Number ,
		@c_Accounting_Month ,
		@c_Production_Month ,
		@c_StationId ,
		@c_ContractNumber ,
		@c_AcctMonth ,
		@c_RecoveryMode ,
		@c_ProcessFlag ,
		@c_PlantFuel ,
		@c_CustomerName ,
		@c_NGPriceIndex ,
		@c_NGLPriceIndex ,
		@c_ContractH2OBasis ,
		@c_PriceNG ,
		@c_PriceNGL_C2Purity ,
		@c_PriceNGL_C2 ,
		@c_PriceNGL_C3 ,
		@c_PriceNGL_IC4 ,
		@c_PriceNGL_NC4 ,
		@c_PriceNGL_IC5 ,
		@c_PriceNGL_NC5 ,
		@c_PriceNGL_C6Plus ,
		@c_PlantRecTerm ,
		@c_BeginDate ,
		@c_EndDate ,
		@c_Description ,
		@c_ProcessGas ,
		@c_BypassPct ,
		@c_RecC2Pct ,
		@c_RecC3Pct ,
		@c_ReciC4Pct ,
		@c_RecnC4Pct ,
		@c_ReciC5Pct ,
		@c_RecnC5Pct ,
		@c_RecC6Pct ,
		@c_RejC2Pct ,
		@c_RejC3Pct ,
		@c_RejiC4Pct ,
		@c_RejnC4Pct ,
		@c_RejiC5Pct ,
		@c_RejnC5Pct ,
		@c_RejC6Pct  ,
		@c_GatheringFee ,
		@c_CompFee ,
		@c_ProcessingFee ,
		@c_OtherFee ,
		@c_C2TnFCharge ,
		@c_C3PlusTnFCharge ,
		@c_FnECharge ,
		@c_BTURequired ,
		@c_Stages_Of_Compression ,
		@c_MeasurementBasis ,
		@c_Dry_Contract_Btu ,
		@c_GrossMmbtu ,
		@c_GrossVolume ,
		@c_Compression_Fuel_Percent ,
		@c_Compression_Rate ,
		@c_System_Fuel_Percent ,
		@c_Gathering_Transmission_Rate ,
		@c_Btu_Dry ,
		@c_Nitrogen_MP ,
		@c_Co2_MP ,
		@c_Methane_MP ,
		@c_Ethane_MP ,
		@c_Propane_MP ,
		@c_Isobutane_MP ,
		@c_NButane_MP ,
		@c_Isopentane_MP ,
		@c_NPentane_MP ,
		@c_HexanePlus_MP ,
		@c_FlowingTemp ,
		@c_FlowingPress ,
		@c_DataProcessStatus ,
		@c_nProcessError ,
		@c_nGenerateNGLStatement ,
		@c_BillingDetail_ID
END  


CLOSE  Column_Cursor
DEALLOCATE  Column_Cursor

print 'end exsp_Process_Exxxxxhe'
print str(@Update_count) + ' record Processed'

END
GO

UPDATE b
   SET measdata_key = 'Processed'
   , billingdetail COLUMNS = d.columns and calculations
FROM  [dbo].[BillingDetail] b
JOIN  [dbo].[vBillingDetail_b4DataProcess] d
ON b.key = d.key
WHERE Owner_Contract_Number = CASE WHEN @inContract_Number = 'ALL' THEN Owner_Contract_Number
								   WHEN @inContract_Number IS NULL THEN Owner_Contract_Number
								   ELSE @inContract_Number
								   
								   

quote:

---

Originally posted by boogiezy

hmm how do I do the calcuations when some of the values depends on others? for example the calcuated dFWV feeds many other fields, and some are SUM of 6 new values...

---

UPDATE MyTable
SET @SomeVariable = Col1 + Col2,
    @SomeOtherVariable = @SomeVariable + Col3,
    Col4 = @SomeOtherVariable,
    ...

quote:

---

Originally posted by X002548

You can't do that in a select

---

quote:

---

Originally posted by boogiezy

"UPDATE MyTable SET @SomeVariable = Col1 + Col2"
doesn't make sense to me either. Don't we have to use a column name where "@SomeVariable" is?

---

       SET
        { column_name = { expression | DEFAULT | NULL }
          | { udt_column_name.{ { property_name = expression
                                | field_name = expression }
                                | method_name ( argument [ ,...n ] )
                              }
          }
          | column_name { .WRITE ( expression , @Offset , @Length ) }
          | @variable = expression
          | @variable = column = expression
          | column_name { += | -= | *= | /= | %= | &= | ^= | |= } expression
          | @variable { += | -= | *= | /= | %= | &= | ^= | |= } expression
          | @variable = column { += | -= | *= | /= | %= | &= | ^= | |= } expression
        } [ ,...n ]

quote:

---

Originally posted by X002548

you can do that????
Another undocumented "Feature"

---