SQL Server Performance Forum – Threads Archive
Maximum table names per query
We are in the process of overhauling some of our internal systems. To prevent our data input teams from having to maintain the old and new systems in parallel, I want to refill the old format tables, from the new structure. Sadly this cannot be done via a view because it is too slow, so Ive written a query to refill the old tables, and maybe run it overnight. Unfortunately, even this script fails, with the error.. Server: Msg 4408, Level 16, State 1, Line 5The query and the views or functions in it exceed the limit of 256 tables. Here is my query. It does not appear to utilise more then 256 tables or derived tables.
However, In an attempt to avoid the error, I have created a view called NVDDictionaryTechnical_Static, which joins three tables. Can anyone suggest a way to fix the query?
Thanks SELECT
"TD_ID" = BaseT.TECH_Id,
"TD_Date" = BaseT.TECH_EffectiveFrom,
"TD_InsuranceGroup1" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_InsuranceGroup1’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_InsuranceGroup2" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_InsuranceGroup2’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Weight" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Weight’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Length" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Length’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Width" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Width’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ChassisEngineNo" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ChassisEngineNo’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_VinFrameNo" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_VinFrameNo’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_EC" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_EC’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_MPG1" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_MPG1’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_MPG2" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_MPG2’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_MPG3" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_MPG3’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_0to62" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_0to62’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Topspeed" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Topspeed’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_GVW" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_GVW’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Wheelbase" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Wheelbase’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Bore" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Bore’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Stroke" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Stroke’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CoinSeries" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CoinSeries’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CoinDescription" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CoinDescription’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_SpecialEdition" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_SpecialEdition’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_SpecialOrder" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_SpecialOrder’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CC" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CC’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_BHP" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_BHP’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Introduced" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Introduced’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Discontinued" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Discontinued’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ReIntroduced" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ReIntroduced’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_PS" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_PS’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_0to60" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_0to60’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_FuelTankCapacity" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_FuelTankCapacity’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_TyreSize" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_TyreSize’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ManStdWarTime" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ManStdWarTime’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ManStdWarMileage" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ManStdWarMileage’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ManPaintGuarantee" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ManPaintGuarantee’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CorrPerGuarantee" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CorrPerGuarantee’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_TowingWgtBraked" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_TowingWgtBraked’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_TowingWgtUnBraked" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_TowingWgtUnBraked’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_MaxLoadingWgt" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_MaxLoadingWgt’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_WidthIncMirrors" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_WidthIncMirrors’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Height" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Height’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_HeightIncRoofRails" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_HeightIncRoofRails’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadLength" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadLength’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadWidth" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadWidth’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadHeight" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadHeight’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadVolCommercials" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadVolCommercials’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_BootCapacitySaloons" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_BootCapacitySaloons’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadVol2ndRowSeatsUp" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadVol2ndRowSeatsUp’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadVol2ndRowSeatsDown" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadVol2ndRowSeatsDown’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadVol3rdRowSeatsUp" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadVol3rdRowSeatsUp’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadVol3rdRowSeatsDown" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadVol3rdRowSeatsDown’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadVol2ndRowSeatsRemoved" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadVol2ndRowSeatsRemoved’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadVol3rdRowSeatsRemoved" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadVol3rdRowSeatsRemoved’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Seats" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Seats’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_EPKW" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_EPKW’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_EPRPM" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_EPRPM’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ETLBSFT" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ETLBSFT’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ETNM" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ETNM’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ETRPM" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ETRPM’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_TyreSizeRear" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_TyreSizeRear’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_TyreSizeSpare" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_TyreSizeSpare’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_WheelType" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_WheelType’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Cylinders" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Cylinders’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CylinderLayout" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CylinderLayout’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Valves" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Valves’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Camshaft" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Camshaft’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_FuelDelivery" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_FuelDelivery’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CatalyticConverter" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CatalyticConverter’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_EngineLayout" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_EngineLayout’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CompressionRatio" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CompressionRatio’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Transmission" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Transmission’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Drive" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Drive’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Gears" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Gears’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CO2Emissions" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CO2Emissions’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_StandardEmissions" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_StandardEmissions’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_WheelStyle" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_WheelStyle’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_MaxRoofLoad" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_MaxRoofLoad’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LuggageCapacity" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LuggageCapacity’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_TurningCircle" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_TurningCircle’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_EngineMake" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_EngineMake’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_IgnitionTurbocharger" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_IgnitionTurbocharger’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CoolingSystem" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CoolingSystem’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_AutoTransmission" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_AutoTransmission’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ManualTransmission" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ManualTransmission’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ExhaustSystem" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ExhaustSystem’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_FrontBrakes" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_FrontBrakes’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_RearBrakes" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_RearBrakes’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_HandBrake" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_HandBrake’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_BatteryVolts" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_BatteryVolts’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_BatteryAH" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_BatteryAH’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_AlternatorAmps" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_AlternatorAmps’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_FrontSuspension" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_FrontSuspension’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_RearSuspension" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_RearSuspension’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Steering" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Steering’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Clutch" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Clutch’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_TyreMake" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_TyreMake’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_PlatedFrontAxle" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_PlatedFrontAxle’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Plated2ndAxle" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Plated2ndAxle’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_GrossTrainWeight" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_GrossTrainWeight’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_FrontOverhang" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_FrontOverhang’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_RearOverhang" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_RearOverhang’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_SideLoadDoorWidth" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_SideLoadDoorWidth’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_SideLoadDoorHeight" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_SideLoadDoorHeight’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LowerRearDoorWidth" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LowerRearDoorWidth’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_UpperRearDoorWidth" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_UpperRearDoorWidth’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_RearDoorHeight" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_RearDoorHeight’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadDeckHeight" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadDeckHeight’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_LoadSpaceWidBtwnWheelArches" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_LoadSpaceWidBtwnWheelArches’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_TurningCircleWalltoWall" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_TurningCircleWalltoWall’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_ETMKG" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_ETMKG’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_PedestrianTestRating" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_PedestrianTestRating’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_FrontAndSideImpactRating" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_FrontAndSideImpactRating’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CauseForConcern" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CauseForConcern’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Plated3rdAxle" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Plated3rdAxle’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Plated4thAxle" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Plated4thAxle’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_NoiseLevel" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_NoiseLevel’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CO" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CO’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_HC" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_HC’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_NO" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_NO’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_HCNO" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_HCNO’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Particles" = (select TOP 1 InnerT.TECH_Value_Float from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Particles’ and InnerT.TECH_Value_Float IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CoinWheelbaseDescCode" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CoinWheelbaseDescCode’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CoinWheelbaseNameCode" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CoinWheelbaseNameCode’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CoinGrossVehicleWeightCode" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CoinGrossVehicleWeightCode’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_CoinPowerOutputCode" = (select TOP 1 InnerT.TECH_Value_String from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_CoinPowerOutputCode’ and InnerT.TECH_Value_String IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Alloy" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_Alloy’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_SpaceSaver" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_SpaceSaver’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_AutoClutch" = (select TOP 1 InnerT.TECH_Value_Boolean from NVDDictionaryTechnical_Static InnerT where InnerT.TECH_Id = BaseT.TECH_Id and InnerT.TECH_EffectiveFrom <= BaseT.TECH_EffectiveFrom and InnerT.DT_StaticName = ‘TD_AutoClutch’ and InnerT.TECH_Value_Boolean IS NOT NULL order by InnerT.TECH_EffectiveFrom DESC),
"TD_Introduced" = CASE
WHEN BaseT.TECH_EffectiveFrom = (select MIN(InnerT.TECH_EffectiveFrom) from NVDTechnical InnerT where InnerT.TECH_iD = BaseT.TECH_iD)
THEN 1
ELSE 0
END,
"TD_Discontinued" = 0
into
dbo.TechnicalData
from
NVDTechnical BaseT
As 256 is limitation for Tables per SELECT statement and just incase what is the service pack level? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Server is running sql2k sp3. Do you know if the maximum number of tables refers just to the top level tables and views you are referencing, or whether it is the number of tables after all views have been dereferenced. For example, if I create a view of 3 tables, and then select from the view, would this count as 1 table/view, or 3 from my 256 limit ?
As far as I understnad, this is counted as 3 tables and not one table. Can you try splitting the query into 2 and using stored procedure / function to execute one of them and then joining the results with the outer query. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
]]>