UPDATE CurrMonth

SET [PrevPerc] = PrevMonth.[CurrPerc]

FROM #Month CurrMonth

INNER JOIN #Month PrevMonth ON

PrevMonth.[DEPARTMENT] = CurrMonth.DEPARTMENT AND

PrevMonth.[YEAR] = CurrMonth.[YEAR] - CASE WHEN CurrMonth.[MONTH] =...

I wouldn't use PARSENAME here because of potential side effects, for example, periods (.) in the data or brackets ([]) around a piece of data. The code below should...

Yeah, it wasn't intended to be used that way, so my guess is it wouldn't work all that well for that. Even performance could become a real issue at...

Something like this may do it for you:

SELECT

tn.ID, tn.Status, tn.Description, tn.[Project Number],

ColNames.ColName

FROM dbo.tablename tn

INNER JOIN (

SELECT 'FreeText01'...

Grant Fritchey (9/4/2013)

---

ScottPletcher (9/4/2013)

---

I admit, this is my pet peeve in physical table design. Identity as clus key is ridiculously over-, and, thus improperly, used. So I get...

Grant Fritchey (9/4/2013)

---

ScottPletcher (9/4/2013)

---

I'd disagree...

I'd disagree even with that;...

Are schema names specified on the tables in the query? If not, what are the default schemas of the two users running the queries?

@DaveDB:

You're quite right. There's no genuinely good reason for the "default" clustering key to be an identity column. Many people just do it by rote, without thinking about...

SELECT

[Database],

MAX(CASE WHEN MONTH(ReportDate) = 01 THEN Size END) AS Jan,

MAX(CASE WHEN MONTH(ReportDate) = 02 THEN Size END) AS...

Patti Johnson (9/4/2013)

---

Thank you so much for your help. I've been digging and digging so I appreciate your time.

IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

AND EXISTS(SELECT 1 FROM sys.database_mirroring WHERE...

Patti Johnson (9/4/2013)

---

I have added what was suggested:

IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

BEGIN

use archer

SET NOCOUNT ON

END

It looks good until you execute and I...

Try this:

IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

BEGIN

...

END

You don't want to use a function against the END_DATETIME column if you can avoid it, since any function will prevent SQL from using the full seek capabilities against that...

Don't forget restore damaged instance. That is the most complex recovery. Particularly test for master, model and msdb.