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

First, I'd suggest a column called ClosedDate. But until you scale up to several millions of rows, then partitioning your table(s) for the sake of performance is not worthwhile. However,...

Take a look at the CHECKSUM() and CHECKSUM_AGG() functions.

If you want to know the salary of a specific US federal employee, someone has created a user friendly website using public data.

http://www.fedsmith.com/2013/04/29/locating-the-salary-of-an-individual-federal-employee/

Jeff Moden (6/8/2015)

---

Eric M Russell (6/8/2015)

---

Even if the company were financially stable, the IT...

Even if the company were financially stable, the IT projects interesting, and the published...

David.Poole (6/7/2015)

---

HR = Human Resources. If I am going to buy (hire) a resource then both I as a manager and the future employee both have an acceptable range...