Wow.

If they can handle the output in a slightly different format, then you can change it to:

SELECT [Year], SUM(EmployeePaid) * 2

FROM TblRecords

GROUP BY [Year];

If...

I notice that you use the data type "text". This data type has been deprecated a long time ago. Please consider replacing it with varchar(max).

Can you repost the sample data...

Based on what you post here, adding

WHERE propname <> '11 LR - 2BCMV'

should do exactly what you ask.

But it will probably not do what you actually need, so please do...

Please post CREATE TABLE statements for the tables involved (including constraints and indexes), INSERT statements with some sample data to illustrate the problem, the incorrect output you get now, and...

Please post CREATE TABLE statements for the tables involved (including constraints and indexes), INSERT statements with some sample data to illustrate the problem, the incorrect output you get now, and...

Wow, that's just terrible Jonathan.

I think you have two courses of action here.

First, go to the school's principal, file an official complaint, and request a refund.

Second, do not do the...

Looks like a formatting problem to me. Formatting should be handled on the client side, not by the database.

If you want to disregard that advice, then you'll need a "crosstab"...

So you want to add a generated column that can be combined with the Year column to become a composite candidate key? Okay.

"How do I do this in SQL Server?"

Run...

At first I had the server option selected as well.

Then I recalled that the connect option at server level is actually called CONNECT SQL, not just CONNECT, so I removed...

zacharywenta (2/2/2016)

---

To reply,

I have put a primary key of "id" in every entity because my intuition tells me that an auto-incrementing int will distinctly represent a unique row in each...

Ed Wagner (2/2/2016)

---

Hugo Kornelis (2/2/2016)

---

Note of warning to ramachandran narayanan:

The solution posted by chalam87 (which is about equal to a solution posted to one of the other locations where you...

Okay, I'm going to rough you up a little but to no ill intentions. Endure it and you will learn. (Hmmm, does this make me feel like Miyagi?)

First: Why do...

Yes,...

Good, that's anice starting point.

Now you still have to do a lot of testing. Don't forget to do thorough stress testing as well, changes in the cardinality estimator are known...

If the storage vendor can guarantee that the SAN snapshot is taken at the exact same time for all drives, *and* they can guarantee (together with the VM administrator) that...