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

Jeff Moden (11/13/2016)

---

TheTrojan (11/13/2016)

---

@mister.magoo You will be happy to know that your solution is slightly faster than mine! Have a look at the times:

-- if the parameter is 1000: 76...

Adi Cohn-120898 (11/15/2016)

---

Here is one more way:

declare @Org varchar(150) = 'Lorem ipsum dolor sit amet, CONSECtetur adipiSCIng elit. PelleNTesque in ELIT ut ex accumsan sagittis in a urna'

declare @Results varchar(200)...

You are very welcome.

😎

To...

farax_x (11/15/2016)

---

GilaMonster (11/15/2016)

---

You're going to have to investigate why that procedure is compiling frequently. There's nothing in the code that would cause compiles or recompiles, so start by tracking down...