Viewing 15 posts - 3,721 through 3,735 (of 5,109 total)
Will the spreadsheet(s) always be in the same format? Personally I would suggest that you upload the file(s) to a specific place, and store the name of the file in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2017 at 4:34 am
solus - Monday, May 15, 2017 3:32 AMmy login language is set to English
So, again, this is why 18/10/17 is failing, there...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2017 at 3:42 am
What's your full SQL statement, with your CREATE statement? I imagine that your CREATE statement is wrong, not your CTE statement. It should look something like this:CREATE...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2017 at 3:22 am
Spam is bad for your health, 🙁
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2017 at 3:07 am
The problem with sending the value @exchangeRate = 0 is because you have the following equation in your SQL:CAST((IDG.RELOCATION_EXP*@prev_exchangeRate)AS float)/ CAST(@exchangeRate AS float)
The part in bold...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2017 at 2:35 am
http://www.bbc.co.uk/news/health-39899646
Although they say that no patient data appears to have been compromised, makes me even more glad I probably haven't had to use the NHS in almost...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 10:07 am
solus - Friday, May 12, 2017 8:55 AMthis works
SELECT TRY_CAST('10/18/2016 00:00' AS date)I get
2016-10-18so sql server still thinks its US format
Have you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 8:57 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 8:38 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 8:27 am
This converts fine on my machine:SELECT TRY_CAST('18/10/2016 00:00' AS date)
Does that I can assume that you would see "18/10/2016" as the 10th day of the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 8:11 am
Firstly, let's find out what dates your SQL server doesn't like.
Could you give us some samples for the results that are returned for this query?SELECT...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 7:57 am
I was actually planning to use a Script Component and an ADO variable as the datasource, however, when I get to the second iteration I get no results from the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 7:21 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 5:05 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 3:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 12, 2017 at 2:48 am
Viewing 15 posts - 3,721 through 3,735 (of 5,109 total)