Scott - I agree with Jeff in the sense that this test is somewhat unrealistic because you have CTE's and sub queries at your disposal. However, if this is a...

Scott - If you are not looking for the test results to be listed in a string, then I think this is what you are looking for.

create...

Completed script.

create table student_scores 
( 
student_id int NOT NULL,
score_date date NOT NULL, 
score int NOT NULL
);

insert into student_scores VALUES (1,'11/27/2020',80);
insert into student_scores VALUES (1,'12/01/2019',60);
insert into student_scores VALUES...

Acceptable data?

create table student_scores 
( 
student_id int NOT NULL,
score_date date NOT NULL, 
score int NOT NULL
);

insert into student_scores VALUES (1,'11/27/2020',80);
insert into student_scores VALUES (1,'12/01/2019',60);
insert into student_scores VALUES...

Thanks for this... A few questions.

Can you clarify the instructions? I will send you the script once I have completed it. I appreciate the help.

Not sure about the table structure....

• This reply was modified 3 years, 12 months ago by  Lord Slaagh.

Thank you both for the recommendations. Nice to see you again Phil.

Stay safe folks!

Thanks for the quick response, but my company will never allow a trigger in master.

Do you know of any SQL 3rd party tools that handle something like this?

Hi Phil,

Nice to hear from you. We are actually waiting for approval on this, but for now I am looking for something quick and dirty.

Thanks for your responses as usual....

Thanks very much for the baseline!

I see your point, anything is possible during an SP upgrade, but this gives me a great starting point.

Awesome, thank you!

Hi Chris,

Thank you for your quick response. Yes, we have all of that. Lastmodified, Startdate, Enddate, etc. It seems that this is the best method. I am in the process...

Hi Phil,

I am waiting on access to TFS, so yeah, it would be great if I could just grab the package itself. They only provided me with the...

Thank you all for your responses. I think I am going to avoid the MERGE 🙂

Yeah, that's what they did initially and it was killing performance. Production has millions of rows.

My task is to optimize this because everything gets UPDATED regardless if there...

Thanks Phil. It's funny, I assumed that would not work 🙁