Viewing 15 posts - 886 through 900 (of 5,111 total)
Guessing this was resolved, as you can find the topic here.
June 25, 2019 at 2:22 pm
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.
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...
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...
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...
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...
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...
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....
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...
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...
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...
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...
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...
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...
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...
June 23, 2019 at 1:37 pm
Viewing 15 posts - 886 through 900 (of 5,111 total)