Viewing 15 posts - 2,731 through 2,745 (of 5,109 total)
My knowledge of C# is pretty low (I can read it, but not write it), however, maybe try some cell formatting. A Google brought me to this conclusion, however, this...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 9:39 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 9:23 am
You haven't named your column. For example:SELECT CAST(Start_Date AS date) AS Start_Date
FROM Table
WHERE Start_Date > GETDATE();
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 9:15 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 8:32 am
What do you think about wrapping the report execution in a try/catch? I'd...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 8:07 am
Not a great fan of looping through the parameters.
It's also worth noting that if you have a subscription running, and try to run it again (at least with...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 6:15 am
I've assumed that you will likely want to parametrise this. Without DDL and DLM, this is completely untested, however:DECLARE @DateFrom date, @DateTo date;
SET @DateFrom = '20171030';
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 6:10 am
Nevermind
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 6:01 am
Considering you're doing a COUNT, why not instead do:COUNT(CASE InspectionClosed WHEN '1900-01-01 00:00:00.000' THEN NULL ELSE InspectionClosed END)
NULLs are not counted when using the aggragate, so making those values...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 4:54 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 30, 2017 at 11:15 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 29, 2017 at 3:42 pm
This really isn't SQL related (well it isn't at all apart from my attempt to get multiple SQL instances running on a single Linux Machine), but anyone got any experience...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2017 at 5:25 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2017 at 3:17 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2017 at 10:55 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2017 at 7:28 am
Viewing 15 posts - 2,731 through 2,745 (of 5,109 total)