Hi Phil

Apologies, I've been away from work and not had chance to work on your suggestion.

I was responding to Scott's post with the purpose of my...

The current plan is to store the current indexes in a table.
The thinking is that we could add a record to the table (in the right format) and run...

I've updated the field size on this table already but here's the definition:-
CREATE TABLE [dbo].[tbl_Results_History](
    [pkKPIID] [INT] NOT NULL,
    [pkPeriodEndDate] [DATE] NOT NULL,
    [pkLocation] [VARCHAR](45) NOT NULL,

:blush: Oops!
That'll teach me to read the error message properly.
The code for the problem trigger is here:-
CREATE TRIGGER [dbo].[trg_tbl_Results_Update_SYSDateLastUpdated]
ON [dbo].[tbl_Results]
AFTER UPDATE

Oh, wonderful. 🙁

Thankfully, I don't think it's my problem, it'll be the 3rd-party vendor's problem.
Our database tables are set up to specification, it's just the insert (I...

The data is coming from a SharePoint list and we've got the company coming as well next week so we'll have to see what they can do with that from...

Thanks for that.
I've just checked and I've got a min of 1522 and a max of 1591.

I can insert the exact same data into each table without...

Thanks for the heads up, I'll see what I can do to get that changed (unfortunately, it's not our system).

It would also appear to be an intermittent problem...

Thanks Sue, I'll have a look at those links.

The reason for using report parts was so we could have a standard header/footer/colour scheme that we could change in...

With multidimensional cubes, you can point at the top level database and process all the cubes at once.

It would appear that ,with tabular, each cube is it's own...

We've managed to solve the issue and I'll post it here for anyone who has the same problem.

We've changed model.bim properties and selected "Integrated Workspace".

This seems...

There's only 3 of us in the team and we're usually working on different bits and pieces.
It's only when it comes to deployment it becomes a bit of an...

That sounds quite straight-forward.

I suppose the only other way to do it would be to do the following:-
Create solution on DEV and work on them
When we're...

So, from a quick read on that page, our main "trunk" would be what's on the production server, with branches for whatever is being worked on (fixes, new stuff, etc).