크로스 조인을 이용한 누적합계

select a.v1, a.v2, b.v1, b.v2
from tblx a cross join tblx b
 where b.v1 <= a.v1
order by a.v1, b.v2

select a.v2,  b.v2
from tblx a cross join tblx b
 where b.v1 <= a.v1
order by a.v1, b.v2

select a.v2,  sum(b.v2)
from tblx a cross join tblx b
 where b.v1 <= a.v1
group by a.v2
order by min(a.v1)

select  idx=identity(int), a.*
into tmp_articleclass
from (select top 100 percent WOWCode, ArticleDate, CompCode, ClassCode, ArticleID,Title from articleclass order by articledate asc) a
go

alter table tmp_articleclass
 add primary key ( WOWCode, ArticleDate, CompCode, ClassCode, ArticleID)
go

drop table articleclass
go

exec sp_rename 'tmp_articleclass', 'ArticleClass'

select count(*) from articleClass