Viewing 15 posts - 2,701 through 2,715 (of 5,109 total)
My C# isn't great, especially when code is given in one single (unreadable) line. My guess is that this is a Delimited String Splitter? If so, a simple Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2017 at 2:43 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 1:14 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 1:06 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 12:47 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 12:43 pm
Sue_H - Wednesday, November 1, 2017 11:12 AMWait until they have spreadsheet isolation levels.
Oh... are those apart of the rumoured...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 11:18 am
It might also be worth seeing what the SQL that the report is actually running is. Use Extended Events to capture the SQL and run it yourself and see if...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 11:16 am
Firstly, let's have something that's (marginally) more readable than a single line of text:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 11:04 am
ISNULL returns the value of the second parameter if the first parameter has the value NULL. So, in the case, if the value of c.Folldate is NULL, then the value...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 10:27 am
I all honesty, I hate the JET/ACE drivers. I'd take a CSV, tab-delimited, etc, or even a fixed width file over a .xls(x) any day. I least then I can...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 10:23 am
It will allocate 700MB when you create it; hence why it's called Initial datafile size. 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 10:05 am
Duplicate of https://www.sqlservercentral.com/Forums/1905612/Unable-to-build-Visual-Studio-database-solution-when-using-OPENJSON
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 10:00 am
There was a security update for Windows that may have affected this. Try downloading...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 9:25 am
Use 3NF (3rd Normal Form). You should never be adding extra columns for repeating items, you should be adding extra rows. If you require a unique ID, then add one...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 9:12 am
Without DDL and consumable Sample Data, this is untested, and I have assumed that the First, Middle, and Last names will be the same in both copies, but this might...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 8:20 am
Viewing 15 posts - 2,701 through 2,715 (of 5,109 total)