Hum...

I gave my two params a default value (NULL)

If I try this

EXEC Maintenance.p_XmlUpload_ForTest

I can parse my statement and the columns are generated

But if I try to add the 2...

I thought I had tried something similar which I have used with various client software, like LINQ for SQL, SSRS, etc...

It goes something like

DECLARE @Dummy INT

SELECT @Dummy = COUNT(*) FROM...

With everything I have read so far, I have little hope of achieving this through one step

So, just in case someone is interested in my answer, I will use...

To be honest, I expected that kind of answer...

Just checking!

Thanks 😀

I'll have to give that a shot after the Christmas break

Thanks

No, I don't use Hierarchical recordsets but I don't have access to the connection string used by MS Access.

I can only change the server name, login and password...

For reasons like this, I modified my table to be just a heap.

No constraint, no index.

This is really frustrating me because I tried to reproduce it simply and it seemed...

I have discovered that it's quite easy to reproduce and seems to be due to a "group by" I had in my query.

The sample below does something similar

CREATE TABLE #MyTable(What...

This used to be advised by the Kimball group but they actually changed their mind in one of their later books (don't remember which one).

Initially, they thought that a surrogate...

Thanks a lot, I'll have a look

My question then would be: Is there any reason why we should exclude every MDX based calculated member in a cube?

Would this be likely to kill the overall preformance of...

Hi there... although I am not sure to understand all the details of your problem, I find it "optimistic" to use Excel to load 1 million rows whether using aggregates...

For those interested, this article explains the solution I found in details

http://dwbijourney.blogspot.com/2008/10/dynamic-dimension-security-in-ssas.html

I just discovered that I might get away with generating a string in my SSAS Procedure instead of a set.

Then I can use the MDX function STRTOSET() to return a...

It must be the issue indeed.

We are on 2005 SP2

I have requested an upgrade to SP3

Still wondering why we don't use 2008 by the way!