Based on your description, Merge replication doesn't sound like the correct option. Merge replication is used when you want changes made to the Subscriber database(s) to be "merged" back to...

How wedded are you to the schema of your base fact table? Is this a work in progress that you can make some changes to, or is it already in...

How many rows are in the base fact table? What will the growth rate be? What is the maximum number of periods that will be stored in the fact table?

ckoster (12/29/2011)

---

Well gosh...whenever I ask a question on SSC I never get the answer I thought I needed....I always get something better.

I have been doing the calculation for DUEDATE in...

You can't reference a calculated column in another calculated column. However, you could encapsulate the logic of the first computed column in the definition for the second.

ALTER TABLE TableA ADD...

I'm puzzled about the inclusion of the HAVING ( COUNT(Column_Name) >= 1 ) bit. Every value that exists in Column_Name will have one or more occurrences, so this doesn't do...

Ok, I think I was pretty close then with my assumptions. The code I posted should work for whenever you want to find out how much vacation time an employee...

Ok, taking into the account the issues I mentioned above, here's a possible solution that attempts to be as robust as possible (based on what I know/guess about your underlying...

This can definitely be done in a more elegant manner, with much better performance to boot. I'll post one possible solution in a moment; first though, I have some questions...

I think this thread from StackOverflow may explain the behavior you're seeing:

http://stackoverflow.com/questions/126401/sql-server-2005-numeric-precision-loss

From that thread:

Since you multiplied NUMERIC(24,8) and NUMERIC(24,8), and SQL Server will only check the type not the content,...

Except, the way the original CalendarPeriod table is structured, I'm pretty sure that...

I'm not sure about this bit:

join CalendarPeriod cp on (cp.CalendarDate = OrderDate and CalendarPeriod = @Period) or (@Period = ‘All’)

That works fine if @Period != 'All', but as soon...

drew.allen (12/9/2011)

---

This can be simplified even further.

WHERE H.SALESSTTUS = 1 AND

H.SALESORIGINID IN ('DSM','DSM-Trf') AND

L.STARTDATE < @IndvoiceEnd AND

@InvoiceStart > L.ENDDATE

This also emphasizes the fact that this relationship is commutative....

No problem. Did the last method I posted not solve the performance problems, or have you just not had a chance to test it yet?

Honestly, I haven't worked with SSIS enough at this point to be able to say...