Interesting solutions there gentleman, but regardless of how you set up your PRIMARY KEY/INDEXing, might this not be just a tad simpler?

SELECT name,

=MAX(

)

FROM

(

SELECT name,

='TableA'

...

Making the assumption that APHQualified comes from your vwStudentsFiltered table, maybe this is what you really wanted.

--alter view vwStudentsAPHQualificationSummary as

select DistrictNum, DistrictName, APHQualified, sum(QualificationCount) as QualificationCount

from

(

select...

I think this does the same thing and it looks a little easier on my eyes.

--alter view vwStudentsAPHQualificationSummary as

WITH StudentAPH_CTE (DistrictNum, DistrictName, APHQualified, QualificationCount)

AS

(

select st.DistrictNum,

...

ScottPletcher (4/20/2015)

---

dwain.c (4/19/2015)

---

ScottPletcher (4/17/2015)

---

The on-going maintenance is higher for an INSTEAD OF trigger, since every column addition or deletion, and some column changes, all requires changes the trigger, which is...

domingo.sqlservercentral (4/20/2015)

---

I found examples for many columns, as below:

CONSTRAINT chk_Person CHECK (P_Id>0 AND City='Sandnes')

but... it works independly for these columns, as two simple check constraints. I need a rule for...

domingo.sqlservercentral (4/19/2015)

---

Hello,

I'm sorry for error in the topic title, intentional is:

"validation rule" on a row of table?

I'm looking for validation data in the table - when inserting or updating the...

dwain.c (4/19/2015)

---

Eirikur Eiriksson (4/19/2015)

---

Grant Fritchey (4/19/2015)

---

Eirikur Eiriksson (4/19/2015)

---

spaghettidba (4/19/2015)

---

Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to...

Eirikur Eiriksson (4/19/2015)

---

Grant Fritchey (4/19/2015)

---

Eirikur Eiriksson (4/19/2015)

---

spaghettidba (4/19/2015)

---

Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do...

ScottPletcher (4/17/2015)

---

The on-going maintenance is higher for an INSTEAD OF trigger, since every column addition or deletion, and some column changes, all requires changes the trigger, which is not the...

Naive, eh Eirikur? Hehe. I like that.

As I said it's been awhile since I was playing around with functional encapsulation of this process, and because of the elapsed...

Here's a quick example:

CREATE TABLE dbo.MYTABLE(

ID...

Oh yes, I forgot to mention the reason why you can't use that CROSS JOIN to repeatedly update is A Hazard of Using the SQL Update Statement [/url]

Alan.B called me out through a PM to this thread, so you can thank him for what follows assuming it works for you.

If I understand correctly, this is an operation...

Not sure. Where's Joe Celko when you need him?

Why has no one mentioned using an INSTEAD OF INSERT TRIGGER?

It would seem to me that this would take care of the audit issue.