Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "SELECT \n" +
- " v.str_nombre AS nombre, \n" +
- " v.num_dimensiones, \n" +
- " v.str_dimension_1 AS dim1, vv.str_indice_1 AS valor1, \n" +
- " v.str_dimension_2 AS dim2, vv.str_indice_2 AS valor2, \n" +
- " v.str_dimension_3 AS dim3, vv.str_indice_3 AS valor3, \n" +
- " v.str_dimension_4 AS dim4, vv.str_indice_4 AS valor4, \n" +
- " v.str_dimension_5 AS dim5, vv.str_indice_5 AS valor5, \n" +
- " v.str_dimension_6 AS dim6, vv.str_indice_6 AS valor6, \n" +
- " v.str_dimension_7 AS dim7, vv.str_indice_7 AS valor7, \n" +
- " v.str_dimension_8 AS dim8, vv.str_indice_8 AS valor8, \n" +
- " v.str_dimension_9 AS dim9, vv.str_indice_9 AS valor9, \n" +
- " v.str_dimension_10 AS dim10, vv.str_indice_10 AS valor10, \n" +
- " v.str_dimension_11 AS dim11, vv.str_indice_11 AS valor11, \n" +
- " v.str_dimension_12 AS dim12, vv.str_indice_12 AS valor12, \n" +
- " v.str_dimension_13 AS dim13, vv.str_indice_13 AS valor13, \n" +
- " v.str_dimension_14 AS dim14, vv.str_indice_14 AS valor14, \n" +
- " v.str_dimension_15 AS dim15, vv.str_indice_15 AS valor15, \n" +
- " (CASE v.str_tipodato \n" +
- " WHEN 'S' THEN vv.str_valor \n" +
- " WHEN 'B' THEN vv.bool_valor \n" +
- " WHEN 'D' THEN to_char(vv.tiempo_valor, 'YYYY-DD-MM') \n" +
- " WHEN 'N' THEN cast(vv.float_valor AS varchar) \n" +
- " END) AS valor \n" +
- "FROM variables v \n" +
- "JOIN valor_variable vv ON v.cod_variable_pk = vv.cod_variable \n" +
- "JOIN periodoprocesos pp ON pp.cod_perproc_pk = " + idPeriodo + "\n" +
- "WHERE vv.fecha_desde <= pp.fec_desde AND COALESCE(vv.fecha_hasta, CURRENT_DATE) >= pp.fec_desde \n" +
- "ORDER BY v.str_nombre";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement