Workday and alternative

Question

Hi, I have a table which needs to duplicate with weekday and alternative create table table3 ( col1 varchar(20) , col2 varchar(20)) expected results Insert into table1 values('catch', 'catch1') Catch--------catch1-------workday catch---------catch1--------alternative

Answer 1

Hi @Vineet S

Try something like this: Insert the desired result into a new table

;WITH CTE AS
(
SELECT col1, col2,'WorkDay' AS col3
FROM table3
UNION 
SELECT col1, col2,'alternative'
FROM table3
)
SELECT * 
INTO NewTable
FROM CTE

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".