Viewing 15 posts - 226 through 240 (of 562 total)
mister.magoo (8/22/2016)
WHERE ABS(Float1 - Float2)<@Variance
So, for comparing to 2 d.p. I set @Variance = 0.01
to compare to 4...
August 23, 2016 at 8:43 am
Sergiy (8/21/2016)
..., because 1500-02-29 is not a valid date ....
If you have read my message, you can see that the mentioned dates have some importance to Columbus. I am only...
August 22, 2016 at 5:59 am
Steve Jones - SSC Editor (8/16/2016)
IF you or anyone else wanted to write an article, or series, on dealing with CSV...
August 18, 2016 at 1:28 pm
ChrisM@Work (8/16/2016)
How do you currently distinguish between data which is 'useful' and data which is not?
After the date is inserted and put into columns. The column_names (from the file) and...
August 16, 2016 at 6:54 am
The question was:
So how would you load/parse/store the data were all unnecessary data is filtered out before it is inserted ?
Given are the CSV files.
No additional Meta data is supplied.
The...
August 16, 2016 at 5:37 am
Sergiy (8/2/2016)
I believe building tables to hold the unnecessary data, load it, parse, store (even temporarily) will cause quite a performance hit. With no any benefits.Don't you think?
No I do...
August 15, 2016 at 2:15 am
Eric M Russell (8/11/2016)
"If you break a few eggs, then make an omelet."
Christopher Columbus,... challenges his critics to make an egg stand on its tip. After his challengers give...
August 11, 2016 at 6:22 am
At the time of Columbus there was no Gregorian calendar, so Columbus does/did not have to account for this.
For the last 3000 years the days of the week have followed...
August 11, 2016 at 4:16 am
ThomasRushton (8/2/2016)
That's to maintain compatibility with Lotus 1-2-3.
As often within software errors, once introduced are very difficult to eliminate. We rather define the reality as wrong and keep software 'bug'...
August 2, 2016 at 10:13 am
There were still some questions asked, I'll try to anwser them briefly.
Sergiy (7/26/2016)
August 2, 2016 at 10:00 am
John Mitchell-245523 (8/2/2016)
* This is of far more interest to us than it is to the original poster, who hasn't been seen here...
August 2, 2016 at 8:37 am
Sergiy (8/1/2016)
ben.brugman (7/21/2016)
spaghettidba (7/21/2016)
Dates have no format when they are stored in the databaseDates definitively have a format when they are stored in the database.
Dates do not have format stored...
August 2, 2016 at 7:51 am
Luis Cazares (7/22/2016)
ben.brugman (7/22/2016)
Luis Cazares (7/21/2016)
Similar logic, shorter version.
SELECT DATEADD(month,12*(YEAR(GETDATE())-1902)+3,0)
This is a bit 'short' I would guess:
SELECT DATEADD(month,12*(YEAR('20160401')-1902)+3,0) -- Result 2014-04-01 00:00:00.000
SELECT DATEADD(month,12*(YEAR('20160331')-1902)+3,0) ...
August 1, 2016 at 5:47 am
Luis Cazares (7/21/2016)
Similar logic, shorter version.
SELECT DATEADD(month,12*(YEAR(GETDATE())-1902)+3,0)
This is a bit 'short' I would guess:
SELECT DATEADD(month,12*(YEAR('20160401')-1902)+3,0) -- Result 2014-04-01 00:00:00.000
SELECT DATEADD(month,12*(YEAR('20160331')-1902)+3,0) -- Oops...
July 22, 2016 at 1:16 am
Viewing 15 posts - 226 through 240 (of 562 total)