Viewing 15 posts - 886 through 900 (of 5,109 total)
You probably don't want to publicly expose your email address; bots do scan everything on the internet, and they will sell that address onto mailing lists.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 25, 2019 at 7:47 am
My first thought is that the Z:\ drive is a user mapped drive, which the server has no access to. Can you use the fully qualified name (\\server\share\folder\filename)?
And when...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 9:40 pm
What is strange is that why the dash makes a difference in as yyyy-mm-dd to yyyymmdd. Is this not considered an issue with date handling in MS-SQL?
It's specifically a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 2:41 pm
Languages are there for a reason, and they do have impacts on "simple" things such as the date here. The important part is that you code appropriately and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 2:21 pm
Well that would make me ask: what is the point of having a language setting? .
Not everyone speaks English. If every error message was in English, and things...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 1:52 pm
You're using the format yyyy-MM-dd and the datetime datatype. For datetime that format is ambiguous and is interpreted differently depending on the langauge. The only formats, regardless of language and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 1:35 pm
I would just change the language of the login to from British to English to fix it though.
Is that really the solution? Applications, and code, should be language ambiguous....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 1:22 pm
yyyy-MM-dd didn't work in 2008 either, if the data type was datetime. It will be interpreted as yyyy-dd-MM for datetime using the British language in both versions. Perhaps you were...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 12:47 pm
Thanks for the pointers for dynamic sql . it has to come from FROM clause.
Then you need to change from statement from a SET to a SELECT and include...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 11:09 am
As you discovered, you can't index a View that has a UNION in it. In truth, if you need this type of design it does indicate a design flaw; if...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 9:34 am
Thanks for all the inputs.
What solved your problem here? Rather than just saying "thanks" if you let us know what solution you used it'll help people in the future...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 8:37 am
In a text file NULL is provided by the absence of a value. If you have the string "NULL", it no longer has no value, it has a value. If...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 8:06 am
The error appears to be letting you the problem here:
Msg 207, Level 16, State 1, Line 47
Invalid column name 'logicalname'.
In your statement you have '...''' + logicalname + '''...' but...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 24, 2019 at 8:02 am
This looks a bit like a homework question. If so, what have you tried so far to solve the problem yourself? What, if you haven't tried, have you researched to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2019 at 1:37 pm
If you already have a process, what's wrong with what you have? It doesn't seem to be that time consuming; run a back up, restore it (on a different server)...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2019 at 10:47 am
Viewing 15 posts - 886 through 900 (of 5,109 total)