MAX(age) seems safe enough -- no one gets any younger :-).

Combining MIN(name) and MAX(name) would allow one name change ... that should handle everyone, right!?

/*

insert into #temp(id,name)

select 2,'Jane Single'

insert into...

No, but I do know that you're never supposed to remove the Guest account from master. Basically SQL requires it. Put it back and try again before making...

Something like below. If the LAST_NAME and FIRST_NAME are in the same table (shouldn't be, from a design standpoint), then you can remove the outer query and join and...

DarthBurrito (11/13/2013)

I will get a false 1 since the modifieddate will always be larger than the ClosedField that has a NULL.

How can I tell it when the DateClosed field is...

a20213 (11/7/2013)

---

Perfect Mr. Scott.

Indeed, the same day of week has to be the same, mandatory.

PS: When you say "So, adding 6 mos gives a date of '2014-11-05', which becomes '2014-11-11',...

None of that is necessary: a simple calculation can give you the future date you need.

The code below assumes you want a future matching-day date on or after the months-added...

You should also consider using option "SORT_IN_TEMPDB = ON" in the rebuild. That should give you about the same space gains without having to use a separate fg within...

1. The only way to rebuild heaps is to add a clustered index; you can then drop it. Since, however, adding or dropping a clus index requires rebuilds...

SELECT

MatchID, KeyCode,

CASE KeyCode

WHEN 'MTDT' THEN CONVERT(varchar(100), MatchDate, 101)

...

Safer might be:

WHERE

FtgNr NOT LIKE '[^0-9][^0-9]%1'

Unless you really want "alphabetic" rather than "non-numeric" as originally stated. Spaces, underscores, periods, etc., would fail this test but pass the other one...

RVO (11/4/2013)

---

ScottPletcher,

We don't have authority to alter table definitions.

This is Financial Application database by third party.

We don't own the database.

We even create all our custom code in a separate (Diff_Data)...

I think the clustered index should be ( accounting_period ) or, if you prefer, ( accounting_period, prj_code ) rather than the other way around. I don't think phase_code needs...

Please post the DDL, including all indexes, for the "prj_detail" table.

If the clustered index is on an identity column, you should almost certainly change it to "accounting_period" instead. This...

Instead of DDL_LOGIN_EVENTS, you can use DDL_SERVER_SECURITY_EVENTS, which covers a much wider range of statements. See BOL, "DDL Event Groups" for more details.

You'll need to use EVENTDATA() from within...

Kurt W. Zimmerman (11/1/2013)

---

clayman (11/1/2013)

---

Kurt W. Zimmerman (11/1/2013)

---

clayman (11/1/2013)

---

Kurt W. Zimmerman (11/1/2013)

---

If I'm going to move data from one server to another via Import/Export I will script out...