Timeline for set date value based on other row values
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 8, 2014 at 12:42 | comment | added | Mikael Eriksson | @user2301990 Not near Thailand right now but thanks and glad I could help. | |
| Jul 8, 2014 at 12:32 | vote | accept | user2301990 | ||
| Jul 8, 2014 at 12:32 | comment | added | user2301990 | You're a star! The last one is the simple answer I was looking for - even with 3 different entries of which 2 have the same Priority, it's doing what's intended, delays both of them to the same day :) If you're in Thailand, I'll buy you a beer right now! Thx a mill ... | |
| Jul 8, 2014 at 12:15 | history | edited | Mikael Eriksson | CC BY-SA 3.0 | added 633 characters in body |
| Jul 8, 2014 at 12:10 | comment | added | Mikael Eriksson | @user2301990 Ok, added one way to do the update. | |
| Jul 8, 2014 at 12:09 | history | edited | Mikael Eriksson | CC BY-SA 3.0 | added 633 characters in body |
| Jul 8, 2014 at 12:08 | comment | added | user2301990 | oh ... the st_date per order_id is the same, it's basically the date the order is booked for, no matter how many items, so this shouldn't be a problem, just need to get it into an Update Statement now :) | |
| Jul 8, 2014 at 12:02 | comment | added | user2301990 | Hi Mikael, thanks a lot, it works great in a Select Statement... still having trouble to use this in an Update Statement to actually write the CourseDate Value into the table ... could you provide me with some input? | |
| Jul 8, 2014 at 11:54 | history | edited | Mikael Eriksson | CC BY-SA 3.0 | added 814 characters in body |
| Jul 8, 2014 at 11:49 | history | answered | Mikael Eriksson | CC BY-SA 3.0 |