Microstrategy has OLAP functions for running sum, running count, running average.

I found a solution in Microstrategy. Thanks though.

date 2 is the rolling sum of date 2 and date 1 by type

rolling(date 1, type a) = (date 1, type a)

rolling(date 2, type a) = (date 1, type...

no I don't seriously have a column called date. This was only an example.

I am looking to create a computed column for on the fly reporting. The query above only serves to show the output of what is needed, not how I will...

the file is not open. I should have access as the package runs in Visual Studio and in the import wizard from SSMS.

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

03/17/2014 15:43:48,Vool,Error,,VM-8F47-3969,Vool,,,The job failed. The Job was invoked by User NAM\jl04638. The last step to run was...

thanks for your help pietlinden...

still can't seem to get it to work so I just wrote a batch file to delete the files date in the title each day in...

what do you mean exactly. I can't figure out why what i wrote isn't working. plz hlp.

thanks again.

hey, it actually worked! I'm getting the data now from any xls file or xlsx.

Thanks!

I am still getting the error:

The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.

I have tried this now and am getting

Microsoft Access Database Engine 2010

/extract:path, extracts the content of the package to the path folder

/log[:path to log file], enables verbose logging for the...

I will try that. I have also tried to instal the 64-bit access driver but get this message.

http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

Engine 2010 because you currently have 32­bit Office products 

installed. If you want to install 64­bit Microsoft Access Database 

Engine 2010, you will first need to remove the 32­bit installation of 

Office products. After uninstalling the following product(s), rerun 

setup in order to install 64­bit version of Microsoft Access Database 

Engine 2010:

Microsoft Office Professional Plus 2007, Microsoft Office Access 

database engine 2007 (English)

I need to import data from excel using OPENROWSET. I can use the SSIS import export wizard but cannot save the import package with SSMS Express.

Whenever I try to...