Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- prod_codigo esps_fecini day1 day2 day3 day4 day5 day6 day7
- 1077 2018-11-12 200.00 200.00 250.00 250.00 0.00 0.00 0.00
- ...
- prod_codigo esps_fecini Bins
- 1077 2018-11-12 200.00
- 1077 2018-11-13 200.00
- 1077 2018-11-14 250.00
- 1077 2018-11-15 250.00
- 1077 2018-11-16 0.00
- 1077 2018-11-17 0.00
- 1077 2018-11-18 0.00
- ...
- select prod_codigo,esps_fecini,U.Bins
- from dba.estimprodsemana
- unpivot
- (
- Bins
- for datos in (esps_cadia1,esps_cadia2,esps_cadia3,esps_cadia4,esps_cadia5,esps_cadia6,esps_cadia7)
- ) U
Add Comment
Please, Sign In to add comment