Easiest way to accomplish this is to make the column read only when doing updates. Obviously you need to be able to enter a value when initially creating an...

Brandie Tarvin (3/14/2016)

---

Being fair,...

pietlinden (3/13/2016)

---

What I need to do is a sort based upon the birthdate, lang, and pernum.

Basically the sort for birthdate should meet the following criteria:

a. If a student is under...

Shouldn't this have been your first stop before going online?

Forum etiquette would have you post your solution for others to see as your solution...

Ed Wagner (3/12/2016)

---

MotivateMan1394 (3/11/2016)

---

Thank you all

And dear Lynn Pettis :

The big question here, is this something your employer is tasking you to accomplish or are you just trying to find...

Look at using a recursive CTE to walk through the hierarchy. If you need additional help please post the DDL (CREATE TABLE statement) for the table(s) involved, sample data...

Why are your users even seeing the audit columns? They should not have the ability to insert or update these values. They should be hidden from the users....

There may be a way to improve the process but it would require intimate knowledge of database to accomplish and would take significant effort. I was tasked with a...

This is my best guess with nothing to test it against.

select

sl1.smlPartID,

sum(case when sl1.smlCreatedDate >= DATEADD(month,-12,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) ) and

...

This is the catch block I have in a stored procedure, does this help?

begin catch;

...

Making it easier for others:

https://msdn.microsoft.com/en-us/library/mt614935.aspx

I don't think so since the OP only wants to see one row for each...

This:

with basedata as (

select

rn = row_number() over (partition by id order by date_created desc),

id,

date_created,

amount

from

...

Steve Jones - SSC Editor (2/27/2016)

---

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they will get more...