Clustered PK Constr fails to create on big table

kapluni · November 23rd, 2005, 12:55 PM

I am trying to create a primary key constraint on a large table (see below). The table gets created correctly, but when I try to create the constraint with an ALTER TABLE statement, I get an error. I have found a couple of workarounds, but I really need to be able to create the constraint with the ALTER TABLE clause rather than inline, and it does need to be clustered. Thanks a lot for the help!

Ilya

Problem Description
SQL Server fails to create primary key constraint using an "ALTER TABLE" statement on a table where the maximum possible size of a single row exceeds '''86780''' bytes (reported by a warning).

MS SQL Server 2000 Version: 8.00.2039(SP4)

Workarounds
The problem is fixed if the constraint is made '''NONCLUSTERED'''
The problem is also fixed if the constraint is defined inline with the column definition -] in that case the constraint remains clustered

Error Message

Code:

Warning: The table 'T_SPACEUSEAGREEMENT' has been created but its maximum row size (86780) exceeds the maximum number of bytes per row (8060). 
INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Server: Msg 8618, Level 16, State 2, Line 1

Warning: The query processor could not produce a query plan from the optimizer because the total length of all the columns in the GROUP 
BY or ORDER BY clause exceeds 8000 bytes.

Server: Msg 1750, Level 16, State 1, Line 3
Could not create constraint. See previous errors.

