Like others here I'd need a bit more to convince me to remove my table or use this as an alternative. Like most, I also us the time table to...

Well done, thanks for the write up.

Ther'll probably be a way to include the headers in SQL but not to make them bold. For that I would suggest a script that does that automatically when the...

What version of Proclarity? Also, out of interest, why put it on a server? Asr you sure ir has the correct pivot table services installed and MDAC?

Here is the (I...

Not to go into this in great depths but yes option 2 will generate a fair bit of logging. Have a look at your databases recovery model. The do some...

Spreadsheets are GOOD, if used correctly (as pointed out above). by the sounds of the compamy is using Excel to capture and retain data rather than report on it. Thats...

nigel,

That was what I was getting at.

publicdh-tech,

I like your point about 2008. Not being lucky enough to be using (or even testing) 2008 I'd not contemplated you can just...

One thing to be mindful with - SET @dt = DATEADD(d,1-DAY(@dt),@dt) is that when it's used with getdate() the result includes the time as well as the date.

Why not try this -

SELECT @MONTHSTDATE = DATEADD(MONTH,DATEDIFF(MONTH,0,@STARTDATE),0)

instead of a long winded convert.

The thing with environment variables is when you change them you tend to need a reboot for it to come through.

Now, this could be our set up that makes us...

Willie,

See if this helps - http://www.sqlservercentral.com/Forums/Topic93756-9-1.aspx

Do you still have the back up you used to move from box B to box A? if so reuse that to get yourself back up and continue your changes...

Well done guys,

Many a time SSC has helped me or come to my rescue, hopefully I've helped others along the way.

I remeber the 1/2 million mark and look forward to...

Not that I want to sound like a moaner for getting a set of free webinars, that I'm sure will be good, BUT, it would have been nice to be...

There is an "UnknownMember" property on your dimensions, you can investigate that option.

A couple of links that may also point in the right direction -

http://www.sqlservercentral.com/Forums/Topic555260-147-1.aspx

http://www.sqlservercentral.com/articles/Analysis+Services/64802/