General information
Forum:
Microsoft SQL Server
To clarify my question: How you you store this data in a table.
Right now, Im tentative on having the following schema
forecast
---------------
zip
lastupdate
forecastday
---------------
zip
day#
high
low
sunr
suns
dicon --This is specific to the "d" part of each day
dt
...
nicon --this is for the "n" part of each day
nt
Any other ideas on how to store this data? I was thinking of having a "part" table that stores data for each part , but since (Im assuming) there is always 2 parts to a day, it could just be stored in the forecastday table.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only