select pvt.abc,pvt.def,pvt.ghi
from
(
SELECT ConnectionName, Connection.ConnectionString
FROM dbo.Global_Applications_ConnectionString AS Connection
) AS SourceTable
pivot (
min(ConnectionString)
for ConnectionName in (abc,def,ghi)
) as pvt