Thanks cros1969. What you've said is very much what I expected. Given how much trouble I've been having finding clear guidance online, it's really useful to get some confirmation of...

With no suggestions here I raised the same question on MSDN.

For posterity, here were the responses:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/00840ca0-db94-48dd-a835-1c83934f2863/deploy-tabular-model-to-new-environment-and-update-connection?forum=sqlintegrationservices

Well, that seems to be the key. One of my colleagues has done this previously (possibly on SQL 2005) very simply. We wonder if the server default for cross-database ownership...

After a great deal of experimenting I managed to deliver a functioning solution, on very much the same premise as my SQL code. You create a calculated column as follows:

=

CALCULATE...

I'm getting rather bogged down in various things and am doubtful that I'm going to have chance to come back for a proper response, but I though I should at...

"I'll explore them when I'm back in the office on Monday" has become "I'll explore them when I'm back in the office on Thursday." However, I will look at responses.

Thanks

Stuart

I feel a bit foolish not thinking of a cross join appraoch. Good (and neat) suggestions - I'll emplore them when I'm back in the office on Monday.

Thanks

Stuart

A set of strange dreams and some more work allowed me to find the answer I was looking for. It's long, slow, and could almost certainly be improved, but it...

As indicated, here is my solution. I've changed the sample data and references from the original post, simply because it's what I ended up working with.

Sample data:

CREATE TABLE Contracts (

seplGuid...

@Eugene - point taken, link bookmarked.

@anthony-2 - thank you very mcuh.

@mark-3

Thanks for this - it certainly gives me something to work with. I also followed some...

That works!

Thanks to all involved.

Stuart

I've taken the suggested code and played around with it to get a better understaning of how it works. The fruits of my playing are below:

WITH TempTable AS (

SELECT ConstraintBasedGroupId,...

Thanks. I'll give that a whirl when I'm in the office on Monday.

Stuart

Isn't that what I've done in the second post?

I've presented a table consisting of two fields:

ConstraintBasedGroupId

Constraints

I've presented sample values for these two fields (i.e. one row of the source table):

ConstraintBasedGroupId...

I don't think that there is much more information to give, so I'll ramble for a bit and hope that helps.

Our company purchased a configuration of Microsoft CRM to use...