Hi and welcome to the forum.

Can you please post the DDL (create table) scripts, some sample data as an insert statement and the expected output?

😎

an0nemus (11/17/2016)

---

We have a 2008 DB, with 3 client servers all on the same subnet as the sql server.

2 machines connect just fine, 1 machine throws this error on the...

Phil Parkin (11/17/2016)

---

Eirikur Eiriksson (11/17/2016)

---

The execution plan for my version...

bennylu (11/17/2016)

---

Thank you Eirikur. That was exactly what I looking for.

In terms of performance, Eirikur's solution performed better. It had less reads, most likely because it did not use a...

The execution plan for my version is significantly simpler (41...

Here is an alternative solution

😎

BTW, OPENXML is not better, stick to the XQUERY

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @XML_DATA XML = '

<Report MerchantID="123456">

<Requests>

<Request RequestID="4791333844346002104017" MerchantReferenceNumber="RA00042357770">

...

Brandie Tarvin (11/17/2016)

---

Beatrix Kiddo (11/17/2016)

---

It's in the link there.

CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and deploy objects...

You are very welcome.

😎

You should consider Jeff's fine advice, it is easy to incorporate into the solution.

Jeff Moden (11/16/2016)

---

If the input string is limited to less than 24 hours, the following makes life pretty easy and will also produce an error if someone entered improper information...

Ed Wagner (11/16/2016)

---

Eirikur Eiriksson (11/16/2016)

---

ramyours2003 (11/16/2016)

---

We need to collect the disk space utilization on weekly basis and we have 50+ servers . I need a report of all the...

ramyours2003 (11/16/2016)

---

We need to collect the disk space utilization on weekly basis and we have 50+ servers . I need a report of all the servers how much the...

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,

...