Thanks, that is working exquisitely

If I do it like that:

And include every...

Thanks, mate

I will work on that.

Cheers

What would the 'instead of update' and 'instead of delete' trigger look like? Insert is pretty straight forward...

What I mean is that there are tables that reference dbo.products via foreign key at the moment. If I rename the table (using sp_rename), the foreign keys will still point...

Thanks for the snippet,

It's about what I tried when I hit the problem that the existing references to the table dbo.product now have to reference a view in a foreign...

Sounds good. Pardon my ignorance - How do I do that?

Thanks mate,

It's just that I don't want to spend a lot of time on refactoring that legacy script. Performance is not an issue, neither is reusing it. The most simple...

Well, that sounds interesting... maybe I have no choice but to restructure my DB. I will follow that thought.

Thanks!

////////EDIT/////////

There must be another way. I just cannot figure it out....

Could you describe this more detailed please....

Thanks pal.

Thats a pretty straight forward example. But my scenario is the following:

I have OrderDate and ShippingDate in a fact table. Now I want to display the amount of...

I think the problem lies somewhere else:

First

let's take the standard example "Order Time" and "Ship Time". Each of these dimensions basing on the same dimension table. when I added the...

After all I guess it is not possible with server time dimensions, is it?

I cannot define al relationship between a fact table and a server time dimension, can I?

Is that...

Thank you!

But the quest is not quite over yet:

The BOL exactly describes the steps I did so far but not to the end. After I defined the dimension usages...

OK, it was a problem with the user rights. I had to choose service account...