The Dixie Flatline (8/2/2011)

---

Would you mind posting your solution up here?

Don't forget the...

Hi

this article may help:

http://www.sqlservercentral.com/articles/tablediff+Utility/74261/

From the MS site...(nothing more than Gail has already stated)

https://mvp.support.microsoft.com/gp/mvpbecoming

List of SQL MVPs.....dbl click on any name to give an idea of the committment these people make to the community.

https://mvp.support.microsoft.com/communities/mvp.aspx?product=1&competency=SQL+Server

I...

Another possibility using quirky update.......thoughts anyone please?

regards gah

--=====

USE TempDB

;

--===== conditionally drop the test table

IF...

http://www.sqlservercentral.com/Forums/Topic1048093-391-1.aspx#bm1048213

http://office.microsoft.com/en-us/templates/recipe-collection-database-TC001018635.aspx

simple...but maybe "food" for thought 😀

Hi Scott

check out these articles below, maybe they will help.

http://www.databasejournal.com/features/mssql/article.php/3618061/MS-SQL-Joins---Part-1.htm

http://www.databasejournal.com/features/mssql/article.php/3623916/MS-SQL-Joins-Part-2.htm

http://www.databasejournal.com/features/mssql/article.php/3630381/MS-SQL-Joins-Part-3.htm

regards gah

Apologies for going off topic here, but I am confused by this statement above.

BOL states ...

until we have some clarification and examples...here's an idea

suggest looking up "ROUND" in BOL

SELECT CAST(Round (1.434567, 1,1) AS DECIMAL (18, 1))

SELECT CAST(Round (1.4499999999, 1) AS DECIMAL (18, 1))

SELECT CAST(Round (1.450000000,...

try the CASE statement (see BOL)

if you are still having problems please post back.

regards gah

Q...is this a cube you have designed or one that someone else has designed and you are accessing?

how many records in the "market-media-region -agency " dimension?

assume you are trying to...

Jeff...you are more than welcome, it was the least I could do to repay you for the amount of help...

rohit07 (9/20/2010)

---

I am Trying to connect the cube through excel and when i am trying to browse the data the quering is runing slow..I have just 1 datsource ,1 fact...

Hi

perhaps you can explain why you believe performance is slow?

some more information from you may assist others to help you

what version of AS?

How many data sources?

How many fact tables?

How many...

Jeff Moden (9/20/2010)

---

mazzz (9/20/2010)

---

Jeff

I've just seen your update in the OP - do you need any more results?

My home setup is Win 7, Intel core duo CPU, 4GB RAM, 64bit,...