Is this what you are looking for? (I don't recommend cartesian products...)

SELECT P.Part, T.YRM, COALESCE(S.Sales,0) Sales

FROM (SELECT DISTINCT Part FROM TestSales) P

CROSS JOIN dbo.TestTally T

LEFT JOIN...

This question may not have been 100% perfect (because of the Master vs NULL DBName as mentioned above) , but look at the following facts when each answer was compared to sp_who:

1. Only...

Hi Maria,

To sort in a specific way, you can use the ORDER function.  It will return a sorted set based on a Subquery.  The syntax is something like: Order(<<set>>, OrderByExpression,...

Hi Jan,

In order to get more detail on the specific error, have you enabled logging on the OLAP server?  After you have enabled logging, you may get more detail on...

I agree with Brian.  In my case, it will take at least 6 months to test, wait for a service pack, test again and then get management buy in.  By...

Jamie,

Are JobCode and JobCodeInput the same data type (as Vladan mentioned earlier)?  If not, then you might be able to use the CAST function to change the view so that...

Hi Jamie,

Can you post the SQL view so we have an idea where to start?

I took an OLAP / MDX bootcamp training from Aspirity.  One thing that they mentioned in training...

Yes.  I think this thread is referring to the encryption of the data in a table, not the encryption of the stored procedure.

You can encrypt a stored procedure so that...

I think the pwdencrypt() will store it in an encrypted fashion.  That may solve your problem.

Steve,

It appears that the encrypt function takes the characters that are typed in and then returns the Hex numbers of each character separated by 00.

I am not sure if that...

StevefromOz,

Sorry for the long delay, but I've been on holiday. Thanks for letting us know about the specific connection string setting. We upgraded to SP3 at the same...

We have two people working on the cubes, including me. I handle more of the administration functions. The developer is the one who re-wrote the queries.

It is my...

Thanks for all of the help! It's much appreciated.

We are experiencing better response times after our query re-writes. We still have a ways to go with performance tuning...

Hi tygun,

I think it would help if you gave us more of the details of your hardware and software. Without knowing those details, I would recommend installing the latest...

Hi StevefromOz,

We have had some improvement by changing the AS connection string. I believe we changed the "ClientCache" setting to be "=0" instead of the previous value. We...