摘要:
记录下工作中写的其中一块触发器和存储过程,以便于将来查询触发器 create or replace trigger tr_tai_cell_jituan_i after insert on tai_cell_jituan_relation for each rowbegin insert into olapc.tai_cell_jituan_relation@olap (cell_id,... 阅读全文
摘要:
SELECT [指标1] ON COLUMNS,TopCount( CROSSJOIN({[小区乡镇维].[地区].[地区]},{[小区乡镇维].[县区].[县区]}),100,[TCH话务量]) ON ROWS FROM [G网无线与交换专题] WHERE ({[时间维].[日中时].[日中时].[19时]},([时间维].[日].[日].[2007年05月01日]:[时间维].[日].[日]... 阅读全文
摘要:
http://www.windowsitpro.com/SQLServer/Article/ArticleID/22994/22994.html The most frequent request that I receive from readers is for more information about MDX. They particularly want more MDX ex... 阅读全文