How can I add my answer to the following question?
The question is about the hidden features in SQL Server. Now I have a trick to give alias name to subquery columns. This trick is not present in existing answer
Here is the query.
SELECT * FROM (SELECT 1,'a',NULL,NULL UNION ALL SELECT 1,NULL,'d',NULL UNION ALL SELECT 1,NULL,NULL,'c' UNION ALL SELECT 1,NULL,'d',NULL) a (groups, a, b, c)
How do I add this as an answer to the above mentioned question or can a moderator add this answer?