Can't fill a column of NULLs with actual values by making an association to the proper values in the
Posted
by UkraineTrain
on Stack Overflow
See other posts from Stack Overflow
or by UkraineTrain
Published on 2010-06-05T06:02:57Z
Indexed on
2010/06/05
6:12 UTC
Read the original article
Hit count: 208
I have a table with separate columns for months, days and a varchar column for 6 hour increments for each day ('12AM', '6AM', '12PM', '6PM'). There's also a column that's supposed to have calculated numeric values for each of those 6 hour increments. These calculated values come from some reference table. This reference table contains values for each day for several months broken down by hour where each hour has its own column. So, basically, I have to add the values for each 6 hour increment. I have no idea how to associate the correct values in the reference table to those 6 hour increments.
I will really appreciate any help on this.
© Stack Overflow or respective owner