SQL Code
[code]
CREATE TABLE [T_SPACEUSEAGREEMENT] (
    [spec_id] [numeric](20, 0) NOT NULL ,
    [Sys_projectid] [numeric](20, 0) NULL ,
    [Sys_objectstate] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [Sys_objectId] [numeric](20, 0) NULL ,
    [Sys_guiid] [numeric](20, 0) NULL ,
    [Sys_ReviewStatus] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [Sys_PriorState] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_Security] [numeric](32, 12) NULL ,
    [ce_Security_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_PropertyTaxes] [numeric](32, 12) NULL ,
    [ce_PropertyTaxes_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_Insurance] [numeric](32, 12) NULL ,
    [ce_Insurance_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_Electricity] [numeric](32, 12) NULL ,
    [ce_Electricity_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_UtilitiesBase] [numeric](32, 12) NULL ,
    [ce_UtilitiesBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_SecurityBase] [numeric](32, 12) NULL ,
    [ce_SecurityBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_Storage] [numeric](32, 12) NULL ,
    [ce_Storage_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_StorageBase] [numeric](32, 12) NULL ,
    [ce_StorageBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_RepairMaintenance] [numeric](32, 12) NULL ,
    [ce_RepairMaintenance_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_RepairMaintenance2] [numeric](32, 12) NULL ,
    [ce_RepairMaintenance2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_PropertyTaxesBase] [numeric](32, 12) NULL ,
    [ce_PropertyTaxesBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_PropServFee] [numeric](32, 12) NULL ,
    [ce_PropServFee_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_PropServFeeBase] [numeric](32, 12) NULL ,
    [ce_PropServFeeBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_Parking] [numeric](32, 12) NULL ,
    [ce_Parking_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_ParkingBase] [numeric](32, 12) NULL ,
    [ce_ParkingBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_InsuranceBase] [numeric](32, 12) NULL ,
    [ce_InsuranceBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_ElectricityBase] [numeric](32, 12) NULL ,
    [ce_ElectricityBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_CAM] [numeric](32, 12) NULL ,
    [ce_CAM_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_CAMBase] [numeric](32, 12) NULL ,
    [ce_CAMBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_Janitorial] [numeric](32, 12) NULL ,
    [ce_Janitorial_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_JanitorialBase] [numeric](32, 12) NULL ,
    [ce_JanitorialBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_OtherExp] [numeric](32, 12) NULL ,
    [ce_OtherExp_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_OtherExpBase] [numeric](32, 12) NULL ,
    [ce_OtherExpBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_Security] [numeric](32, 12) NULL ,
    [le_Security_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_RepairMaintenance] [numeric](32, 12) NULL ,
    [le_RepairMaintenance_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_PropServFee] [numeric](32, 12) NULL ,
    [le_PropServFee_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_PropertyTaxes] [numeric](32, 12) NULL ,
    [le_PropertyTaxes_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_Parking] [numeric](32, 12) NULL ,
    [le_Parking_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_OtherExpenses] [numeric](32, 12) NULL ,
    [le_OtherExpenses_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_Janitorial] [numeric](32, 12) NULL ,
    [le_Janitorial_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_Insurance] [numeric](32, 12) NULL ,
    [le_Insurance_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_Electricity] [numeric](32, 12) NULL ,
    [le_Electricity_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_Utilities] [numeric](32, 12) NULL ,
    [le_Utilities_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_CAM] [numeric](32, 12) NULL ,
    [le_CAM_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_Storage] [numeric](32, 12) NULL ,
    [le_Storage_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_UtilitiesBase] [numeric](32, 12) NULL ,
    [le_UtilitiesBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_StorageBase] [numeric](32, 12) NULL ,
    [le_StorageBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_SecurityBase] [numeric](32, 12) NULL ,
    [le_SecurityBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_RepairMaintenance2] [numeric](32, 12) NULL ,
    [le_RepairMaintenance2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_PropertyTaxesBase] [numeric](32, 12) NULL ,
    [le_PropertyTaxesBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_PropServFeeBase] [numeric](32, 12) NULL ,
    [le_PropServFeeBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_ParkingBase] [numeric](32, 12) NULL ,
    [le_ParkingBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_OtherExpensesBase] [numeric](32, 12) NULL ,
    [le_OtherExpensesBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_JanitorialBase] [numeric](32, 12) NULL ,
    [le_JanitorialBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_InsuranceBase] [numeric](32, 12) NULL ,
    [le_InsuranceBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_ElectricityBase] [numeric](32, 12) NULL ,
    [le_ElectricityBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_CAMBase] [numeric](32, 12) NULL ,
    [le_CAMBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_UtilitiesEIR] [numeric](32, 12) NULL ,
    [le_UtilitiesEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_StorageEIR] [numeric](32, 12) NULL ,
    [le_StorageEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_SecurityEIR] [numeric](32, 12) NULL ,
    [le_SecurityEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_RepairMaintEIR] [numeric](32, 12) NULL ,
    [le_RepairMaintEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_PropServFeeEIR] [numeric](32, 12) NULL ,
    [le_PropServFeeEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_PropertyTaxesEIR] [numeric](32, 12) NULL ,
    [le_PropertyTaxesEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_PassThrDate] [numeric](32, 0) NULL ,
    [le_ParkingEIR] [numeric](32, 12) NULL ,
    [le_ParkingEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_OtherExpensesEIR] [numeric](32, 12) NULL ,
    [le_OtherExpensesEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_JanitorialEIR] [numeric](32, 12) NULL ,
    [le_JanitorialEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_InsuranceEIR] [numeric](32, 12) NULL ,
    [le_InsuranceEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_ElectricityEIR] [numeric](32, 12) NULL ,
    [le_ElectricityEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_CAMEIR] [numeric](32, 12) NULL ,
    [le_CAMEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_BasePassEscRate] [numeric](32, 12) NULL ,
    [le_BasePassEscRate_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_BaseExpenseAmt] [numeric](32, 12) NULL ,
    [le_BaseExpenseAmt_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [le_BaseExpenseAmtBase] [numeric](32, 12) NULL ,
    [le_BaseExpenseAmtBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_WorkStations] [numeric](32, 12) NULL ,
    [lt_WorkStations_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_TotalRentable] [numeric](32, 12) NULL ,
    [lt_TotalRentable_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_TotalLeaseRentable] [numeric](32, 12) NULL ,
    [lt_TotalLeaseRentable_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_TIAllowance] [numeric](32, 12) NULL ,
    [lt_TIAllowance_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_ThirdEscalationDa] [numeric](32, 0) NULL ,
    [lt_ThirdEscalationAmt] [numeric](32, 12) NULL ,
    [lt_ThirdEscalationAmt_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_SiteLocation] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_SecondEscalationD] [numeric](32, 0) NULL ,
    [lt_SecondEscalationA] [numeric](32, 12) NULL ,
    [lt_SecondEscalationA_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_ParkingSpaces] [numeric](32, 12) NULL ,
    [lt_ParkingSpaces_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_OwnershipTransfer] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_LeaseType] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_LeaseTypeObjId] [numeric](20, 0) NULL ,
    [lt_LeaseTerm] [numeric](32, 12) NULL ,
    [lt_LeaseTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_LeaseRentableOther] [numeric](32, 12) NULL ,
    [lt_LeaseRentableOther_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_LeaseRentable] [numeric](32, 12) NULL ,
    [lt_LeaseRentable_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_Incentives] [numeric](32, 12) NULL ,
    [lt_Incentives_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_Headcount] [numeric](32, 12) NULL ,
    [lt_Headcount_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_FourthEscalationD] [numeric](32, 0) NULL ,
    [lt_FourthEscalationA] [numeric](32, 12) NULL ,
    [lt_FourthEscalationA_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_FirstEscalationDa] [numeric](32, 0) NULL ,
    [lt_FirstEscalationAmt] [numeric](32, 12) NULL ,
    [lt_FirstEscalationAmt_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_FifthEscalationDa] [numeric](32, 0) NULL ,
    [lt_FifthEscalationAmt] [numeric](32, 12) NULL ,
    [lt_FifthEscalationAmt_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_ExpirationDate] [numeric](32, 0) NULL ,
    [lt_EstPropertyValue] [numeric](32, 12) NULL ,
    [lt_EstPropertyValue_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_Concessions] [numeric](32, 12) NULL ,
    [lt_Concessions_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_CommencementDate] [numeric](32, 0) NULL ,
    [lt_BrokerageCommissi] [numeric](32, 12) NULL ,
    [lt_BrokerageCommissi_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_BaseRentOther] [numeric](32, 12) NULL ,
    [lt_BaseRentOther_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_BaseRentBlend] [numeric](32, 12) NULL ,
    [lt_BaseRentBlend_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_BaseRent] [numeric](32, 12) NULL ,
    [lt_BaseRent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_BaseAnnualEsc] [numeric](32, 12) NULL ,
    [lt_BaseAnnualEsc_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_BargainPurchase] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_Writeoffs] [numeric](32, 12) NULL ,
    [br_Writeoffs_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_WiringRemoval] [numeric](32, 12) NULL ,
    [br_WiringRemoval_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_WiringBuildout] [numeric](32, 12) NULL ,
    [br_WiringBuildout_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_TechnologyExp] [numeric](32, 12) NULL ,
    [br_TechnologyExp_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_TechnologyCap] [numeric](32, 12) NULL ,
    [br_TechnologyCap_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_SignageRemoval] [numeric](32, 12) NULL ,
    [br_SignageRemoval_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_SatDishRemoval] [numeric](32, 12) NULL ,
    [br_SatDishRemoval_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_RelocationExpenses] [numeric](32, 12) NULL ,
    [br_RelocationExpenses_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_RelocationDate] [numeric](32, 0) NULL ,
    [br_ProfServiceFee] [numeric](32, 12) NULL ,
    [br_ProfServiceFee_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_OtherCosts] [numeric](32, 12) NULL ,
    [br_OtherCosts_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_MovingAllowance] [numeric](32, 12) NULL ,
    [br_MovingAllowance_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_LeaseholdImprovem] [numeric](32, 12) NULL ,
    [br_LeaseholdImprovem_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_LandCost] [numeric](32, 12) NULL ,
    [br_LandCost_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_FFELiquidation] [numeric](32, 12) NULL ,
    [br_FFELiquidation_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_FFE] [numeric](32, 12) NULL ,
    [br_FFE_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_Cleanup] [numeric](32, 12) NULL ,
    [br_Cleanup_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_BuildoutDate] [numeric](32, 0) NULL ,
    [br_CleanupBase] [numeric](32, 12) NULL ,
    [br_CleanupBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_FFEBase] [numeric](32, 12) NULL ,
    [br_FFEBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_FFELiquidationBase] [numeric](32, 12) NULL ,
    [br_FFELiquidationBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_LandCostBase] [numeric](32, 12) NULL ,
    [br_LandCostBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_LeaseholdImprovem2] [numeric](32, 12) NULL ,
    [br_LeaseholdImprovem2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_MovingAllowanceBa] [numeric](32, 12) NULL ,
    [br_MovingAllowanceBa_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_OtherCostsBase] [numeric](32, 12) NULL ,
    [br_OtherCostsBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_ProfServiceFeeBase] [numeric](32, 12) NULL ,
    [br_ProfServiceFeeBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_BaseRentBlendBase] [numeric](32, 12) NULL ,
    [lt_BaseRentBlendBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_BaseRentOtherBase] [numeric](32, 12) NULL ,
    [lt_BaseRentOtherBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_RelocationExpense] [numeric](32, 12) NULL ,
    [br_RelocationExpense_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_SatDishRemovalBase] [numeric](32, 12) NULL ,
    [br_SatDishRemovalBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_EstPropertyValueB] [numeric](32, 12) NULL ,
    [lt_EstPropertyValueB_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_SignageRemovalBase] [numeric](32, 12) NULL ,
    [br_SignageRemovalBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_TechnologyCapBase] [numeric](32, 12) NULL ,
    [br_TechnologyCapBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_TechnologyExpBase] [numeric](32, 12) NULL ,
    [br_TechnologyExpBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_WiringBuildoutBase] [numeric](32, 12) NULL ,
    [br_WiringBuildoutBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_WiringRemovalBase] [numeric](32, 12) NULL ,
    [br_WiringRemovalBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_WriteoffsBase] [numeric](32, 12) NULL ,
    [br_WriteoffsBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_BaseRentBase] [numeric](32, 12) NULL ,
    [lt_BaseRentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_FifthEscalationAm] [numeric](32, 12) NULL ,
    [lt_FifthEscalationAm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_FirstEscalationAm] [numeric](32, 12) NULL ,
    [lt_FirstEscalationAm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_FourthEscalationA2] [numeric](32, 12) NULL ,
    [lt_FourthEscalationA2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_IncentivesBase] [numeric](32, 12) NULL ,
    [lt_IncentivesBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_MasterLeaseRentab] [numeric](32, 12) NULL ,
    [lt_MasterLeaseRentab_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_ThirdEscalationAm] [numeric](32, 12) NULL ,
    [lt_ThirdEscalationAm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_TIAllowanceBase] [numeric](32, 12) NULL ,
    [lt_TIAllowanceBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_SecondEscalationA2] [numeric](32, 12) NULL ,
    [lt_SecondEscalationA2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_SubLeaseExpPassBa] [numeric](32, 12) NULL ,
    [lt_SubLeaseExpPassBa_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [lt_RentCommencementD] [numeric](32, 0) NULL ,
    [br_NetTICost] [numeric](32, 12) NULL ,
    [br_NetTICost_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_NetTICostBase] [numeric](32, 12) NULL ,
    [br_NetTICostBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_WiringDepTax] [numeric](32, 12) NULL ,
    [fp_WiringDepTax_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_WiringDepGAAP] [numeric](32, 12) NULL ,
    [fp_WiringDepGAAP_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_TechnologyDepTax] [numeric](32, 12) NULL ,
    [fp_TechnologyDepTax_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_TechnologyDepGAAP] [numeric](32, 12) NULL ,
    [fp_TechnologyDepGAAP_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_LeaseHoldImpDepTax] [numeric](32, 12) NULL ,
    [fp_LeaseHoldImpDepTax_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_LeaseHoldImpDepGA] [numeric](32, 12) NULL ,
    [fp_LeaseHoldImpDepGA_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_LastDayCFY] [numeric](32, 0) NULL ,
    [fp_FiscalYear] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_FirstDayCFY] [numeric](32, 0) NULL ,
    [fp_FFEDepTax] [numeric](32, 12) NULL ,
    [fp_FFEDepTax_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_FFEDepGAAP] [numeric](32, 12) NULL ,
    [fp_FFEDepGAAP_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_DilepDepGAAP] [numeric](32, 12) NULL ,
    [fp_DilepDepGAAP_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_DilapDepTax] [numeric](32, 12) NULL ,
    [fp_DilapDepTax_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_CorporateTaxRate] [numeric](32, 12) NULL ,
    [fp_CorporateTaxRate_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_BuildingsDepTax] [numeric](32, 12) NULL ,
    [fp_BuildingsDepTax_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_BuildingsDepGAAP] [numeric](32, 12) NULL ,
    [fp_BuildingsDepGAAP_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_BUDiscountRate] [numeric](32, 12) NULL ,
    [fp_BUDiscountRate_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fp_AnalysisDate] [numeric](32, 0) NULL ,
    [ct_FirstEscalationDa] [numeric](32, 0) NULL ,
    [ct_FirstEscalationAmt] [numeric](32, 12) NULL ,
    [ct_FirstEscalationAmt_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_FirstEscalationAm] [numeric](32, 12) NULL ,
    [ct_FirstEscalationAm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_BaseExpenseAmt] [numeric](32, 12) NULL ,
    [ce_BaseExpenseAmt_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_BaseExpenseAmtBase] [numeric](32, 12) NULL ,
    [ce_BaseExpenseAmtBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_ElectricityEIR] [numeric](32, 12) NULL ,
    [ce_ElectricityEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_UtilitiesEIR] [numeric](32, 12) NULL ,
    [ce_UtilitiesEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_JanitorialEIR] [numeric](32, 12) NULL ,
    [ce_JanitorialEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_RepairMaintEIR] [numeric](32, 12) NULL ,
    [ce_RepairMaintEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_CAMEIR] [numeric](32, 12) NULL ,
    [ce_CAMEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_SecurityEIR] [numeric](32, 12) NULL ,
    [ce_SecurityEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_InsuranceEIR] [numeric](32, 12) NULL ,
    [ce_InsuranceEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_PropertyTaxesEIR] [numeric](32, 12) NULL ,
    [ce_PropertyTaxesEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_ParkingEIR] [numeric](32, 12) NULL ,
    [ce_ParkingEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_StorageEIR] [numeric](32, 12) NULL ,
    [ce_StorageEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_OtherExpensesEIR] [numeric](32, 12) NULL ,
    [ce_OtherExpensesEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ce_PropServFeeEIR] [numeric](32, 12) NULL ,
    [ce_PropServFeeEIR_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_SiteLocation] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_TotalRentable] [numeric](32, 12) NULL ,
    [ct_TotalRentable_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_WorkStations] [numeric](32, 12) NULL ,
    [ct_WorkStations_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_ParkingSpaces] [numeric](32, 12) NULL ,
    [ct_ParkingSpaces_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_Headcount] [numeric](32, 12) NULL ,
    [ct_Headcount_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_LeaseRentable] [numeric](32, 12) NULL ,
    [ct_LeaseRentable_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_LeaseRentableOther] [numeric](32, 12) NULL ,
    [ct_LeaseRentableOther_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_BaseRentBlend] [numeric](32, 12) NULL ,
    [ct_BaseRentBlend_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_BaseRentBlendBase] [numeric](32, 12) NULL ,
    [ct_BaseRentBlendBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_BaseRent] [numeric](32, 12) NULL ,
    [ct_BaseRent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_BaseRentBase] [numeric](32, 12) NULL ,
    [ct_BaseRentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_BaseRentOther] [numeric](32, 12) NULL ,
    [ct_BaseRentOther_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_BaseRentOtherBase] [numeric](32, 12) NULL ,
    [ct_BaseRentOtherBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_BaseAnnualEsc] [numeric](32, 12) NULL ,
    [ct_BaseAnnualEsc_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_SignageRemoval] [numeric](32, 12) NULL ,
    [cr_SignageRemoval_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_SignageRemovalBase] [numeric](32, 12) NULL ,
    [cr_SignageRemovalBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_WiringRemoval] [numeric](32, 12) NULL ,
    [cr_WiringRemoval_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_WiringRemovalBase] [numeric](32, 12) NULL ,
    [cr_WiringRemovalBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_Cleanup] [numeric](32, 12) NULL ,
    [cr_Cleanup_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_CleanupBase] [numeric](32, 12) NULL ,
    [cr_CleanupBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_SatDishRemoval] [numeric](32, 12) NULL ,
    [cr_SatDishRemoval_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_SatDishRemovalBase] [numeric](32, 12) NULL ,
    [cr_SatDishRemovalBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_OtherCosts] [numeric](32, 12) NULL ,
    [cr_OtherCosts_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [cr_OtherCostsBase] [numeric](32, 12) NULL ,
    [cr_OtherCostsBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_TotalLeaseRentable] [numeric](32, 12) NULL ,
    [ct_TotalLeaseRentable_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ct_TotalLeaseRentabl] [numeric](32, 12) NULL ,
    [ct_TotalLeaseRentabl_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_TIAllowance] [numeric](32, 12) NULL ,
    [br_TIAllowance_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_TIAllowanceBase] [numeric](32, 12) NULL ,
    [br_TIAllowanceBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TotalPreTaxNPV] [numeric](32, 12) NULL ,
    [fa_TotalPreTaxNPV_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TotalCosts] [numeric](32, 12) NULL ,
    [fa_TotalCosts_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TotalCommitment] [numeric](32, 12) NULL ,
    [fa_TotalCommitment_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TierSavings] [numeric](32, 12) NULL ,
    [fa_TierSavings_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TierSavingsFirst] [numeric](32, 12) NULL ,
    [fa_TierSavingsFirst_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TaxAdjustments] [numeric](32, 12) NULL ,
    [fa_TaxAdjustments_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_SecondFullYear] [numeric](32, 12) NULL ,
    [fa_SecondFullYear_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_ProposedSpaceComm] [numeric](32, 12) NULL ,
    [fa_ProposedSpaceComm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_PreTaxCashFlow] [numeric](32, 12) NULL ,
    [fa_PreTaxCashFlow_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_IncomeRecovery] [numeric](32, 12) NULL ,
    [fa_IncomeRecovery_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_FirstFullYear] [numeric](32, 12) NULL ,
    [fa_FirstFullYear_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_CYPreTaxCashFlow] [numeric](32, 12) NULL ,
    [fa_CYPreTaxCashFlow_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_CYImpact] [numeric](32, 12) NULL ,
    [fa_CYImpact_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_CurrentSpaceCommi] [numeric](32, 12) NULL ,
    [fa_CurrentSpaceCommi_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_BusDiscountRate] [numeric](32, 12) NULL ,
    [fa_BusDiscountRate_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_AfterTaxCashFlow] [numeric](32, 12) NULL ,
    [fa_AfterTaxCashFlow_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_AfterTaxCashFlowB] [numeric](32, 12) NULL ,
    [fa_AfterTaxCashFlowB_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_BusDiscountRateBa] [numeric](32, 12) NULL ,
    [fa_BusDiscountRateBa_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_CYImpactBase] [numeric](32, 12) NULL ,
    [fa_CYImpactBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_CYPreTaxCashFlowB] [numeric](32, 12) NULL ,
    [fa_CYPreTaxCashFlowB_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_CurrentSpaceCommi2] [numeric](32, 12) NULL ,
    [fa_CurrentSpaceCommi2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_FirstFullYearBase] [numeric](32, 12) NULL ,
    [fa_FirstFullYearBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_IncomeRecoveryBase] [numeric](32, 12) NULL ,
    [fa_IncomeRecoveryBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_PreTaxCashFlowBase] [numeric](32, 12) NULL ,
    [fa_PreTaxCashFlowBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_ProposedSpaceComm2] [numeric](32, 12) NULL ,
    [fa_ProposedSpaceComm2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TierSavingsFirst2] [numeric](32, 12) NULL ,
    [fa_TierSavingsFirst2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TierSavingsBase] [numeric](32, 12) NULL ,
    [fa_TierSavingsBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TotalCommitmentBa] [numeric](32, 12) NULL ,
    [fa_TotalCommitmentBa_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TotalCostsBase] [numeric](32, 12) NULL ,
    [fa_TotalCostsBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TotalPreTaxNPVBase] [numeric](32, 12) NULL ,
    [fa_TotalPreTaxNPVBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_SecondFullYearBase] [numeric](32, 12) NULL ,
    [fa_SecondFullYearBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [fa_TaxAdjustmentsBase] [numeric](32, 12) NULL ,
    [fa_TaxAdjustmentsBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_OtherExitCosts] [numeric](32, 12) NULL ,
    [br_OtherExitCosts_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [br_OtherExitCostsBase] [numeric](32, 12) NULL ,
    [br_OtherExitCostsBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentCurrent] [numeric](32, 12) NULL ,
    [ca_RentCurrent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentCurrentBase] [numeric](32, 12) NULL ,
    [ca_RentCurrentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentProposed] [numeric](32, 12) NULL ,
    [ca_RentProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentProposedBase] [numeric](32, 12) NULL ,
    [ca_RentProposedBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentProposedTerm] [numeric](32, 12) NULL ,
    [ca_RentProposedTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentProposedTermB] [numeric](32, 12) NULL ,
    [ca_RentProposedTermB_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentAveTerm] [numeric](32, 12) NULL ,
    [ca_RentAveTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentAveTermBase] [numeric](32, 12) NULL ,
    [ca_RentAveTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentVARProposed] [numeric](32, 12) NULL ,
    [ca_RentVARProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentVARProposedBa] [numeric](32, 12) NULL ,
    [ca_RentVARProposedBa_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentVARTerm] [numeric](32, 12) NULL ,
    [ca_RentVARTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_RentVARTermBase] [numeric](32, 12) NULL ,
    [ca_RentVARTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseCurrent] [numeric](32, 12) NULL ,
    [ca_ExpenseCurrent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseCurrentBase] [numeric](32, 12) NULL ,
    [ca_ExpenseCurrentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseProposed] [numeric](32, 12) NULL ,
    [ca_ExpenseProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseProposedBa] [numeric](32, 12) NULL ,
    [ca_ExpenseProposedBa_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseProposedTe] [numeric](32, 12) NULL ,
    [ca_ExpenseProposedTe_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseProposedTe2] [numeric](32, 12) NULL ,
    [ca_ExpenseProposedTe2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseAverageTerm] [numeric](32, 12) NULL ,
    [ca_ExpenseAverageTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseAverageTer] [numeric](32, 12) NULL ,
    [ca_ExpenseAverageTer_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseVARProposal] [numeric](32, 12) NULL ,
    [ca_ExpenseVARProposal_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseVARProposa] [numeric](32, 12) NULL ,
    [ca_ExpenseVARProposa_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseVARTerm] [numeric](32, 12) NULL ,
    [ca_ExpenseVARTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_ExpenseVARTermBase] [numeric](32, 12) NULL ,
    [ca_ExpenseVARTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotRECurrent] [numeric](32, 12) NULL ,
    [ca_TotRECurrent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotRECurrentBase] [numeric](32, 12) NULL ,
    [ca_TotRECurrentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREProposed] [numeric](32, 12) NULL ,
    [ca_TotREProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREProposedBase] [numeric](32, 12) NULL ,
    [ca_TotREProposedBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREProposedTerms] [numeric](32, 12) NULL ,
    [ca_TotREProposedTerms_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREProposedTerm] [numeric](32, 12) NULL ,
    [ca_TotREProposedTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREAveTerm] [numeric](32, 12) NULL ,
    [ca_TotREAveTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREAveTermBase] [numeric](32, 12) NULL ,
    [ca_TotREAveTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREVARProposed] [numeric](32, 12) NULL ,
    [ca_TotREVARProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREVARProposedB] [numeric](32, 12) NULL ,
    [ca_TotREVARProposedB_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREVARTerm] [numeric](32, 12) NULL ,
    [ca_TotREVARTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotREVARTermBase] [numeric](32, 12) NULL ,
    [ca_TotREVARTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommCurrent] [numeric](32, 12) NULL ,
    [ca_CommCurrent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommCurrentBase] [numeric](32, 12) NULL ,
    [ca_CommCurrentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommProposed] [numeric](32, 12) NULL ,
    [ca_CommProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommProposedBase] [numeric](32, 12) NULL ,
    [ca_CommProposedBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommProposedTerm] [numeric](32, 12) NULL ,
    [ca_CommProposedTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommProposedTermB] [numeric](32, 12) NULL ,
    [ca_CommProposedTermB_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommAveTerm] [numeric](32, 12) NULL ,
    [ca_CommAveTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommAveTermBase] [numeric](32, 12) NULL ,
    [ca_CommAveTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommVARProposed] [numeric](32, 12) NULL ,
    [ca_CommVARProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommVARProposedBa] [numeric](32, 12) NULL ,
    [ca_CommVARProposedBa_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommVARTerm] [numeric](32, 12) NULL ,
    [ca_CommVARTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_CommVARTermBase] [numeric](32, 12) NULL ,
    [ca_CommVARTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRCurrent] [numeric](32, 12) NULL ,
    [ca_BRCurrent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRCurrentBase] [numeric](32, 12) NULL ,
    [ca_BRCurrentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRProposed] [numeric](32, 12) NULL ,
    [ca_BRProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRProposedBase] [numeric](32, 12) NULL ,
    [ca_BRProposedBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRProposedTerm] [numeric](32, 12) NULL ,
    [ca_BRProposedTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRProposedTermBase] [numeric](32, 12) NULL ,
    [ca_BRProposedTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRAveTerm] [numeric](32, 12) NULL ,
    [ca_BRAveTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRAveTermBase] [numeric](32, 12) NULL ,
    [ca_BRAveTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRVARProposed] [numeric](32, 12) NULL ,
    [ca_BRVARProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRVARProposedBase] [numeric](32, 12) NULL ,
    [ca_BRVARProposedBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRVarTerm] [numeric](32, 12) NULL ,
    [ca_BRVarTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_BRVarTermBase] [numeric](32, 12) NULL ,
    [ca_BRVarTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_DilapCurrent] [numeric](32, 12) NULL ,
    [ca_DilapCurrent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_DilapCurrentBase] [numeric](32, 12) NULL ,
    [ca_DilapCurrentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_DilapProposed] [numeric](32, 12) NULL ,
    [ca_DilapProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_DilapProposedBase] [numeric](32, 12) NULL ,
    [ca_DilapProposedBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_DilapProposedTerm] [numeric](32, 12) NULL ,
    [ca_DilapProposedTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_DilapProposedTerm2] [numeric](32, 12) NULL ,
    [ca_DilapProposedTerm2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_dilapaveterm] [numeric](32, 12) NULL ,
    [ca_dilapaveterm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_dilapavetermBase] [numeric](32, 12) NULL ,
    [ca_dilapavetermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_dilapVARProposed] [numeric](32, 12) NULL ,
    [ca_dilapVARProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_dilapVARProposedB] [numeric](32, 12) NULL ,
    [ca_dilapVARProposedB_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_dilapVARTerm] [numeric](32, 12) NULL ,
    [ca_dilapVARTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_dilapVARTermBase] [numeric](32, 12) NULL ,
    [ca_dilapVARTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTCurrent] [numeric](32, 12) NULL ,
    [ca_TotOTCurrent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTCurrentBase] [numeric](32, 12) NULL ,
    [ca_TotOTCurrentBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTProposed] [numeric](32, 12) NULL ,
    [ca_TotOTProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTProposedBase] [numeric](32, 12) NULL ,
    [ca_TotOTProposedBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTProposedTerm] [numeric](32, 12) NULL ,
    [ca_TotOTProposedTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTProposedTerm2] [numeric](32, 12) NULL ,
    [ca_TotOTProposedTerm2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTAveTerm] [numeric](32, 12) NULL ,
    [ca_TotOTAveTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTAveTermBase] [numeric](32, 12) NULL ,
    [ca_TotOTAveTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTVARProposed] [numeric](32, 12) NULL ,
    [ca_TotOTVARProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTVARProposedB] [numeric](32, 12) NULL ,
    [ca_TotOTVARProposedB_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTVARTerm] [numeric](32, 12) NULL ,
    [ca_TotOTVARTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotOTVARTermBase] [numeric](32, 12) NULL ,
    [ca_TotOTVARTermBase_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFCurrent] [numeric](32, 12) NULL ,
    [ca_TotTransCFCurrent_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFCurrent2] [numeric](32, 12) NULL ,
    [ca_TotTransCFCurrent2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFProposed] [numeric](32, 12) NULL ,
    [ca_TotTransCFProposed_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFPropose] [numeric](32, 12) NULL ,
    [ca_TotTransCFPropose_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFPropose2] [numeric](32, 12) NULL ,
    [ca_TotTransCFPropose2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFPropose3] [numeric](32, 12) NULL ,
    [ca_TotTransCFPropose3_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFAveTerm] [numeric](32, 12) NULL ,
    [ca_TotTransCFAveTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFAveTerm2] [numeric](32, 12) NULL ,
    [ca_TotTransCFAveTerm2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFVARProp] [numeric](32, 12) NULL ,
    [ca_TotTransCFVARProp_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFVARProp2] [numeric](32, 12) NULL ,
    [ca_TotTransCFVARProp2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFVARTerm] [numeric](32, 12) NULL ,
    [ca_TotTransCFVARTerm_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_TotTransCFVARTerm2] [numeric](32, 12) NULL ,
    [ca_TotTransCFVARTerm2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPPerPersonCurre] [numeric](32, 12) NULL ,
    [ca_REPPerPersonCurre_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonPropos] [numeric](32, 12) NULL ,
    [ca_REPerPersonPropos_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonPropos2] [numeric](32, 12) NULL ,
    [ca_REPerPersonPropos2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonAveTer] [numeric](32, 12) NULL ,
    [ca_REPerPersonAveTer_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonVARPro] [numeric](32, 12) NULL ,
    [ca_REPerPersonVARPro_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonVARTer] [numeric](32, 12) NULL ,
    [ca_REPerPersonVARTer_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerUnitSpaceCur] [numeric](32, 12) NULL ,
    [ca_REPerUnitSpaceCur_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerUnitSpacePro] [numeric](32, 12) NULL ,
    [ca_REPerUnitSpacePro_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPPerPersonCurre2] [numeric](32, 12) NULL ,
    [ca_REPPerPersonCurre2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonAveTer2] [numeric](32, 12) NULL ,
    [ca_REPerPersonAveTer2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonPropos3] [numeric](32, 12) NULL ,
    [ca_REPerPersonPropos3_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonPropos4] [numeric](32, 12) NULL ,
    [ca_REPerPersonPropos4_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonVARPro2] [numeric](32, 12) NULL ,
    [ca_REPerPersonVARPro2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerPersonVARTer2] [numeric](32, 12) NULL ,
    [ca_REPerPersonVARTer2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerUnitSpaceCur2] [numeric](32, 12) NULL ,
    [ca_REPerUnitSpaceCur2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerUnitSpacePro2] [numeric](32, 12) NULL ,
    [ca_REPerUnitSpacePro2_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerUnitSpacePro3] [numeric](32, 12) NULL ,
    [ca_REPerUnitSpacePro3_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerUnitSpacePro4] [numeric](32, 12) NULL ,
    [ca_REPerUnitSpacePro4_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerUnitSpaceAve] [numeric](32, 12) NULL ,
    [ca_REPerUnitSpaceAve_UOM] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
    [ca_REPerUnitSpaceAve2] [numeric](32, 12) NULL ,
   &nb

SQLScott · November 23rd, 2005, 04:00 PM

That is not the only thing that you will run in to using a table of this size. With all due respect, this is just plain bad table design. No table should have this many columns.

Break this table up into a number of smaller tables, and then all your problems will go away.

Scott

Paul_Turley · November 23rd, 2005, 04:52 PM

Wow! This looks like a whole database in one table. I would recommend that you pick-up a book on normalized database design (mine or Vieira's.) Most any of the SQL Server intro, TSQL or SQL Programming books would give you a good baseline for designing this database.

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner

kapluni · November 23rd, 2005, 05:51 PM

I appreciate the help on the design front. Unfortunately the table is automatically generated from Java code, so as a short term solution changing the design is not feasible. I really just need to understand why the constraint is not being created in the ALTER TABLE while it does work inline, so if anyone has some insight on that, I would very much appreciate some help.
Thanks again...

SQLScott · November 23rd, 2005, 06:19 PM

Alya,

The answer lies in the error messages. Because the size of the table has exceeded the maximum allowable row size, the typical clustered constraint can't be created. Query plans use things like constraints to generate and produce an optimal plan. It bases its plan on a number of items, and for performance reasons it expects a maximum row size. Because there is a potential of the row size being larger than the SQL engine supports, SQL Server can't generate a performance plan and therefore won't let the constraint be created.

What is the reason that is needs to be a clustered index?

kapluni · November 23rd, 2005, 06:27 PM

Well, the things is that if I leave the constraint definition inline with the column definition of spec_id, then the clustered constraint does get created correctly. That is the part I do not understand - it seems that this is sometimes possible and sometimes not.

I believe the reasons for the PK to be clustered is to improve performance (which I understand is substantially hindered by the size of the table). The table definitions are dynamically generated based on user-defined objects, so as of now we can't really make them smaller without substantial changes to our code :( .