Aug
30
comment SSIS sysssislog table - Is Starttime or EndTime logged as UTC?
thank you @lamu
Aug
30
accepted SSIS sysssislog table - Is Starttime or EndTime logged as UTC?
Aug
30
comment SSIS sysssislog table - Is Starttime or EndTime logged as UTC?
sorry, was that comment directed at me @Larnu? I am using SSISDB
Aug
30
asked SSIS sysssislog table - Is Starttime or EndTime logged as UTC?
Jul
25
answered How to select records only if a specific condition is met
Jul
19
accepted C# Text before specific character
Jul
19
revised C# Text before specific character
added 18 characters in body
Jul
19
asked C# Text before specific character
Jun
19
revised TSQL Running Total but only based on Logic
added 1 character in body
Jun
16
revised TSQL Running Total but only based on Logic
deleted 3221 characters in body
Jun
15
comment TSQL Running Total but only based on Logic
I state in my question the explanation to the "missing -1.0" ; *The rule here is that when the total of HrsEarned and HrsBooked is < 0 then deduct this total from HrsEarned from the next row. *
Jun
15
revised TSQL Running Total but only based on Logic
added 186 characters in body
Jun
15
asked TSQL Running Total but only based on Logic
Jun
12
awarded Student
Jun
12
comment SSRS Export to Excel Very Slow
@SimonRichardson as stated in the question I've tested the query directly in excel and it's mush faster in comparison. I was thinking I've missed a optimisation trick somewhere. thanks anyway
Jun
12
revised SSRS Export to Excel Very Slow
deleted 2 characters in body; edited tags
Jun
12
asked SSRS Export to Excel Very Slow
May
24
awarded Commentator
May
23
answered How to handle a subquery with no results?
May
23
answered converting rows to column for a set of ids
1 2 3 4