摘要：with member [measures].[aaa] as[Measures].[Dollar Sales] - ([Measures].[Dollar Sales], ParallelPeriod([Time].[YQMD].[Year], 1, [Time].[YQMD].currentmember))member [measures].[Previous Dollar Sales] as... 阅读全文

摘要：将一个目录下(可以包括子目录)结构一样的excel文件批量导入sql2005,可以用ssis来定制任务.下面用大量图片完全说明整个过程.1、建立测试excel文件,假设有a b c d四个字段,保存在f:\excel目录下并复制很多个一样的文件2、打开Microsoft Visual Studio 2005或者随sql2005安装的SQL Server Business Intelligence ... 阅读全文

摘要：今天的社会，已经失去太多不该失去的西了，人们沉浸在金钱、美色、地位、权利当中无法自拔，却忽略了你在追求这些东西的时候，你的父母正在默默的牵挂着你。 阅读全文

摘要：February 15How to deploy an Analysis Services database using a scriptDeploying an OLAP application using deployment scripts is a common scenario in larger development environments. Of course we can us... 阅读全文

摘要：with waits as ( select wait_type, wait_time_ms / 1000 as wait_time_s, 100. * wait_time_ms / SUM(wait_time_ms) over() as pct, ROW_NUMBER() over(order by wait_time_ms desc) as rn from sys.dm_os_wa... 阅读全文

摘要：国外朋友让我帮忙找一个Microsoft? Office Professional 2007 英文版，当初以为中文版和英文版的key是通用的．算号器也一样，可结果呢......我试过了很很很多国内的Ｏffice2007注册码以及各种算号器，都不行．没有办法，最后只好去国外的网站论坛去找．这几乎花了我2个小时连带从微软件网站下载原程序及安装等，最终在网外的一个博客里找到了能用的几个注册码．在此供有需... 阅读全文

摘要：通过证书方式创建数据库镜像 主数据库代码： Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->USE [master] --创建数据库主密钥。 IF EXISTS(SELECT * FROM sys.databases WHERE name... 阅读全文

摘要：declare @i int set @i = 0 declare @temp table ( id int, customerid nvarchar(500), city nvarchar(500), orderid int ) insert @temp select top 100 percent ROW_NUMBER() over (order by c.customerid, o.... 阅读全文