Grant Fritchey (6/9/2015)

---

ericpap (6/9/2015)

---

Alvin Ramard (6/9/2015)

---

ericpap (6/9/2015)

---

Alvin Ramard (6/9/2015)

---

I can't help but wonder if someone is trying to "reset the clock" to prevent the RTM version from expiring.

Have you discussed...

If you're on LinkedIn, then I'm surprised you're only been contacted by "a couple" of recruiters. You must have neglected to mention "SQL Server" somewhere in your profile.

But personally...

ericpap (6/9/2015)

---

Alvin Ramard (6/9/2015)

---

ericpap (6/9/2015)

---

Alvin Ramard (6/9/2015)

---

I can't help but wonder if someone is trying to "reset the clock" to prevent the RTM version from expiring.

Have you discussed this problem...

I use a local install...

Steve Jones - SSC Editor (6/9/2015)

---

I like the use of the OUTPUT clause there. Much simpler than trying to build a transaction. It would also work with larger volumes if...

Jeff Moden (6/9/2015)

---

Eric M Russell (6/9/2015)

---

Jeff Moden (6/8/2015)

---

Andy Warren (6/8/2015)

---

Jeff, maybe I didnt ask the question well. I'm not arguing with your choices - yours to make! Just curious to...

This reminds me of a discussion from a few months back:

http://www.sqlservercentral.com/Forums/FindPost1673628.aspx

One approach is sliding window table partitioning. The rows can also age off into a ReadOnly partition. All rows can...

I'm assuming the goal here is to have USD_Sales populated only on the lowest ranked row within a group.

I've found the simplest, most flexible, and often the most performant approach...

If you want to return a result of rows from one set that are not included in another set, then EXCEPT is the...

Jeff Moden (6/8/2015)

---

Andy Warren (6/8/2015)

---

Jeff, maybe I didnt ask the question well. I'm not arguing with your choices - yours to make! Just curious to understand if/why joining a company...

DonlSimpson (6/8/2015)

---

Lynn Pettis (6/8/2015)

---

Personally, I think the query is correct. Masking of the subsequent sales amounts should occur in the front end application or report, not at the back...

Reply back with a simplified example of what the query result would look like.

If you want to calculate a checksum across multiple columns and rows, then you can can wrap checksum_agg() around checksum() like this:

checksum_agg(...

Or like you said originally, this could be done using INSTEAD OF triggers.

For example, you could create a ClosedPeriods table containing one row for each closed period. Using this method...

bimplebean (6/8/2015)

---

Eric: Thanks very much for the helpful information regarding the number of records needed before partitioning becomes required. It may be that I'm worrying over a problem that won't...