Thanks for your reply Gail and yes, I really should provide that info ... but ** bows head, feels small and vulnerable ** I am using .... oracle ...

I...

....

Thanks a lot guys ... I needed this ....

and yes, different queries give different results ... no further comment.

I'm off to get a cold shower, a can of...

NOt sure where to go from there - I would suggest deconstructing the thing ...

Do your code to call SP and update SQL Server table ... then separately - i.e....

Hi,

step through your code and see where it falls over.

In addition, check that the server accepts remote connections (server properties > connections), and that your user credentials allow to log...

Hi,

a little difficult to see what is going on but the error is definitely an Excel error and, as far as I can see at the moment, seem to suggest...

Hi,

not sure I understand your question properly, but essentially SSAS does have a built-in mechanism to deal with measures that should not aggregate - look up additive and semi-additive measures...

I would tihnk that since you are moving this to a data warehouse, you would want to have the calculations performed during the ETL process and only store the results...

Why not use a variable first?

something like:

DECLARE @VATRateID INT;

SET @VATRateID = 1;

UPDATE TempSales2

SET VATRateID = @VATRateID,

Gross...