This is probably a simple question but here it goes.
First off let me state that the naming of these columns is not by my choice nor can I change them. We purchased some software that automatically does the naming conventions for it's fields (Sample1).
I have a table with 2 columns in it:
Sample1 Time is in GMT Time
Time DateTime, PK
ABC_Price (Day, Hour) is in EST Time
Day SmallDateTime PK
Hour TinyInt PK
What I need to do is split the Ti
View Complete Post