Hi Chris,

Thanks for the query. I didn't use the syntax like this.

FROM (VALUES ('ooo'),('bbb'),('ccc'),('ddd'),('eee'),('fff'),('ggg'),('hhh'),('iii'),('jjj'),('kkk'),('lll')) d (name)

In the same scenario, I will use UNION ALL with SELECT or insert the values...

Alias names are optional. The main purpose of using table alias is better readablity. As per your scanario, the prefix of column names will help us to understand the table...

Is type casting required?. I think it is not required. Even though it is a varchar type, SQL Engine will convert it internally in this scenario. Please correct me, if...