[SQL server] How to insert artificial data into a select statement
Suppose we got a original query as follows:

    SELECT A, B, C FROM tblA

Now, I need to additional artificial rows like 
**SELECT 'Kyala', B, C FROM tblA** when, for example, C = 100 to be inserted into the resultset. 

How could I achieve it **using a single SQL** instead of relying on table variable or temp table?
[SQL server] How to insert artificial data into a select statement
===

Suppose we got a original query as follows:

    SELECT A, B, C FROM tblA

Now, I need to additional artificial rows like 
**SELECT 'Kyala', B, C FROM tblA** when, for example, C = 100 to be inserted into the resultset. 

How could I achieve it **using a single SQL** instead of relying on table variable or temp table?