a     b     c     d  ...
--------------------------
1	2	3	4      ...
AA	BB	CC	DD     ...


CREATE TABLE [dbo].[Table11] (
	  [a] [varchar] (50) 
	, [b] [varchar] (50) 
	, [c] [varchar] (50) 
	, [d] [varchar] (50) 
) ON [PRIMARY]
GO

INSERT INTO Table11
SELECT * FROM (
	   	SELECT '1' as a, '2' as b, '3' as c, '4' as d
	   	UNION all
	   	SELECT 'AA', 'BB', 'CC', 'DD'
	      ) AS tempDB

select * from Table11
drop table Table11

I want this kind of result.

a       b
---------------
1       AA 
2       BB
3       CC
4       DD
...     ...