Hi Chrissy, thank you very much this might be a great idea will let it know whether it works

Hi Siddarth

When talking about 2005 and/or operational reporting, yes, I agree stored procedures work well.

Hi siddarth,

couple of things captured my interest:

- creating stored procedures for reports; is this wise in a MS BI environment? with a datawarehouse and cubes, one of things ...

Well, typical flaw in many database platforms is handling NULL.

Today I found out that I should place 31/12/9999 in my slowly changing dimension "current records".

Next I had to take out...

Hi Lamprey,

The dimension table is always filled prior to loading the fact table.

The logic is handled by a SQL Server SSIS package.

In my testbase the dimension is always the same,...

Hi Lutz,

The costcenter also makes mistakes so let's start of with this one.

It's easy yes to join the table.

But for clarity i've used the function as lookups might easily grow...

Hi,

Well, the function calls 2 other functions. Sadly it won't be possible to put it in one join because of the logic inside. The logic covers three tables, and if...

Thank you IMU, i think incidental things might occur only when something in the configuration might be wrong unless code is wrong.

Hereby the anatomy of the stored procedure, would be...