Thanks guys,

Your input lit the lightbulb.  this is what I have so far:

SELECT DISTINCT

 prj.projectnumber,prj.dlhours,prj.dl,prj.nonDSMat

FROM

 (SELECT projectnumber,

  CASE account   WHEN '14xxx' THEN normalhours ELSE 0 END  AS 'dlhours',

  CASE account

   WHEN '14xxxx' THEN reclassified ELSE 0 END ...

I've used the SQL Enterprise Manager as far back as 6.5.  I believe IIS 6.0 is compatible with SQL Server 2000.  Remember to use the latest service packs when installing...

Hi Again,

This is what I came up with after reviewing the data more carefully.

SELECT  voucherdate,vouchernumber,vouchertype,accountnumber,

debitcreditcode,  

  CASE

   WHEN debitcreditcode = 'K' AND amount > 0 THEN

    -1*(amount)

   WHEN debitcreditcode = 'D' AND amount < 0...

Thanks Remi,

I was trying to use the table the way it was loaded.  There is no documentation on the methodology on why the data was loaded in this fashion.  However...

UniqueID is mislabel, and yes it's("UniqueID") a FK.  For the sake of extracting the first occurence of the id, I did not put in the PK.

Thanks,

That's weird the rest of the message truncated.

The gist of it I have two or more records that make up a complete address (don't ask why this was design this...

Hi Again,

Sorry for hitting the panic button.  Did some research and found out how to resolve this.

Here is a link to resolve this problem in case anyone encounters this problem:

Wow,

Everyone's been super.  FYI, this is what I've come up with so far;

Non-programming (potentially off the shelf)

SPSS OLAP Hub - they're getting back to me on a price and demo...

Thanks for the information.  I guess I'll probably start using MDX, however my first choice is to have tool automatically read a cube. 

Trying to follow best practices and not...

Thanks for the information, I was just about to download and evaluate, however I stopped because this product can not read Analysis Service Cubes.  I guess that is another requirement...

Thanks everyone for your suggestions.  What I've done is bought something like 3-5 books on datawarehousing/datamarts/data cleansing/data conforming, etc. and have gone online to read as many articles as well. ...

Hi,

I've already gone through step 1 - Business Requirements phase(metrics).  I've created a DTS package that only pulls the necessary metrics table.  This is POC on selling the idea of...

Thank You,

I got my expected results. 

It's literally been years since I've done any type of date formatting.  I try to keep my toolbox up to date but I feel...

Hi,

What is your salary range and have you thought about telecommuting candidates?

Just a few suggestions!!

Thanks

WOW,

Thanks for the responses.  I'll start using the queries and will let you know how I make out.

Thanks