Bit late 😀

I was looking for a similar question and found:DECLARE @DumbTable TABLE (cat CHAR(1), id TINYINT, rw TINYINT);

INSERT INTO @DumbTable SELECT 'A' as cat, 3 as id, 1 as...

Additional scripting for testing the special characters, to be run after the table is populated:

--

-- After creating and populating the table I reduce the number of groups TO 1

--

delete strings...

Hello Alan and others,

First thanks for supplying the scripts and the timings.

Great.

Alan.B (8/24/2016)

---

Well, well... 4,577 reads for the scalar udf vs 69,222 with the XML PATH method (regardless of special...

Alan.B (8/24/2016)

---

..........

storing the text as text (varchar or nvarchar) is the way to go if you're not doing that.

Note this article by Wayne Sheffield about this XML concatenation technique,...

This query:

select '1500-02-29' date, DATENAME(dw,'1500-02-29'), DATEPART(dw,'1500-02-29')

results in conversion error ....

Sorry I thought that the script was yours and that it resulted in...

Here is some sample data.

This data is adapted from:

http://www.sqlservercentral.com/Forums/Topic1744128-391-1.aspx#bm1744270

2015-10-12 7:09:13 AM (This is shown at my location).

First part of the data generates 40 000 words.

The words are quoted with...

mister.magoo (8/23/2016)

---

To answer your question about how (not getting involved in why)

the important things are to use ",type" in the FOR XML PATH... and to extract the ".value" of the...

Thanks mister magoo,

I can not confirm yet if this works, so I have to try that a bit later.

I'll...

Thanks all,

This is done from my tablet and therefore I have no code of example handy.

XML

is not the purpose and not a target it is only the means to get...

mister.magoo (8/22/2016)

---

when i need to compare two floats, I tend to use this syntax

WHERE ABS(Float1 - Float2)<@Variance

So, for comparing to 2 d.p. I set @Variance = 0.01

to compare to 4...

If you have read my message, you can see that the mentioned dates have some importance to Columbus. I am only...

Steve Jones - SSC Editor (8/16/2016)

---

This is really fascinating. Ben, thanks for a great discussion.

IF you or anyone else wanted to write an article, or series, on dealing with CSV...

ChrisM@Work (8/16/2016)

---

After the date is inserted and put into columns. The column_names (from the file) and...

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...

No I do...