Easy one, thanks.

glebih (10/17/2016)

---

Assuming that an UPDATE statement effectively DELETEs and INSERTs a record, can the values not be retreived via OUTPUT ?

IE

UPDATE table

SET Col1 = Val1

OUTPUT inserted.Col1 (should be Val1),...

Easy one, thanks.

Nice one, thanks.

You could use a table variable for example.

Or a comma separated list, split it out and use that as input.

Easy one, thanks.

I found the book "Star Schema - The...

imani_technology (10/3/2016)

---

That makes sense. I guess one can assume that the same project deployed to a new server should have the same number of rows, etc. Was anything...

It was the same project deployed to the new server.

Hi Henry,

you mentioned that orders are imported? Maybe you can add the source as well as a degenerate dimension?

For example, Source = S (system) for normal orders and Source =...

Just one small remark:

This should be:

The primary key of a fact table should be...

If you're not interested in the order line level - and only then - you can aggregate the data to one row in your example.

This is similar to aggregating measurements...

EZPZ.

Thanks!

Make sure you select save to server.

When I do this, I can choose between server connection (see screenshot in attachment).

Not sure what you mean. Which source/destination?