Viewing 15 posts - 2,776 through 2,790 (of 5,109 total)
Ok, this gets you MOST of the way there. Couple of things though:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 22, 2017 at 5:30 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 22, 2017 at 4:05 am
Is the task actually working though (did it create the PDF? The reason for SSIS reporting the error is as it says "The process exit code was "255" while the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 21, 2017 at 5:28 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 3:32 pm
I'm surprised you've said that string like '18th February 2015' are being returned with the LIKE statement (as they wouldn't).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 12:21 pm
I don't think '15 Mar 2017' Is the problem. For example SELECT CONVERT(date, '17 Mar 2017'); works fine.
In your sample data, as I'm going to mention...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 10:02 am
SQL Server 2008 Luis/Chris. 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 9:07 am
Steve has the right answer here. If you want to use SUM or AVG you need to normalise your data. Instead, consider a table such as: Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.USE Sandbox;
GO
Larnu.uk
October 20, 2017 at 8:57 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 8:32 am
OK, think I have it. Note that the "second" group 2 isn't returned, as all PEOPLE in that group have the value NULL:WITH CTE AS (
SELECT...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 7:52 am
I've tried this but I can't partition it in the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 7:38 am
A NULL has the lowest value when ordering.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 6:28 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 20, 2017 at 5:56 am
At a guess, your two charts don't have the same positioning. Are the top and height measurements on charts are identical? If one is in cm and the other inches,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 19, 2017 at 7:21 am
If you try to go to https://www.bing.com/maps on the server (from IE) what do you get? Also 403? I suspect this is a firewall issue.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 19, 2017 at 4:43 am
Viewing 15 posts - 2,776 through 2,790 (of 5,109 total)