Do I hear the faint call of a threadaholic echoing in the distance?

Greg E

CirquedeSQLeil (6/16/2010)

---

Yes it can. I am finishing up a SQL blitz right now. ...

[The front-end tool is a query generator that, reading the DWH metadata, produces huge SQL statements to aggregate the data. So, basically, no way to modify the statements.

Long story short,...

Dave Ballantyne (6/16/2010)

---

I dont normally post other forums "posted questions getting worse" but this one i had to share.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/ce4bc469-c62a-4751-8524-062cd67df730

Q1 ) How to make dateadd subtract.

Q2) How to subtract not 15...

We'd have to build a new time dimension anyways.

We use a 4-4-5 week setup, with 52 weeks in the year. The extra days vary year to year, put into the...

Look in the event log under Application, at the around the time your cube finished it's last run.

We process ours using a package, and we have events 12288 written to...

I think they are right about the permissions.

The ID SQL Service is running as needs full permissions to the directory where you have the mdf and ldf files.

It almost sounds...

Just looking at the error, it looks like a data source problem.

Try defining a new data source and see if that works.

Also - are you the only one working with...

I could see you wrestled with it. Some of the requirements weren't exactly clear.

I like to ask a lot of questions so I don't get boxed in later.

Nothing worse...

I agree with Keith - make sure you know what you are really trying to solve for.

Cases may have open, assigned, closed statuses, along with a unique id and a...

Steve Jones - Editor (6/10/2010)

---

What was funny is that my son pointed out that most football games are really 2-1 (10-7) or 4-2 (21-14). Not a ton of scoring, but...

We tried using...

I just moved my backend database to a new server with a different name.

The stsadm tool worked for me using the renameserver command.

Greg E

timmynew11 (6/4/2010)

---

Sorry if I affended anybody, time constraints really stress people out. When stressed, some of the simpler problems tend to seem difficult. In case anybody is looking...

timmynew11 (6/4/2010)

---

I need to be able to write a query that will build a start and end date. The end date already exists but the start date will be...