DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: variable column names

  1. #1
    Join Date
    Dec 2006
    Posts
    2

    variable column names

    I'm working on a data collection application. Actual device names to be logged can change. Two tables are used: a log "header" table that contains an entry with input descriptions (one record per "run") and another table that contains logged data every 10 seconds

    Log header table:

    DT | run_num | input1_desc | input2_desc |
    | 1234 | inlet_temp | zone_1_temp

    Data table:

    DT | run_num | input1 | input2 |

    | 1234 | 12.234 | 45.675

    How can I create a view to show data with actual column names (ex: inlet_temp)? Or should db be re-designed?

  2. #2
    Join Date
    Dec 2006
    Posts
    2
    Here is what I have:

    LogHeader table:

    DT | RUN_NUM | INPUT1_DESC | INPUT2_DESC |
    XXXXX| 12345 | INLET_TEMP | OUTLET_TEMP |

    Data table:

    DT | RUN_NUM | INPUT1 | INPUT2 |
    XXXXX| 12345 | 23.345 | 45.355 |
    XXXXX| 12345 | 13.345 | 65.355 |
    XXXXX| 12345 | 43.345 | 25.355 |
    XXXXX| 12345 | 23.485 | 35.355 |

    What I want: VIEW OR REPORT TO LOOK LKE THIS

    DT | RUN_NUM | INLET_TEMP | OUTLET_TEMP |
    XXXXX| 12345 | 23.345 | 45.355 |
    XXXXX| 12345 | 13.345 | 65.355 |
    XXXXX| 12345 | 43.345 | 25.355 |
    XXXXX| 12345 | 23.485 | 35.355 |

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width