Viewing 15 posts - 916 through 930 (of 26,487 total)
The following is what I came up with based on your original post. Please give it a try without adding the NOLOCK hint.
declare @StartDate date =...
October 3, 2018 at 11:18 am
It is telling you exactly what is wrong in the error message. There is an identity column in the tables and you are trying to insert an identity from one...
October 2, 2018 at 6:03 pm
October 2, 2018 at 5:17 pm
October 2, 2018 at 10:50 am
Just checking to see if you got the answer you were looking for her.
October 1, 2018 at 4:11 pm
Heh... performance is second only to accuracy so I'll have to disagree with...
October 1, 2018 at 3:11 pm
September 29, 2018 at 11:41 pm
September 28, 2018 at 4:01 pm
If it is the first row where PreviousTermDatePlusOne is NULL, that is reason; 20160701 <> NULL is not true therefore the result returned is 1. Actually that statement isn't false...
September 28, 2018 at 3:47 pm
September 28, 2018 at 3:40 pm
September 28, 2018 at 12:51 pm
Viewing 15 posts - 916 through 930 (of 26,487 total)