Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @input NVARCHAR(max) = '

hihihi

hihihi

hihihi

https://telegram.me/joinchat/BW0OCzvs1F6frTkUj2HEAQ

hihihi

hihihi

hihihi

https://telegram.me/joinchat/DigSjj6xZYsI_H2GRjtNQQ

hihihi

hihihi

hihihi

hihihi

http://telegram.me/ZOJ20/10236

';

;WITH T(N) AS (SELECT N FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS X(N))

, NUMS(N) AS (SELECT TOP(LEN(@input))

...

mister.magoo (10/8/2016)

---

One more variant for these which shows...

Ouch ...biting the tongue....

😎

The overlap problem can be solved in a much simpler manner, simply check if the current end is greater than the next start and if so use the next start...

wendy elizabeth (10/7/2016)

---

In a t-sql 2012 listed below, I want the lockids to be set individually from 117173 to 117678. The problem with the sql listed below is all the...

For completeness, 5 different versions which all produce the same execution plan although performance may vary depending on the XML structure.

😎

----------------------------------------------------------------------------

-- #1 Full traverse to the end node

----------------------------------------------------------------------------

SELECT Id...

You are very welcome.

😎

The value of the sys.dm_exec_sessions.host_process_id is defined...

Quick thought, no need to use the traversing operator "//" in the nodes path statement, it can be costly if the XML is complex.

😎

Non traversing examples

SELECT Id ,

...

joshua 15769 (10/7/2016)

---

So what I did is, save the username in the database through stored procedure. The stored procedure is called in the program prior to update. but sadly, I...

matt.warren 33350 (10/7/2016)

---

Hello,

I have a table called "Tables" which stores a list of tables by id, name, etc.

I also have a table called "Columns" which stores a list of columns...

itmasterw 60042 (10/7/2016)

---

Hi,

I have a package that is using a Foreach File Enumerator loop to go through a folder and pull in the data from a 3 Excel files; insert...

Grant Fritchey (10/7/2016)

---

Brandie Tarvin (10/7/2016)

---

Stuart Davies (10/7/2016)

---

I don't post here often, but love the community...

Quick suggestion

😎

USE TEEST;

GO

IF OBJECT_ID(N'dbo.temp') IS NOT NULL DROP TABLE dbo.temp;

create table dbo.temp(Companyid varchar(10) not null,companyname varchar(100) not null,DateFrom datetime not null, DateTo datetime null);

INSERT INTO temp values('A1','A Company','2000-04-11',null);

INSERT INTO...

You can retrieve the file growth events from the default trace[/url]

😎