I thought finally found SQL Server bug 🙂 but no, it was another package that was messing with my end table. So, Dwain, it's safe to use Money type.

Thanks...

I thought you'd never ask! #Lady from Glee 😛

INSERT INTO [IPTS_Staging].[dbo].[FactSectorKPIHist]

([Prospect]

...

Here you go:

Creating table:

---==Create table

CREATE TABLE [dbo].[MDCS_GPS_LOG_RECV](

[Msg_ID] [varchar](50) NULL,

[Callsign] [varchar](50) NULL,

[Timestamp] [varchar](50) NULL,

[Msg_Content] [varchar](2500) NULL

) ON [PRIMARY]

GO

Sample rows:

INSERT INTO [dbo].[MDCS_GPS_LOG_RECV]

...

We've been doing some performance testing for Columnstore indexing using 160 mln rows, 400 mln rows with different kind of reporting queries. The purpose of test was, if it was...

I've included few of them in attachment.

I've 2 index on Salesdate table, both of them are non-clustered, one is for DateID and another one is for Short_SKU which is...

You have to go through some tutorial or books on how to build the cubes. You can't directly browse normal database using ssas. You will need to build the cube...

Even though I was taught first way, I always use the second way as well 🙂 as I have data consistency issue with the first way in many cases. Your...

@cstg85 Good idea, would be great if it worked... But in reality it won't I think, as your query needs 2 different type of data source in one...

I sense long list of code 🙂 I've list of tables that I need. 1400 tables are actually 100 tables with 14 different schema. From every schema I use 40...

You might want to check Datamicron's Performa, but it's not free I guess.

I heard Datamicron's Performa is a good tool for such things. It doesn't depend on SharePoint, it is standalone application, and connects to SSAS cubes and PPivot as well. No...

Thanks ChrisM@Work, it worked with adding (maxrecursion 365); at the end.

Later on I'll have to find a way how to do the same thing in the Cube, as it...

Thanks for idea @demonfox, you have got it right. But how to change it to fit my ChrisM@Work code.

Here is DDL:

--===== Create the table

CREATE TABLE...

The result is same with my previous query, I think I couldn't explain it right. By requirement for the column remaining it had to sum up all previous remaining cases....

Thanks ChrisM@Work, it looks promising. I never thought of minus from total 🙂

just having following error, any idea how to fix that?

Msg 207, Level 16, State 1, Line 22

Invalid column...