Bingo. Compatability was 80.

I've never seen that before. So ?currentdb.Name in the immediate window does not return the correct path?

james.morrison 19355 (6/22/2011)

---

mike.mcquillan (6/22/2011)

---

The one thing I have learnt from the interview process is MAKE THEM WRITE SOME CODE. I never used to do this and made some bad hires...

Ya, major PITA. Screw everything about that. :pinch:

On both my 2005 and 2008 servers, I get

Msg 4104, Level...

Very nice club to have in the bag. Saved.

I had to qualify this part

FROM

...

So here is my update, as promised, unabridged. I put the additional column and new trigger into production yesterday...and a part I didn't test before, the generate billing screen, returned...

You have to be very careful with this type of trigger. It's an UPDATE only trigger, which means if someone updates the date received field by itself in the ReceiveOrder...

This is what your query looks like when formatted, but seems like an extra parentesis is at the end:

select answered = sum(

CASE WHEN

sf.answerNumeric IS NULL AND (sf.answerText IS NULL...

What do yall think about giving the interviewee a "broken" database to analyze? Script out one of your databases except remove some indexes, rewrite a basic update statement to use...

tfifield (6/10/2011)

---

Todd,

Messing with proprietary apps like this is probably asking for more trouble than it's worth. I've had to do it and I've found it's usually easier and more...

Why not?...

Use something like this to create your view (this creates a view a script that creates a view that combines all of my _Contacts tables, obviously.):

DECLARE @My_View VARCHAR(max)

DECLARE @stmt VARCHAR(1000)

PRINT...

We use SQL Diagnostic Manager. http://www.idera.com/Products/SQL-Server/SQL-diagnostic-manager/

Lots of green and red buttons and dials and charts and alerts!

rjshupert (6/15/2011)

---

So thanks for the sample. It was very close, I tweaked it to this:

(COALESCE(Database_Status,Instance_Status) = N'deployed' or is null)

And it's now displaying the expected results. Thanks so...

Coalesce returns the first non-null argument in the list. So this statement will compare Database_Status when it is non-null, but compare Instance_Status when Database_Status is null.

Check out http://msdn.microsoft.com/en-us/library/ms190349.aspx

You can also...