Need help with SQL table structure transformation
- by Arnis L.
I need to perform update/insert simultaneously changing structure of incoming data.
Think about Shops that have defined work time for each day of the week.
Hopefully, this might explain better what I'm trying to achieve:
worktimeOrigin table:
columns:
shop_id
day
val
data:
123 | "monday" | "9:00 AM -…