Default order of temp table

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

create table #tbl (id int null, mon char(8) null, cnt int null);
insert into #tbl (mon,cnt) values
('jul 2014',3100),('jan 2014',3200),
('may 2015',2300),('feb 2015',2600),
('apr 2014',1800),('mar 2015',3700),
('jun 2014',2400);
update #tbl set id = datepart(month,cast(mon as datetime));
select * from #tbl;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results