Viewing 15 posts - 4,081 through 4,095 (of 5,111 total)
Without consumable Sample data or DDL, here's something to get off your feet:WITH ServerList AS (
SELECT {Your Columns},
ROW_NUMBER() OVER (PARTITION BY...
March 16, 2017 at 3:46 am
March 16, 2017 at 2:57 am
March 15, 2017 at 12:09 pm
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...
March 15, 2017 at 10:38 am
Without consumable data, but maybe a simple SELECT DISTINCT...?
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...
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...
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...
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...
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....
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...
March 15, 2017 at 3:45 am
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.
March 14, 2017 at 11:06 am
March 14, 2017 at 10:46 am
Viewing 15 posts - 4,081 through 4,095 (of 5,111 total)