Viewing 15 posts - 1,351 through 1,365 (of 4,087 total)
January 16, 2018 at 1:18 pm
January 16, 2018 at 12:47 pm
January 12, 2018 at 2:56 pm
Are you really on SQL 2008? This is a lot easier on SQL 2012.
Also, using an rCTE for calendar generation is extremely inefficient. Here is a better approach...
January 12, 2018 at 1:54 pm
:crazy:
I had to reset my windows password today and kept having troubles. It turns out that the 12-character password that I had entered was TOO LONG. REALLY!?! 12...
January 12, 2018 at 10:21 am
It sounds like you want to use NTILE instead of MOD.
Drew
January 11, 2018 at 11:34 am
January 11, 2018 at 9:48 am
As I mentioned, there are two sources of NULLs. You could use the brute force method and treat all NULLs the same or you could use a more finessed approach...
January 11, 2018 at 8:26 am
January 10, 2018 at 1:38 pm
January 10, 2018 at 1:32 pm
January 10, 2018 at 11:39 am
He has a columnar report that fills the columns top-to-bottom then left-to-right. He wants to change the order of the fill to left-to-right then top-to-bottom.
This is a presentation...
January 10, 2018 at 9:17 am
This appears to be a presentation issue and is best handled in the presentation layer. Is there a compelling reason for trying to do this in the database layer?
January 9, 2018 at 2:10 pm
Viewing 15 posts - 1,351 through 1,365 (of 4,087 total)