Viewing 15 posts - 16 through 30 (of 117 total)
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...
Everyone has a plan until they get punched in the mouth. --Mike Tyson
November 28, 2020 at 6:46 pm
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...
Everyone has a plan until they get punched in the mouth. --Mike Tyson
November 28, 2020 at 6:13 pm
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...
Everyone has a plan until they get punched in the mouth. --Mike Tyson
November 27, 2020 at 8:36 pm
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...
Everyone has a plan until they get punched in the mouth. --Mike Tyson
November 27, 2020 at 8:14 pm
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....
Everyone has a plan until they get punched in the mouth. --Mike Tyson
November 27, 2020 at 7:10 pm
Thank you both for the recommendations. Nice to see you again Phil.
Stay safe folks!
Everyone has a plan until they get punched in the mouth. --Mike Tyson
October 29, 2020 at 8:02 pm
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?
Everyone has a plan until they get punched in the mouth. --Mike Tyson
February 25, 2020 at 9:41 pm
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....
Everyone has a plan until they get punched in the mouth. --Mike Tyson
February 21, 2020 at 5:20 pm
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.
Everyone has a plan until they get punched in the mouth. --Mike Tyson
January 21, 2020 at 7:20 pm
Awesome, thank you!
Everyone has a plan until they get punched in the mouth. --Mike Tyson
October 18, 2019 at 6:16 pm
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...
Everyone has a plan until they get punched in the mouth. --Mike Tyson
October 18, 2019 at 4:52 pm
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...
Everyone has a plan until they get punched in the mouth. --Mike Tyson
July 3, 2018 at 9:05 am
Thank you all for your responses. I think I am going to avoid the MERGE 🙂
Everyone has a plan until they get punched in the mouth. --Mike Tyson
June 12, 2018 at 1:24 pm
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...
Everyone has a plan until they get punched in the mouth. --Mike Tyson
June 4, 2018 at 3:13 pm
Thanks Phil. It's funny, I assumed that would not work 🙁
Everyone has a plan until they get punched in the mouth. --Mike Tyson
May 10, 2018 at 11:40 am
Viewing 15 posts - 16 through 30 (of 117 total)