11 lines
260 B
Markdown
11 lines
260 B
Markdown
---
|
|
tags:
|
|
- database
|
|
project: "[[RMS]]"
|
|
---
|
|
# Erhöhe die prozentuelle ungeplante Arbeit von 10% auf 20%
|
|
|
|
```sql
|
|
update m SET m.percentage = 20 FROM rms.membership m left join rms.team t on t.id = m.team_id where t.category_id = 1 AND m.percentage = 10;
|
|
```
|