Chris - can you ellaborate on private and shared dimensions?

Breakthrough!  Moments after I posted above, I found the solution.  I changed the Dimension view from "tree" to "Grid" and saw a very interesting column called "NameColumn" - which holds...

Ahh - this is actually starting to get comedic.  Its been a while since I spun my wheels this much...

So, I've reviewed my dimension and it seems correct.  I've even...

Thanks for all the responses.  after installing or re-installing all necessary components, I was still recieving the "Error in Transport Layer has occurred".  It turns out that you can't pass a SQL...

Yes - each month is a column name.  This is a common format we use for tables that hold balances, not line item entries such as a ledger.  Our ERP...

Thanks.  I didn't realize a plug-in was required.  I'll give that a shot. RH

Thanks David.  I was nervous about repairing my EM 2000 installation until I heard about a successful coexistence.  I just reinstalled/repaired EM 2000 and all appears to be fine.

Thanks for...

I found the answer.  You have to remove all previous SQL 2005 installs before installing the official version.  This doesn't just mean "SQL Server Management Studio Express CTP".  It also...

David, did you intend for your last statement to be "This doesn't give any benefits on SQL2005"?  If so, why not?

Also, selecting col1, col2, and col3 from the table...

Yelena - thanks much.

Thanks Bill.  We have SQL 2000 in the environment - this server remains at 7.0 for the time being for a legacy app.  Also, while I can get around this...

Just piping in on a something I just noticed in playing with INTERSECTand EXCEPT.  I expected that they would act identicle to EXISTS and NOT EXISTS but they don't.  They...

Sergiy,

Are you referring to this result...

SELECT dbo.TrimZeros (col1)

2. 24 s

...as an indication that parrallelism was working?  Any chance the performance advantage was due to 3...

Install iSeries Navigator on your SQL box so you have the necessary drivers.  Then setup an ODBC DSN pointing to your DB2 library of choice.  On SQL setup the linked...

Alright - I guess nobody has read the third edition yet...  How about Celko's other 2005 release, SQL Programming Style.  Any feedback on that one yet?