I don't have a specific case that this is for, but just curious if it would be possible.
The thought initially came out as I was trying to insert multiple rows into a table from a select statement; as in
Insert into table2 (id, timedate, rowName)
(select a.id, a.timedate, 'rowA' from table1 a where a.id = 1)
The goal would be: to create a SINGLE select statement where one can specify the value of one of the columns.
That sounds like what 'CASE' would do, but I just wasn't able to get it to work.
Also, I feel doing a UNION or using a temp table would be cheating