USE [DBAdmin]
GO
/****** Object:  StoredProcedure [dbo].[UpdateStockQty]    Script
Date: 05/20/2008 11:02:24 ******/

When profiling our data sources - we discover what OLTP sources have what
percentages of NULL values for given columns.   My rule of thumb was, if the
% of null values was high - even past 50% - it wasn't too valuable to ETL in
the DW.  However when smaller % of values was null, ...

This place seems pretty quiet, where else do people go for data warehouse
queries?

We have a SQL table that consists of several fields, one of which we know is
an XML dump from a table.  The thing is, we don't know how to extract the
data out of the XML table that resides in this field.  For example, here is a
single record of part of the table.  The XML ...

I have two fact tables, ContractFact and FundFact.
In my DSV, I created a relationship to join them on a field that is in both,
called ContractID.
I'm having trouble figuring what to do to get the measures from both fact

 I am a newbie and I have been studying DW for a while and I've
successfully built some cubes.
 There is still one thing I am not sure how to design it in the fact table
which is the COUNT.  Let's say I have an Order Fact to record the order from

help,a difficult text how to sql table   code  ?
i have a text as follow, line with ¡°|¡±and {LF},
8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|

I have a Dell machine i have installed a C#.net application on it.
When i try access sqlserver on the server over the network i am unable
to connect. I am also unable to create a datasource .  The problem is
i have a newer Dell computer right next to this one and i am able to