Viewing 15 posts - 4,081 through 4,095 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 16, 2017 at 2:57 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 12:09 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 11:56 am
So, strangely... it's now working fine. I just went to run my original process (which I haven't changed since making my post yesterday) to get a screenshot for you, and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 10:38 am
Without consumable data, but maybe a simple SELECT DISTINCT...?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 9:55 am
Hmmm, frustrating that it doesn't replicate at your end then. Out of interest how are the dates coming through? Mine come through as INTs, however, your conversion error implies they're...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 9:13 am
Should of stated actually, but i'll double check, the problem was in the ClaimNumber column, with claims in the YOA 2015 and 2016. Assume they all looked fine?
If...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 8:39 am
Snargables - Wednesday, March 15, 2017 8:27 AMsorry, i was looking in the wrong folder. It's in C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio
Yes, SSMS...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 8:30 am
Hi Phil,
Hopefully this is everything you need. please do tell me if you need anything else. You should just need to change the parameter to the location of...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 7:17 am
Phil Parkin - Wednesday, March 15, 2017 5:42 AMYes, please do. I'd like to have a go at solving this one.
Will do....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 6:07 am
Ok, that took me far longer than I'd wanted, there might be a better way, but it's how i got to where I wanted, so if others want to add...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 3:45 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 15, 2017 at 2:52 am
Oh wow... That's messier than I'd hoped. Will see what I can do, but don't expect a response from me till tomorrow.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 14, 2017 at 11:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 14, 2017 at 10:46 am
Did you test that code? It doesn't run:
Msg 207, Level 16, State 1, Line 11
Invalid column name 'Schedule'.
Msg 207, Level 16, State 1, Line...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 14, 2017 at 10:41 am
Viewing 15 posts - 4,081 through 4,095 (of 5,109 total)