locked
SharePoint 2007 - SQL Server Error When Editing Calculated Column RRS feed

  • Question

  • Hi,

    After trying to make changes to a calculated column in a list, I'm getting the following error in the succeeding page:

    SQL Server Error
    
    The SQL Server might not be started.

    However, when going back to the list settings and viewing the calculated column, the changes are still applied. Creating a new calculated column with the same settings does not return the above error page. What would be the most probable cause of the error page?

    • The SharePoint Farm version number is 12.0.0.6421
    • SQL Server version number is 9.0.1399
    • Single-server farm setup

    Below is a partial ULS Log entry associated with the error:

    09/29/2015 18:43:14.72	
    w3wp.exe (0x16C8)	
    0x12EC	
    Windows SharePoint Services	
    Database	
    6f8g	
    Unexpected	
    
    Unexpected query execution failure, error code 102. Additional error information from SQL Server is included below. "Incorrect syntax near ','." Query text (if available):
    UPDATE UserDataVersioned SET sql_variant4=CAST(7.43846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 5 AND tp_Version=11 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(7.43846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 5 AND tp_Version=11 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-14.2538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 6 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-14.2538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 6 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-22.1000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 7 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-22.1000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 7 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-19.7923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 8 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-19.7923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 8 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-0.561538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 9 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-0.561538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 9 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(21.2692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 11 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(21.2692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 11 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(23.9423076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 17 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(23.9423076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 17 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(33.3076923076923 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 18 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(33.3076923076923 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 18 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(22.3076923076923 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 19 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(22.3076923076923 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 19 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0.153846153846153 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 20 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0.153846153846153 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 20 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(27.1538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 21 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(27.1538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 21 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(17.8846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 22 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(17.8846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 22 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-4.00000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 23 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-4.00000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 23 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(7.50000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 24 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(7.50000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 24 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 26 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 26 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-21.5615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 27 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-21.5615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 27 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-16.2307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 28 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-16.2307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 28 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-3.70769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 29 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-3.70769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 29 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 30 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 30 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(2.56153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 31 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(2.56153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 31 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(53.6692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 32 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(53.6692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 32 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(1.03846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 33 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(1.03846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 33 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(44.6923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 34 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(44.6923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 34 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(75.5769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 35 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(75.5769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 35 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(121.846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 36 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(121.846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 36 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(130.615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 37 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(130.615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 37 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-2.66923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 38 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-2.66923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 38 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-2.66923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 39 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-2.66923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 39 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-42.9461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 40 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-42.9461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 40 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(23.7692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 42 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(23.7692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 42 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(23.9230769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 43 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(23.9230769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 43 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(24.8846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 44 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(24.8846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 44 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(31.1153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 45 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(31.1153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 45 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(68.6538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 46 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(68.6538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 46 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(15.4923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 47 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(15.4923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 47 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(66.6461538461539 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 48 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(66.6461538461539 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 48 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(48.5307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 49 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(48.5307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 49 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(43.4423076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 51 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(43.4423076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 51 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(43.4423076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 52 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(43.4423076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 52 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(42.4807692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 53 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(42.4807692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 53 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(9.18461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 58 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(9.18461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 58 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(23.4538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 59 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(23.4538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 59 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(21.6076923076923 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 60 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(21.6076923076923 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 60 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(51.9769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 61 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(51.9769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 61 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(33.8384615384615 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 62 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(33.8384615384615 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 62 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 65 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 65 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 66 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 66 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-22.6153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 67 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-22.6153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 67 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(43.5769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 70 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(43.5769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 70 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(22.3846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 71 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(22.3846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 71 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(22.1923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 72 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(22.1923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 72 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 81 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 81 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 83 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 83 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 85 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 85 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 86 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 86 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-14.1538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 87 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-14.1538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 87 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 88 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 88 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(30.0769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 89 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(30.0769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 89 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(4.40769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 96 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(4.40769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 96 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 97 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 97 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(46.9615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 98 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(46.9615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 98 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-13.5769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 100 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-13.5769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 100 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(4.54615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 101 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(4.54615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 101 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 104 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 104 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 105 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 105 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-1.31538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 106 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-1.31538461538462 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 106 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(17.9230769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 107 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(17.9230769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 107 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(30.0830769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 108 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(30.0830769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 108 AND tp_Version=2 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(2.92307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 109 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(2.92307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 109 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(56.5769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 110 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(56.5769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 110 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(6.00000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 111 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(6.00000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 111 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 112 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(0 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 112 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(4.54615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 113 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(4.54615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 113 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(4.54615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 114 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(4.54615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 114 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(4.00000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 116 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(4.00000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 116 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-28.2692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 119 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-28.2692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 119 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-4.96153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 120 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-4.96153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 120 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-16.4307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 122 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-16.4307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 122 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-43.0461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 123 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-43.0461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 123 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(68.3461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 124 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(68.3461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 124 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(62.3461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 125 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(62.3461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 125 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(21.7692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 126 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(21.7692307692308 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 126 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(15.5384615384615 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 127 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(15.5384615384615 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 127 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(14.1923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 128 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(14.1923076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 128 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(26.9615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 129 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(26.9615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 129 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-0.807692307692307 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 130 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-0.807692307692307 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 130 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-17.4230769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 131 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-17.4230769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 131 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(26.3523076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 132 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(26.3523076923077 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 132 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(26.1769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 133 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(26.1769230769231 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 133 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(4.61538461538461 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 134 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(4.61538461538461 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 134 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(18.2307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 136 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(18.2307692307692 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 136 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(6.38461538461539 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 137 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(6.38461538461539 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 137 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(38.0000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 138 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(38.0000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 138 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(78.6153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 140 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(78.6153846153846 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 140 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-1.28461538461539 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 141 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-1.28461538461539 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 141 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(-9.74615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 142 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(-9.74615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 142 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(27.7615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 143 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(27.7615384615385 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 143 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(27.0000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 144 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(27.0000000000000 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 144 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(42.5230769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 145 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(42.5230769230769 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 145 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(42.4846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 146 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(42.4846153846154 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 146 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    UPDATE UserDataVersioned SET sql_variant4=CAST(40.9461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 147 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=0;
    UPDATE UserDataVersioned SET ,sql_variant2=CAST(40.9461538461538 as float) WHERE tp_ListId = 'CDB05D12-FA4A-4D7E-8901-B360D2B2B293' AND tp_ID = 147 AND tp_Version=1 AND tp_Level=1 AND tp_RowOrdinal=1;
    ...



    Wednesday, September 30, 2015 2:44 AM

All replies

  • Hi,

    Please check the following article:

    SharePoint Dev Error: Exception from HRESULT: 0x80040E14

    Hope this helps:)

    Wednesday, September 30, 2015 6:57 AM
  • Unfortunately, the error I'm getting is from the out-of-the-box edit column page (no custom webparts/forms).

    I checked the disk space for the disk where the SQL data files for the content DB are stored and there is still enough space left (around 50% free disk space); however, the custom list where the calculated column is located currently has around 61,000 rows and almost 50 fields. Could the large number of rows be the cause of the issue?


    Wednesday, September 30, 2015 10:10 AM