My Table is
emp_activity
x
id emp_id date time status---|------|-------------|----------|---------1 | 1122 | 20-08-2019 | 09:30 AM | login2 | 1123 | 20-08-2019 | 09:30 AM | login5 | 1124 | 20-08-2019 | 09:30 AM | login3 | 1125 | 20-08-2019 | 09:30 AM | login4 | 1126 | 20-08-2019 | 09:30 AM | login6 | 1127 | 20-08-2019 | 09:30 AM | login7 | 1128 | 20-08-2019 | 09:30 AM | login8 | 1129 | 20-08-2019 | 09:30 AM | logini want to insert each employees logout rows at 11 PM on this same day in same table like this.
Wanted Table emp_activity
id emp_id date time status---|------|-------------|----------|---------1 | 1122 | 20-08-2019 | 09:30 AM | login2 | 1123 | 20-08-2019 | 09:30 AM | login5 | 1124 | 20-08-2019 | 09:30 AM | login3 | 1125 | 20-08-2019 | 09:30 AM | login4 | 1126 | 20-08-2019 | 09:30 AM | login6 | 1127 | 20-08-2019 | 09:30 AM | login7 | 1128 | 20-08-2019 | 09:30 AM | login8 | 1129 | 20-08-2019 | 09:30 AM | login9 | 1122 | 20-08-2019 | 11:00 PM | logout10 | 1123 | 20-08-2019 | 11:00 AM | logout11 | 1124 | 20-08-2019 | 11:00 AM | logout12 | 1125 | 20-08-2019 | 11:00 AM | logout13 | 1126 | 20-08-2019 | 11:00 AM | logout14 | 1127 | 20-08-2019 | 11:00 AM | logout15 | 1128 | 20-08-2019 | 11:00 AM | logout16 | 1129 | 20-08-2019 | 11:00 AM | logoutAdvertisement
Answer
Just use union all with scalar value insead of a column:
select * from MyTableunion allselect id, emp_id, date, cast('11:00:00' as time), 'logout' from MyTable