IIRC == "If I recall correctly" == hedge in case I'm wrong 🙂

For more info on Change Tracking...

CDC could do it too, of course, but it has more overhead and is available only in Enterprise Edition; it's overkill for what you've described you need.

Change Tracking should handle your situation easily and completely. IIRC, CT requires that the table have a PRIMARY KEY defined.

Of course not all CTEs are going to be updateable, it will depend on the specific coding of the CTE ;-).

You don't have to use two ROW_NUMBER() clauses/entries:

;WITH detail AS (

SELECT *, ROW_NUMBER() OVER (ORDER BY id) AS row_num

FROM #test

)

SELECT

...

I don't think that's right. I think SQL uses data...

I don't understand the totaling logic you want.

"TOTAL 700"?? Is...

I think so, but I couldn't swear to it. I think the differential bitmaps are restored as-is with the db, and not reset, but I'm not 100% sure. ...

That shouldn't really be necessary, assuming you still have the backups you used to do the...

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...