First of all thanks to all the contributors of this thread.

Allthough this thread and all the links (and indirect links) is a bit overwelming.

I have allready learned a lot and...

Jeff Moden (4/1/2016)

---

Sachin Nandanwar (3/31/2016)

---

Why would you want to do string processing using TSQL ? Please see the attached image. I wrote this in C# in less than 20 minutes.It...

As Promissed this is what I reached on Friday, but now cleaned.

It is still not 'complete'.

Known problems:

Performance.

In some situations where a string is started with a double qoute, this is...

Sachin Nandanwar (3/31/2016)

---

Why would you want to do string processing using TSQL ? Please see the attached image. I wrote this in C# in less than 20 minutes.It can be...

Eirikur Eiriksson (3/26/2016)

---

I would say more like 99.99% there:-D

😎

The...

Luis Cazares (3/25/2016)

---

It doesn't need to be a comma or a semicolon. You could use different control characters that are unlikely to be in any current text. Read the "Unlikely...

Probably most CSV's...

Thanks for the link. I have to process this,...

mehta.saurabhj (3/2/2013)

---

The sql code to find odd number of records is:

select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);

But if I do the foll code for odd...

According to Knuth's definition, a B-tree of order m is a tree which satisfies the following properties:

1. Every node has at most m children.

2. Every non-leaf node (except root) has...

Hugo Kornelis (2/28/2016)

---

You write that it is important for your project to show the exact time - so why not stop the rounding/truncating completely and show milliseconds as well? (Note...

Found a solution with an indexed view.

Both selections on a recent period and on a period in the past perform fast.

The indexed view:

CREATE VIEW dbo.Vtesttable_recent

WITH SCHEMABINDING AS

SELECT

...

No, not limited to this system. More to get some good grip range queries. (With variations.)

this...

The model (from another thread) is to learn...

We have a number of 'models':

Legacy: Build in house the operating system and the DBMS, running since 1973.

SQL-server 1: In house designed/build database. (From the second part of the 90ties)

SQL-server...