All thanks for your time and attention.

I started of with the post:

http://www.sqlservercentral.com/Forums/Topic1760478-3412-1.aspx

And tried to construct a solution from the solution presented there.

That was a bad idea. Spend some...

drew.allen (12/20/2016)

---

Most approaches that I've seen collapse the ranges. That is, they don't retain a record with a zero length. Is there a particular reason that you need...

Yes this does help. Thanks.

Although...

GilaMonster (12/1/2016)

---

Keep in mind that the isolation levels affect the behaviour of *read* queries, not data modifications for the most part.

Repeatable read vs read committed: can two identical selects within...

Yes they are WHacked.

Try forcing a loop join reading first from the ranges table like this:

SELECT *

FROM...

Here is a 'fairly' simple solution to your problem.

First a table is 'created' which contains the totals for each column.

Then this table is used to calculate the percentages for all...

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

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