Viewing 15 posts - 136 through 150 (of 1,354 total)
I mean that it will usually be impossible to tell whether Table C is joining to the initial state of A or joining to the results of joining A...
September 14, 2018 at 1:04 pm
That's not true at all. Here is an easy demonstration of that fact.
You demonstration doesn't prove anything. Changing one of the INNER JOINS to an outer...
September 14, 2018 at 12:50 pm
Table C is joining to Table A's initial state. But the final result will be affected by both, so I'm not sure that the question isn't semantics at one level. ...
September 14, 2018 at 12:14 pm
If the dates are stored as dates rather than integers, a simple DATEDIFF(dd,StartDate,EndDate) works just fine and saves on many other issues above and beyond what an abstracted integer...
September 6, 2018 at 7:15 am
September 5, 2018 at 7:45 am
Well, may be transactional support and data integrity control might be named advantages, but I bet you can find (NOLOCK) in every query, which eliminates those advantages.
September 4, 2018 at 8:22 pm
I understood this the way Phil did. You didn't really spell it out clearly in your opening post.
What issues do your users have when the data mart is...
September 4, 2018 at 5:00 am
August 31, 2018 at 7:37 am
CONVERT(VARBINARY(4000),CONVERT(BINARY(4),StaffID))
The code you provided looks very useful and thorough. But...
August 30, 2018 at 7:29 am
I'm with you that I generally try to play it safe. Sometimes I've taken risks. Some of those paid off. Some not so much.
August 30, 2018 at 7:24 am
Viewing 15 posts - 136 through 150 (of 1,354 total)