What I have read, heard or seen on 2016-12-13.
A nice T-SQl piece of code to split a string with FTparser in SQL Server 2008+: Split string with sys.dm_fts_parser
Also, I learned how to read data from SQL Server into RMarkdown:
library(RODBC)
cn <- odbcDriverConnect(connection="Driver={SQL Server};server=.;database=test;trusted_connection=yes;")
myQuery <- sqlQuery(cn, "
-- Create table
SELECT *
FROM MyTable
")
myQuery## id text
## 1 1 You can write me an email
## 2 2 on my private email address: tomaz.tsql@gmail.com
## 3 3 or even on this imaginary email address tomaz.tsql@nowhere.at
## 4 4 or on my fake non-existing email address not-exist@all
## 5 1 You can write me an email Bob
## 6 2 on my private email address: tomaz.tsql@gmail.com
## 7 3 or even on this imaginary email address tomaz.tsql@nowhere.at Bob
## 8 4 or on my fake non-existing email address not-exist@all
## 9 1 You can write me an email Bob
## 10 2 on my private email address: tomaz.tsql@gmail.com
## 11 3 or even on this imaginary email address tomaz.tsql@nowhere.at Bob
## 12 4 or on my fake non-existing email address not-exist@all
## 13 1 You can write me an email
## 14 2 on my private email address: tomaz.tsql@gmail.com
## 15 3 or even on this imaginary email address tomaz.tsql@nowhere.at
## 16 4 or on my fake non-existing email address not-exist@all
## 17 1 You can write me an email
## 18 2 on my private email address: tomaz.tsql@gmail.com
## 19 3 or even on this imaginary email address tomaz.tsql@nowhere.at
## 20 4 or on my fake non-existing email address not-exist@all
Written on December 13, 2013