Other than using a different function, the final code is basically the same. The only problem is that you're not using the fastest function available (even in the article Aaron...

You're commiting your transaction twice. Once in the try and once in the catch. Remove one of them to correct the issue.

For the second post, you have an open transaction...

I'm not sure why do you want a pivot.

Note that this code will only work with up to 4000 chars. If you don't have unicode values, you could use the...

The DelimitedSplit8K is a great tool, but you might find useful to use another tool to reduce the code.

This tool is the Pattern Splitter created by Chris Morris and posted...

I did something slightly different from Lowell's.

CREATE TABLE #Shifts(

StartShift time,

EndShift time

)

INSERT INTO #Shifts

VALUES( '21:00', '06:00'),

( '06:00',...

Probably a cross tab could do the trick:

SELECT ID,

MIN( CASE WHEN String LIKE 'Rejected%' THEN Date1 END) AS [Rejected on],

MAX( CASE WHEN...

No problem. Just try to be clear on what you need as much as possible.

We get confused if you suddenly change the requirements without explaining the reason or saying it...

It doesn't rely on...

Just use...

This should be safer.

declare @URL varchar(100) = 'http://www.mydomain.info/Customer.aspx?dcc=EUR&h_hmid=2907831&mobiredirect=no&cpn=3790'

SELECT *, LEFT( initial.pos, CHARINDEX( '&', initial.pos + '&') - 1)

FROM (VALUES (@URL)) AS x(url)

CROSS APPLY (SELECT SUBSTRING( x.url, CHARINDEX('h_hmid=', x.url) + 7,...

cswittmaack (12/9/2015)

---

I would not want to pull record 3 and 4 from the table, and at some time later i might have to only pull records like 3 and 4...

The Developer Edition should be available when the product is completely released. Right now, you want to use the CTP version which is a free preview for evaluation.

You might need this:

SELECT *

FROM sys.tables t

JOIN sys.schemas s ON t.schema_id = s.schema_id

where t.name = 'STHMCDPTD'

AND s.name = 'CMS'

Or this:

SELECT *

FROM sys.tables t

where t.name = 'STHMCDPTD'

AND SCHEMA_NAME(t.schema_id) = 'CMS'

Or for...

Depending on the collation, that might not work correctly. Try this:

CREATE TABLE#alpha_numerics(alpha_numeric VARCHAR(30));

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

SELECT a.n FROM E...

arkiboys (12/9/2015)

---

Luis Cazares (12/9/2015)

---

I would define the columns from the text file as strings, then use a data conversion or derived column transformation to change the columns' types. That transformation...