Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 23rd, 2005, 12:55 PM
Registered User
 
Join Date: Nov 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Clustered PK Constr fails to create on big table

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
 
Old November 23rd, 2005, 04:00 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

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

 
Old November 23rd, 2005, 04:52 PM
Wrox Author
 
Join Date: May 2004
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old November 23rd, 2005, 05:51 PM
Registered User
 
Join Date: Nov 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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...

 
Old November 23rd, 2005, 06:19 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

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?

 
Old November 23rd, 2005, 06:27 PM
Registered User
 
Join Date: Nov 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 :( .






Similar Threads
Thread Thread Starter Forum Replies Last Post
Page splits - Clustered vs Non-Clustered Index carumuga SQL Server 2005 3 October 20th, 2008 04:23 AM
Create generic XSL Template to create table Venkatachalapathy XSLT 5 March 11th, 2008 07:49 AM
Retrieving data from a table given a PK value galaxy3 VB Databases Basics 1 June 22nd, 2006 12:12 PM
Size of Clustered Index MikeSchnell SQL Server 2000 0 May 7th, 2004 02:34 PM
Using ASP to create a big file hema Classic ASP Databases 2 July 8th, 2003 02:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.