Viewing 15 posts - 13,696 through 13,710 (of 59,063 total)
SELECT t2.Date,
t2.Credit,
t2.Debit,
SUM(COALESCE(t1.credit, 0) - COALESCE(t1.debit, 0))...
November 14, 2017 at 6:55 am
November 13, 2017 at 12:58 pm
November 13, 2017 at 12:43 pm
November 13, 2017 at 8:21 am
If both simplicity and performance are important AND the datetimes will always be > '2000-01-01', then the following will do the trick. (Replace the sample date with the column name).
November 13, 2017 at 8:15 am
November 13, 2017 at 6:21 am
Also Kiran, to John Mitchell's point, you ask a whole lot of questions on many forums that have simple and quick answers if you spend just a little time and...
November 13, 2017 at 6:14 am
Except for an old bug for log file growth being set to 4,000MB which, according to most, has been repaired, that answer as to what is causing TempDB to grow...
November 13, 2017 at 6:03 am
November 13, 2017 at 5:42 am
November 13, 2017 at 5:26 am
Viewing 15 posts - 13,696 through 13,710 (of 59,063 total)
