I have to build a Fact table, and I have this situation.
My OLTP database, keeps always the last image of the
record.
Table

Myself and few other guys are working on this problem from past few days but no break-through yet.
We are trying to figure out calculating "Median"
Here is the business problem:
In "Foodmart" database (standardly delivered with MS SQL server Analysis Services)

We have this virtual cube that has a dimension that is in common with
several cubes. What we need to happen is to create a virtual cube
bringing in several of the dimensions unique to each cube. This is not
a problem, the problem is what we would like to see happen is when we

I am currently developing an ETL process for a small data warehouse.
Because of its size, it doesn't warrant buying an ETL tool. My
question deals mainly with column and table mappings. Basically, we
have events that are piled in from various machines that track

We have a large number of (Crystal) Reports ( based on Stor Proc ) running
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.

How have other tackled the Inventory Cube?  I am thinking
along the lines of
these two strategies
1.  1 and only one snap shot at a time that we decide

I'm having a problem with following:
Firstly my date field in excel is in form of "200311204".
I need to pump this date field to a SQL datetime field
called 'dt'

How to load JPG images into SQL SERVER 2000

We are currently logging IIS data to an SQL server. The
amount of data has reached 14 GB. When we were logging to
the IIS server as regular log files for the same period
of time (roughly one month the log files were not more