long integer - SQL Query is too complex, yet seems very simple -

i developed model through sas/kxen , exported score code script in sql. however, i'm getting "this expression typed incorrectly, or complex evaluated. example, numeric expression may contain many complicated elements. try simplifying expression assigning parts of expression variables. (error 3071)" error code, yet script seems simple enough (just lot of case whens). ideas rectify problem? thank you:

-- kxen analytic framework - ixi corp - equifax_us_amendment 1_2011_06_30 - itam media - - copyright kxen (c) 1999-2011 - model built in 5.1.4 - model name auto_digital_targets_model: auto trigger (month added) - model version 1

select $key, "rr_auto", cast( (case  when "rr_auto" <= -1.077823785821e0 6.05306179145e-3 when "rr_auto" <= -7.882377294631e-2 6.05306179145e-3 when "rr_auto" <= -7.782378582091e-2  ( 1.353029818544e-3*"rr_auto"+6.159712720187e-3 )  when "rr_auto" <= -2.27776053868e-2  ( 2.457958732379e-5*"rr_auto"+6.056327680634e-3 )  when "rr_auto" <= -2.27225048152e-2  ( 2.453076886879e1*"rr_auto"+5.648081862521e-1 )  when "rr_auto" <= -2.239074958722e-2  ( 4.074267027032e0*"rr_auto"+9.998502008548e-2 )  when "rr_auto" <= -2.122812183221e-2  ( 3.317444508635e-1*"rr_auto"+1.618709683277e-2 )  when "rr_auto" <= -1.93194152634e-2  ( 2.02071555915e-1*"rr_auto"+1.343438352374e-2 )  when "rr_auto" <= -1.880207986003e-2  ( 2.750673996089e0*"rr_auto"+6.26719178928e-2 )  when "rr_auto" <= -1.629110457901e-2  ( 5.667204500391e-1*"rr_auto"+2.160902706983e-2 )  when "rr_auto" <= -1.422586845977e-2  ( 8.377498048977e-1*"rr_auto"+2.602439734411e-2 )  when "rr_auto" <= -1.272245032419e-2  ( 1.150811683736e0*"rr_auto"+3.047797758284e-2 )  when "rr_auto" <= -1.040443748766e-2  ( 4.840967408216e-1*"rr_auto"+2.199572317408e-2 )  when "rr_auto" <= -9.092699548129e-3  ( 8.554623797399e-1*"rr_auto"+2.585957746292e-2 )  when "rr_auto" <= -7.776715513431e-3  ( 8.499508924389e-1*"rr_auto"+2.580946310972e-2 )  when "rr_auto" <= -7.067411649177e-3  ( 1.57692895964e0*"rr_auto"+3.146297199262e-2 )  when "rr_auto" <= -6.189206328952e-3  ( 1.028690319931e0*"rr_auto"+2.758833836143e-2 )  when "rr_auto" <= -5.106390124994e-3  ( 8.343071599086e-1*"rr_auto"+2.638525893334e-2 )  when "rr_auto" <= -4.068712552393e-3  ( 9.084700249121e-1*"rr_auto"+2.676396419647e-2 )  when "rr_auto" <= -3.236476389088e-3  ( 1.132730121325e0*"rr_auto"+2.767641630835e-2 )  when "rr_auto" <= -2.311112848156e-3  ( 9.162096194071e-1*"rr_auto"+2.697565065093e-2 )  when "rr_auto" <= -1.484466429351e-3  ( 1.025622271342e0*"rr_auto"+2.722851673069e-2 )  when "rr_auto" <= -6.582919879849e-4  ( 1.026794442297e0*"rr_auto"+2.723025679085e-2 )  when "rr_auto" <= -2.372768614338e-4  ( 2.014918874085e0*"rr_auto"+2.788074106867e-2 )  when "rr_auto" <= 7.348116300255e-4  ( 3.779561021206e-1*"rr_auto"+2.749231131023e-2 )  when "rr_auto" <= 1.466972506743e-3  ( 5.018115401022e-1*"rr_auto"+2.740130213251e-2 )  when "rr_auto" <= 1.773626724415e-3  ( 2.860591190964e0*"rr_auto"+2.394106082303e-2 )  when "rr_auto" <= 2.233186453451e-3  ( 1.908810320657e0*"rr_auto"+2.562915529258e-2 )  when "rr_auto" <= 3.00010379386e-3  ( 6.854086624086e-1*"rr_auto"+2.83612270689e-2 )  when "rr_auto" <= 3.936044386394e-3  ( 5.616294374467e-1*"rr_auto"+2.873257635351e-2 )  when "rr_auto" <= 4.478472197817e-3  ( 1.672101099827e0*"rr_auto"+2.436172170527e-2 )  when "rr_auto" <= 5.028307559689e-3  ( 1.649574041524e0*"rr_auto"+2.446260828431e-2 )  when "rr_auto" <= 5.850721137488e-3  ( 7.37321002719e-1*"rr_auto"+2.904968801315e-2 )  when "rr_auto" <= 6.001886640999e-3  ( 4.011383482005e0*"rr_auto"+9.894094200759e-3 )  when "rr_auto" <= 6.746515643618e-3  ( 1.653178226231e-1*"rr_auto"+3.297770584155e-2 )  when "rr_auto" <= 7.617596362912e-3  ( 1.413192172072e-1*"rr_auto"+3.313961256843e-2 )  when "rr_auto" <= 7.733833416175e-3  ( 7.936496738217e0*"rr_auto"-2.62408254121e-2 )  when "rr_auto" <= 8.391316551827e-3  ( 1.403100618187e0*"rr_auto"+2.428730648814e-2 )  when "rr_auto" <= 9.277818407042e-3  ( 7.717893009392e-1*"rr_auto"+2.95848332808e-2 )  when "rr_auto" <= 9.921191372171e-3  ( 1.063446374344e0*"rr_auto"+2.68788948332e-2 )  when "rr_auto" <= 1.04156843028e-2  ( 1.800201154244e0*"rr_auto"+1.956941703499e-2 )  when "rr_auto" <= 1.158256334531e-2  ( 7.628783379167e-1*"rr_auto"+3.037383363673e-2 )  when "rr_auto" <= 1.235526014615e-2  ( 1.739757568828e0*"rr_auto"+1.905907783277e-2 )  when "rr_auto" <= 1.344232502489e-2  ( 1.236637420602e0*"rr_auto"+2.527525311767e-2 )  when "rr_auto" <= 1.446073277534e-2  ( 1.408996524257e0*"rr_auto"+2.295834774894e-2 )  when "rr_auto" <= 1.670931082955e-2  ( 6.381512876404e-1*"rr_auto"+3.410532701834e-2 )  when "rr_auto" <= 1.773094271753e-2  ( 3.091367987252e0*"rr_auto"-6.886208815554e-3 )  when "rr_auto" <= 2.149117445603e-2  ( 8.399057113687e-1*"rr_auto"+3.303431731419e-2 )  when "rr_auto" <= 2.399923014126e-2  ( 1.887927909042e0*"rr_auto"+1.051109991042e-2 )  when "rr_auto" <= 2.403763415355e-2  ( 1.232951466039e2*"rr_auto"-2.903167468286e0 )  when "rr_auto" <= 6.240324243199e-2  ( 1.235421072765e-4*"rr_auto"+6.055195607717e-2 )  when "rr_auto" <= 6.340324247949e-2  ( 4.739767868535e-3*"rr_auto"+6.026388866803e-2 )  when "rr_auto" <= 1.062403242432e0 6.05644052721e-2 when "rr_auto" > 1.062403232432e0 6.05644052721e-2 when "rr_auto" >= 1.562403222432e0 6.05644052721e-2 else 0.0e0 end)  float ) proba0   ( select $key,  ( 5.881871083571e-3 +  cast( (case  when ( "comp360" null ) 4.935327682215e-3 when "comp360" < 1.418e3 -9.487857723034e-3 when "comp360" <= 3.73200624627e4  ( 3.909023382895e-8*"comp360"-9.543287674603e-3 )  when "comp360" <= 3.735600000001e4  ( 8.871132410687e-5*"comp360"-3.318796594523e0 )  when "comp360" <= 4.329428094367e4  ( 5.757205724121e-7*"comp360"-2.640298888932e-2 )  when "comp360" <= 5.366200000001e4  ( 2.151378961397e-7*"comp360"-1.079182119937e-2 )  when "comp360" <= 5.5568715698e4  ( 9.963450072002e-7*"comp360"-5.27129571931e-2 )  when "comp360" <= 7.363500000001e4  ( 4.97528001222e-8*"comp360"-1.120439560443e-4 )  when "comp360" <= 7.456136504401e4  ( 2.470352068076e-7*"comp360"-1.463893397232e-2 )  when "comp360" <= 1.0e6  ( 3.909023382895e-8*"comp360"+8.657270670023e-4 )  when "comp360" >= 1.0e6 3.995596089595e-2 else 3.0421122029e-3 end) float)+ cast( (case  when ( "dsiindex" null ) -1.22528641747e-3 when "dsiindex" < 1.0e0 -4.347321884497e-3 when "dsiindex" <= 6.493600083397e1  ( 1.895933608395e-7*"dsiindex"-4.347511477858e-3 )  when "dsiindex" <= 6.500000001e1  ( 2.415957577851e-2*"dsiindex"-1.573161432703e0 )  when "dsiindex" <= 1.172985795211e2  ( 2.975408294321e-5*"dsiindex"-4.723022491584e-3 )  when "dsiindex" <= 2.1100000001e2  ( 9.399555019836e-6*"dsiindex"-2.335465279553e-3 )  when "dsiindex" <= 2.289725274846e2  ( 4.820657323843e-5*"dsiindex"-1.052374612368e-2 )  when "dsiindex" <= 2.6700000001e2  ( 1.09151102402e-5*"dsiindex"-1.985025587747e-3 )  when "dsiindex" <= 2.677330000448e2  ( 5.566210791432e-4*"dsiindex"-1.476885192848e-1 )  when "dsiindex" <= 1.00000000001e3  ( 1.895933608395e-7*"dsiindex"+1.286551717494e-3 )  when "dsiindex" >= 9.9999999999e2 1.476145078333e-3 else 1.342517033075e-3 end) float)+ cast( (case  when ( "bal_retailcredit_new" null ) 3.435891076066e-4 when "bal_retailcredit_new" < 0.0e0 -1.027663996908e-3 when "bal_retailcredit_new" <= 2.097900028037e1  ( 1.695549928681e-8*"bal_retailcredit_new"-1.027663996908e-3 )  when "bal_retailcredit_new" <= 2.100000001e1  ( 2.950669720501e-2*"bal_retailcredit_new"-6.200483169289e-1 )  when "bal_retailcredit_new" <= 1.017480518373e2  ( 7.690605743411e-6*"bal_retailcredit_new"-5.691783444176e-4 )  when "bal_retailcredit_new" <= 1.7000000001e2  ( 1.075773997763e-5*"bal_retailcredit_new"-8.812532774423e-4 )  when "bal_retailcredit_new" <= 7.17208026001e2  ( 1.35662785556e-6*"bal_retailcredit_new"+7.169357833101e-4 )  when "bal_retailcredit_new" <= 5.47378e5  ( 1.69554992868e-8*"bal_retailcredit_new"+1.677759549427e-3 )  when "bal_retailcredit_new" >= 5.47378e5 1.095882683804e-2 else 3.435891076066e-4 end) float)+ cast( (case  when ( "bal_othernonmortgage_new" null ) 6.49070492785e-4 when "bal_othernonmortgage_new" < 0.0e0 -9.492489235445e-4 when "bal_othernonmortgage_new" <= 3.196800042199e1  ( -2.865089974917e-8*"bal_othernonmortgage_new"-9.492489235445e-4 )  when "bal_othernonmortgage_new" <= 3.200000001e1  ( 4.305535039747e-2*"bal_othernonmortgage_new"-1.37734362408e0 )  when "bal_othernonmortgage_new" <= 3.949024186059e3  ( 3.230840719637e-7*"bal_othernonmortgage_new"+4.17249948639e-4 )  when "bal_othernonmortgage_new" <= 3.917056e6  ( -2.865089974917e-8*"bal_othernonmortgage_new"+1.806259859012e-3 )  when "bal_othernonmortgage_new" >= 3.917056e6 -1.104209189089e-1 else 6.49070492785e-4 end) float)+ cast( (case  when ( "hh_autofin" null ) 1.488472474192e-4 when "hh_autofin" < 0.0e0 -4.710736071749e-3 when "hh_autofin" <= 9.990000138746e0  ( 1.201538430985e-4*"hh_autofin"-4.710736071749e-3 )  when "hh_autofin" <= 1.000000001e1  ( 6.400562921613e-2*"hh_autofin"-6.429266432734e-1 )  when "hh_autofin" <= 1.392892551578e1  ( 2.827546681306e-4*"hh_autofin"-5.697897793341e-3 )  when "hh_autofin" <= 2.200000001e1  ( 1.586846072613e-4*"hh_autofin"-3.969735157996e-3 )  when "hh_autofin" <= 2.792193557951e1  ( 1.726678673103e-4*"hh_autofin"-4.277366879072e-3 )  when "hh_autofin" <= 3.300000001e1  ( 1.915716060023e-4*"hh_autofin"-4.805195852855e-3 )  when "hh_autofin" <= 3.306700001318e1  ( 5.533049130884e-3*"hh_autofin"-1.81073954174e-1 )  when "hh_autofin" <= 1.0000000001e2  ( 1.201538430985e-4*"hh_autofin"-2.085745675522e-3 )  when "hh_autofin" >= 9.999999999e1 9.929638634331e-3 else 1.488472474192e-4 end) float)+ cast( (case  when ( "hh_autobnk" null ) -1.614032285829e-4 when "hh_autobnk" < 0.0e0 -1.838399331938e-3 when "hh_autobnk" <= 1.298700017737e1  ( 1.815003168977e-4*"hh_autobnk"-1.838399331938e-3 )  when "hh_autobnk" <= 1.300000001e1  ( -6.04737135335e-2*"hh_autobnk"+7.85890873095e-1 )  when "hh_autobnk" <= 1.583695456651e1  ( -9.644126182477e-5*"hh_autobnk"+9.863335632526e-4 )  when "hh_autobnk" <= 2.000000001e1  ( 5.242714728826e-5*"hh_autobnk"-1.371288666771e-3 )  when "hh_autobnk" <= 2.424793984083e1  ( 5.500665361205e-5*"hh_autobnk"-1.422878793247e-3 )  when "hh_autobnk" <= 2.800000001e1  ( 1.936191250225e-5*"hh_autobnk"-5.58567255531e-4 )  when "hh_autobnk" <= 3.570272726119e1  ( 1.025214008351e-4*"hh_autobnk"-2.887032928851e-3 )  when "hh_autobnk" <= 4.100000001e1  ( 1.450836551356e-5*"hh_autobnk"+2.552724657839e-4 )  when "hh_autobnk" <= 4.10590000128e1  ( -1.48117517394e-2*"hh_autobnk"+6.081319367672e-1 )  when "hh_autobnk" <= 1.0000000001e2  ( 1.815003168977e-4*"hh_autobnk"-7.475999454305e-3 )  when "hh_autobnk" >= 9.999999999e1 1.067403223547e-2 else -1.614032285829e-4 end) float)+ cast( (case  when ( "hh_fmother" null ) -1.069677183384e-4 when "hh_fmother" < 0.0e0 1.484348281833e-3 when "hh_fmother" <= 1.398600019024e1  ( -5.691356379979e-5*"hh_fmother"+1.484348281833e-3 )  when "hh_fmother" <= 1.400000001e1  ( -1.381375944085e-2*"hh_fmother"+1.938875971978e-1 )  when "hh_fmother" <= 1.728919387302e1  ( -1.15466926935e-4*"hh_fmother"+2.111502003043e-3 )  when "hh_fmother" <= 2.800000001e1  ( -6.243543751057e-5*"hh_fmother"+1.194630301539e-3 )  when "hh_fmother" <= 3.189892742845e1  ( -7.208279176467e-5*"hh_fmother"+1.464756220654e-3 )  when "hh_fmother" <= 3.600000001e1  ( -7.062423979564e-5*"hh_fmother"+1.418229977258e-3 )  when "hh_fmother" <= 3.606400001304e1  ( -9.354834814612e-4*"hh_fmother"+3.255316267722e-2 )  when "hh_fmother" <= 1.0000000001e2  ( -5.691356379979e-5*"hh_fmother"+8.684171640062e-4 )  when "hh_fmother" >= 9.999999999e1 -4.822939215973e-3 else -1.069677183384e-4 end) float)+ cast( (case  when ( "hh_mortgagecredit" null ) -1.456794544127e-5 when "hh_mortgagecredit" < 0.0e0 -8.384990197329e-4 when "hh_mortgagecredit" <= 2.297700030612e1  ( 1.325824884976e-5*"hh_mortgagecredit"-8.384990197329e-4 )  when "hh_mortgagecredit" <= 2.300000001e1  ( 2.714272371401e-3*"hh_mortgagecredit"-6.28997013134e-2 )  when "hh_mortgagecredit" <= 3.589630763069e1  ( 1.807532725954e-5*"hh_mortgagecredit"-8.871692981523e-4 )  when "hh_mortgagecredit" <= 5.600000001e1  ( 1.524051891743e-5*"hh_mortgagecredit"-7.854101458584e-4 )  when "hh_mortgagecredit" <= 6.37657348849e1  ( 1.838988781184e-5*"hh_mortgagecredit"-9.617748039452e-4 )  when "hh_mortgagecredit" <= 7.000000001e1  ( 2.122077144275e-5*"hh_mortgagecredit"-1.142288179015e-3 )  when "hh_mortgagecredit" <= 7.003000001142e1  ( 1.667940733899e-3*"hh_mortgagecredit"-1.16412685551e-1 )  when "hh_mortgagecredit" <= 1.0000000001e2  ( 1.325824884976e-5*"hh_mortgagecredit"-5.352711205967e-4 )  when "hh_mortgagecredit" >= 9.999999999e1 7.905537643791e-4 else -1.456794544127e-5 end) float)+ cast( (case  when ( "hh_1stmortgagecredit_nl12" null ) -3.851479335309e-4 when "hh_1stmortgagecredit_nl12" < 0.0e0 -5.924051677173e-4 when "hh_1stmortgagecredit_nl12" <= 5.994000087248e0  ( 1.328845709937e-4*"hh_1stmortgagecredit_nl12"-5.924051677173e-4 )  when "hh_1stmortgagecredit_nl12" <= 6.00000001e0  ( -5.29232194671e-2*"hh_1stmortgagecredit_nl12"+3.174258865351e-1 )  when "hh_1stmortgagecredit_nl12" <= 6.094000014465e0  ( -3.253631499761e-3*"hh_1stmortgagecredit_nl12"+1.940835873104e-2 )  when "hh_1stmortgagecredit_nl12" <= 1.0000000001e2  ( 1.328845709937e-4*"hh_1stmortgagecredit_nl12"-1.229070219259e-3 )  when "hh_1stmortgagecredit_nl12" >= 9.999999999e1 1.205938688011e-2 else -3.851479335309e-4 end) float)+ cast( (case  when ( "avgmob_totalallcredit" null ) -7.682563890863e-5 when "avgmob_totalallcredit" < 2.0e0 4.813545150812e-3 when "avgmob_totalallcredit" <= 7.392800093697e1  ( -6.861529764345e-5*"avgmob_totalallcredit"+4.950775746099e-3 )  when "avgmob_totalallcredit" <= 7.400000001e1  ( 2.788005779118e-3*"avgmob_totalallcredit"-2.062335098648e-1 )  when "avgmob_totalallcredit" <= 9.715412288377e1  ( -5.973247057019e-5*"avgmob_totalallcredit"+4.499120612198e-3 )  when "avgmob_totalallcredit" <= 1.0700000001e2  ( -1.949069486607e-5*"avgmob_totalallcredit"+5.894661907816e-4 )  when "avgmob_totalallcredit" <= 1.07316000025e2  ( 1.46200109428e-3*"avgmob_totalallcredit"-1.579301552478e-1 )  when "avgmob_totalallcredit" <= 4.2300000001e2  ( -6.861529764345e-5*"avgmob_totalallcredit"+6.329473490782e-3 )  when "avgmob_totalallcredit" >= 4.2299999999e2 -2.26947974124e-2 else -7.682563890863e-5 end) float)+ cast( (case  when ( "na_autobank" null ) 2.903024345148e-4 when "na_autobank" < 0.0e0 -3.829896504652e-3 when "na_autobank" <= 1.298700116737e-1  ( -3.169363530011e-4*"na_autobank"-3.829896504652e-3 )  when "na_autobank" <= 1.3000001e-1  ( 1.294408334764e1*"na_autobank"-1.684919183051e0 )  when "na_autobank" <= 2.091882296263e-1  ( 2.093307254777e-2*"na_autobank"-4.909647289856e-3 )  when "na_autobank" <= 3.2000001e-1  ( 1.053502926052e-2*"na_autobank"-2.734499126998e-3 )  when "na_autobank" <= 3.849008699287e-1  ( 1.821171845231e-2*"na_autobank"-5.191039668372e-3 )  when "na_autobank" <= 4.7000001e-1  ( 1.045997845179e-2*"na_autobank"-2.207388276225e-3 )  when "na_autobank" <= 5.308603385687e-1  ( 1.475209472318e-2*"na_autobank"-4.224682923781e-3 )  when "na_autobank" <= 5.7000001e-1  ( 3.611812983299e-2*"na_autobank"-1.556706334239e-2 )  when "na_autobank" <= 6.744300149602e-1  ( 1.333868417139e-2*"na_autobank"-2.582779315276e-3 )  when "na_autobank" <= 1.0500000001e2  ( -3.169363530011e-4*"na_autobank"+6.626980902726e-3 )  when "na_autobank" >= 1.0499999999e2 -2.665133616239e-2 else 2.903024345148e-4 end) float)+ cast( (case  when ( "cty" null ) -1.782382804934e-3 when "cty" < 0.0e0 1.962640547298e-4 when "cty" > 1.9e1 -6.707198221185e-3 when abs( "cty" - 0.0e0 ) < 10e-9 1.962640547298e-4 when abs( "cty" - 1.0e0 ) < 10e-9 -1.335104218808e-4 when abs( "cty" - 2.0e0 ) < 10e-9 -4.632848984915e-4 when abs( "cty" - 3.0e0 ) < 10e-9 -7.930593751021e-4 when abs( "cty" - 4.0e0 ) < 10e-9 -1.122833851713e-3 when abs( "cty" - 5.0e0 ) < 10e-9 -1.452608328323e-3 when abs( "cty" - 6.0e0 ) < 10e-9 -1.782382804934e-3 when abs( "cty" - 7.0e0 ) < 10e-9 -2.318538385233e-3 when abs( "cty" - 8.0e0 ) < 10e-9 -2.648312861844e-3 when abs( "cty" - 9.0e0 ) < 10e-9 -2.978087338455e-3 when abs( "cty" - 1.0e1 ) < 10e-9 -3.307861815065e-3 when abs( "cty" - 1.1e1 ) < 10e-9 -3.637636291676e-3 when abs( "cty" - 1.2e1 ) < 10e-9 -3.967410768287e-3 when abs( "cty" - 1.3e1 ) < 10e-9 -4.297185244897e-3 when abs( "cty" - 1.4e1 ) < 10e-9 -4.626959721508e-3 when abs( "cty" - 1.5e1 ) < 10e-9 -4.956734198119e-3 when abs( "cty" - 1.6e1 ) < 10e-9 -5.286508674729e-3 when abs( "cty" - 1.7e1 ) < 10e-9 -6.047649267963e-3 when abs( "cty" - 1.8e1 ) < 10e-9 -6.377423744574e-3 when abs( "cty" - 1.9e1 ) < 10e-9 -6.707198221185e-3 when "cty" >= 0.0e0 , "cty" <= 6.0e0 -4.75035309443e-3 when "cty" >= 7.0e0 , "cty" <= 1.6e1 -4.956734198119e-3 when "cty" >= 1.7e1 , "cty" <= 1.9e1 -5.388100314742e-3 else -4.956734198119e-3 end) float )+ cast( (case  when ( "den" null ) -1.370866855927e-3 when "den" < 0.0e0 1.187397664919e-4 when "den" > 1.9e1 -4.731455220138e-3 when abs( "den" - 0.0e0 ) < 10e-9 1.187397664919e-4 when abs( "den" - 1.0e0 ) < 10e-9 -1.222356536684e-4 when abs( "den" - 2.0e0 ) < 10e-9 -3.632110738288e-4 when abs( "den" - 3.0e0 ) < 10e-9 -6.041864939891e-4 when abs( "den" - 4.0e0 ) < 10e-9 -8.451619141494e-4 when abs( "den" - 5.0e0 ) < 10e-9 -1.08613733431e-3 when abs( "den" - 6.0e0 ) < 10e-9 -1.370866855927e-3 when abs( "den" - 7.0e0 ) < 10e-9 -1.611842276087e-3 when abs( "den" - 8.0e0 ) < 10e-9 -1.852817696247e-3 when abs( "den" - 9.0e0 ) < 10e-9 -2.170563863785e-3 when abs( "den" - 1.0e1 ) < 10e-9 -2.411539283945e-3 when abs( "den" - 1.1e1 ) < 10e-9 -2.652514704105e-3 when abs( "den" - 1.2e1 ) < 10e-9 -2.893490124266e-3 when abs( "den" - 1.3e1 ) < 10e-9 -3.285602699176e-3 when abs( "den" - 1.4e1 ) < 10e-9 -3.526578119336e-3 when abs( "den" - 1.5e1 ) < 10e-9 -3.767553539497e-3 when abs( "den" - 1.6e1 ) < 10e-9 -4.008528959657e-3 when abs( "den" - 1.7e1 ) < 10e-9 -4.249504379817e-3 when abs( "den" - 1.8e1 ) < 10e-9 -4.490479799978e-3 when abs( "den" - 1.9e1 ) < 10e-9 -4.731455220138e-3 when "den" >= 0.0e0 , "den" <= 5.0e0 -1.32711275447e-3 when "den" >= 6.0e0 , "den" <= 8.0e0 -1.370866855927e-3 when "den" >= 9.0e0 , "den" <= 1.2e1 -1.447637603304e-3 when "den" >= 1.3e1 , "den" <= 1.9e1 -1.598774758054e-3 else -1.370866855927e-3 end) float )+ cast( (case  when ( "om_score_compbank" null ) 2.067576391454e-3 when "om_score_compbank" < -1.83990421043e1 5.862160932523e-3 when "om_score_compbank" <= 5.407811559579e1  ( -7.321353908529e-5*"om_score_compbank"+4.515101944288e-3 )  when "om_score_compbank" <= 5.41506643682e1  ( -8.486274509202e-3*"om_score_compbank"+4.594775855165e-1 )  when "om_score_compbank" <= 5.988691655253e1  ( -1.796170279856e-4*"om_score_compbank"+9.666564312643e-3 )  when "om_score_compbank" <= 6.60103895187e1  ( -1.66585554025e-4*"om_score_compbank"+8.88614951914e-3 )  when "om_score_compbank" <= 6.608293388151e1  ( -7.954749568922e-3*"om_score_compbank"+5.229858897002e-1 )  when "om_score_compbank" <= 1.38554748887e2  ( -7.321353908529e-5*"om_score_compbank"+2.150865434479e-3 )  when "om_score_compbank" >= 1.38554748867e2 -7.99321808788e-3 else 8.430977645999e-4 end) float)+ cast( (case  when ( "month" null or "month" = ''  ) -2.771172542423e-3 when "month" in('01', '02', '03', '04', '05')  2.624553958278e-3 when "month" in('06', '12')  3.782250849016e-4 else -2.771172542423e-3 end) float ) ) "rr_auto" $dataset ) tmptable0 

you can make group of temp tables/ table variables, toss comparison , calculation constants inside, , query against values in tables. imagine lot easier read well.