Lowell (5/1/2014)

---

i've tried sys.fn_cdc_hexstrtobin to convert the string to varbinary, but it truncates a large portion of the value. maybe someone else can take the ball and run with it...

A simple solution

😎

with p as

(

select 'asdf1234' as Delivery_Site union all

select 'asdf 1234' union all

select ' asdf asdf ' union all

select ''

)

,TXT_INFO AS

(

SELECT

...

Why not try Jeff Moden's splitter, pass space as delimiter?

😎

cvkk2010 (4/30/2014)

---

Hi All,

I need help to execute a taxk.

I have text file which has SQL Statements something like

Select top 10 * from Table 1

Select top 10 * from Table 2

Select...

On a mediocre laptop, 10000000 rows returned in 145 ms and 100000 inserts in 75 ms, I think version 1 is promising.

😎

Few weeks back, before upgrading the 2012 system I´m working on to 2014, I ran into a similar behavior when forgetting the filter/limit...

That means I might be missing something:-P

Thanks!

Grant Fritchey (4/30/2014)

---

Tons of stuff has changed. First, did you change the compatibility level on your database to 120? If not, you're using the old statistics with the new optimizer...

Maybe this[/url] might help

😎

Thanks Jeff, this I missed!

😀 that...

He he, somehow my phone didn't show the earlier reply, kind of awkward :hehe:

My first approach would be creating a table with a different name but same structure, copy the...

Quick thought, how about extracting the node to an encrypted table, delete it from the XML and when needed, join the two together?

😎

SQLdude412 (4/30/2014)

---

Thanks for your reply.

The value...

To further on Lowell's point, what is the output of "select datalength(xml_column) from bad_table"? Should be about 70% of the nvarchar conversion normally.

😎

Sean Lange (4/30/2014)

---

Jeremy Brown (4/30/2014)

---

Honestly I don't feel as strongly one way or another. Fine, you want the object name first, go for it. You want the behavior...