Create Table Temp2

(

channel varchar(10),

forthedatent Int,

forthedate Numeric(12,2),

forthemonthcnt Int,

forthemonth Numeric(12,2),

)

Insert Into Temp2

Values ('Others',0,0,16,1000),

('a',1,1000.00,14,1000),

('TOTAL',1,1000,30,2000)

Select * from Temp2