That would make sense.

Was the query tried with that join added back in but the rest the way I wrote it?

Yeah, use varbinary instead of image.

And, even if you do all that unistalling and re-installing, will that actually do anything, or will Project Server still insist on creating databases on C drive of the SQL...

I'm getting a little lost in your question. What exactly is it that you want from all this data?

Also, would it be possible to provide table definitions (create statements)...

I'm still too busy chuckling about someone writing a post to complain about my use of English, while misusing elipses, commas, quotation marks, periods, sentence structure, paragraphs, and hyphens, all...

DC and others who brought up server traces as an option: Thanks. I wasn't aware of that option. Sounds like something to definitely investigate a bit.

declare @Date_in datetime -- input parameter

select @Date_in = getdate() -- or any other date

select dateadd(day, -1 * datepart(weekday, @date_in), @date_in) + 7

That will find the Saturday that follows any given...

To be precise, it's going to be supported still in 2008, but will be removed from "a future version".

The formats that will be allowed are:

expression [AS] column_alias

expression [AS] [column_alias]

expression [AS]...

I would expect the first run of a proc after a reindex and re-stat to be slow, since it's redoing its execution plan. After the first run, however, I...

On your prior thread, I can't get to page 2 of it (times out), so I can't tell if you looked at the query I wrote and tried it out....

I don't know about settings in Project Server. There probably is one, but I don't know where to even start.

I do know you could set up an automatic job...

I think the join you are looking for is:

left outer join longterm_rf_temp

on date_taken = dateadd(month, -1, month_year) + 1

and ?.main_id = longterm_rf_temp.main_id

You'll need to replace the...

I've seen that naming convention before. The DBA who established it as standard at the company he worked for pointed out that having the table name in the ID...

Inline functions are cached, just like procs. If they are deterministic (same results every time from same inputs), their results are cached and become quite fast.

When comparing them to...

Well, you could do something like:

select

(select count(*)

from dbo.Table1

where [1] = 'Yes') as Yes,

(select count(*)

from dbo.Table1

where [1] = 'No') as No,

... and so on

But you really might do better to...