Viewing 15 posts - 13,966 through 13,980 (of 59,101 total)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2017 at 10:17 am
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2017 at 8:56 am
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2017 at 8:07 am
IF you believe that index fragmentation is actually a problem then, without question, one of the best there is was written by and is maintained by a fellow by the...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2017 at 7:58 am
Ah... the fly in the ointment with the double pivot shown above is that it still returns NULLs for missing entries and row totals are still a pain.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 8:19 pm
Correct. The GO has changed the scope to another batch.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 7:39 pm
I have the following table:
CREATE TABLE dbo.TimeTable (
WorkDate date,
EmpID int,
EmployeeName...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 5:20 pm
Heh... and they say that 2 part naming of the date parts is difficult and non-obvious. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 5:19 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 5:12 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 5:05 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 4:50 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 7:43 am
How about this approach:
DECLARE
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2017 at 7:30 am
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2017 at 10:26 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2017 at 10:15 pm
Viewing 15 posts - 13,966 through 13,980 (of 59,101 total)