Viewing 15 posts - 2,311 through 2,325 (of 2,643 total)
August 9, 2018 at 4:33 am
August 8, 2018 at 8:41 am
Hi experts,
The stored procedure executes only with the Warning. But when it executes from the...
August 8, 2018 at 6:32 am
Using VM's and SANS, is there any...
August 8, 2018 at 6:07 am
DECLARE @Increment Int = 0 -- or -1
SELECT
CT.claim_type_name AS ClaimType,
COUNT(CM.claim_type)...
August 8, 2018 at 5:34 am
August 8, 2018 at 2:15 am
August 7, 2018 at 8:39 am
August 6, 2018 at 1:48 pm
Putting the semicolon at the beginning of a CTE is my biggest pet...
August 6, 2018 at 1:16 pm
I do not like punctuation it is too small to look significant and easily missed.
I have convinced myself (maybe wrongly) that a semicolon is not a statement terminator...
August 6, 2018 at 11:59 am
It can be done without using a self join, using just windowed functions:;WITH CTE AS
(
SELECT t1.EmpName,
t1.Deduction,
t1.YearMonth,
...
August 6, 2018 at 10:21 am
August 6, 2018 at 10:05 am
Another thing you could do, provided your database isn't really busy and the stored procedures aren't massive is occasionally force a recompile of all of them by issuing a DBCC...
August 6, 2018 at 6:05 am
Viewing 15 posts - 2,311 through 2,325 (of 2,643 total)