Updating table in mysql
Only one employee can be the general manager for the store.
What code do i write so that if i try to add another employee as a general manager, i get an error.
Thank youhi guys, if im going to create a table with derived column(meaning it's value is automatically created based from the value of another column from the table).
for example i have a base column named birth_date and the derive column is age (where age is automatically computed based on the value entered in the birth_date).
I know its possible to update tables using SSRS but not sure whether it can be done by direct entry via SSRS. I just attempted to post a detailed response, got an error and lost what I wrote. SHIFTS WHERE [email protected] Shift ID; -- make the update UPDATE DBO. In your report create a tablix and tie it to ds Output. Now you have a report that has a drop down which allows you to select the shift that you want as well as text boxes for each of the fields you discussed changing.