It is sufficient to run either of the scripts, no need to...

You are very welcome.

😎

You need to...

For fun, appended the three characters to the previous sample and into the BASE_DATA CTE

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_STRING VARCHAR(2000) = 'Lorem ipsum dolor sit amet, CONSECtetur adipiSCIng elit....

gunadi.arunanto (11/15/2016)

---

Hi Stephanie,

I Attached result from : SELECT IDENT_CURRENT('MAP_MONTH') AS MAP_MONTH,

...

KGJ-Dev (11/15/2016)

---

Hi,

declare @val varchar (10) = "20:11";

How do i display this as 20 hours and 11 minutes. If it is 00:20 then 20 minutes. If it's 20:00 then 20 hours....

Jeff Moden (11/15/2016)

---

Eirikur Eiriksson (11/15/2016)

---

Here is a quick solution, quite efficient

😎

DECLARE @pString VARCHAR(8000) = 'Chlu' + CHAR(30) + CHAR(2) + CHAR(0) + CHAR(13) + CHAR(10) +...

Here is a quick solution, quite efficient

😎

DECLARE @pString VARCHAR(8000) = 'Chlu' + CHAR(30) + CHAR(2) + CHAR(0) + CHAR(13) + CHAR(10) + CHAR(20) + ...

Jeff Moden (11/15/2016)

---

Eirikur Eiriksson (11/15/2016)

---

Just throwing a small spanner (1/4 inch) in the works, the pre "populating" method where the CTEs accumulate the full cardinality is roughly 10% slower than...

Quick XML XQuery shredding example

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = '<pllog>

<log>

<datetime>20151021183108</datetime>

<ms>900</ms>

<type>Info</type>

<action>RES ONE Workspace initializing</action>

<result>Version 9.10.0.1</result>

</log>

<log>

<datetime>20151021183108</datetime>

<ms>900</ms>

<type>Info</type>

<action>Session GUID</action>

<result>{6E332C48-207F-4619-A25C-2B8716A19E31}</result>

</log>

<log>

<datetime>20151021183109</datetime>

<ms>134</ms>

<type>Info</type>

<action>TS client name</action>

<result>LAPTOP-HEV</result>

</log>

</pllog>

'

SELECT

XLOG.DATA.value('(datetime/text())[1]' ,'VARCHAR(50)' ) AS...

Jeffery Williams (11/15/2016)

---

Would love to. In fact I would kind of like to see it too!! 🙂 I could likely fix this if I did.

The query just runs indefinitely...

Y.B. (11/15/2016)

---

My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to expect other...

Even better when the length isn't...

Can you list the...

Nice one Luis!

😎

Adi Cohn-120898 (11/15/2016)

---

I've done few mistakes. Should have checked it better. The first mistake was that for some reason without noticing it, I've done a small modification ...