学习是为了生活!
我学习,我进步,所以我快乐!
摘要: 记录下工作中写的其中一块触发器和存储过程,以便于将来查询触发器 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,... 阅读全文
posted @ 2007-05-29 17:55 Emma 阅读(491) 评论(0) 推荐(0) 编辑
摘要: SELECT [指标1] ON COLUMNS,TopCount( CROSSJOIN({[小区乡镇维].[地区].[地区]},{[小区乡镇维].[县区].[县区]}),100,[TCH话务量]) ON ROWS FROM [G网无线与交换专题] WHERE ({[时间维].[日中时].[日中时].[19时]},([时间维].[日].[日].[2007年05月01日]:[时间维].[日].[日]... 阅读全文
posted @ 2007-05-29 15:42 Emma 阅读(422) 评论(0) 推荐(0) 编辑
摘要: 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... 阅读全文
posted @ 2007-05-29 14:55 Emma 阅读(1154) 评论(0) 推荐(0) 编辑