Sorry,...

Well, this fixed it. You can all go back to alert level pewter evening and return to your regularly scheduled rock n roll hoochie koo.

set @sql = N'SELECT @y =...

set @sql = N'SELECT @x = P

FROM OPENROWSET (BULK ''\\plaus42\SurveyComputing\Sample\SampleRepository\[filename]'', SINGLE_BLOB) AS FMG(P)'

set @sql = replace(@sql, '[filename]', @filename)

print (@sql)

--exec (@sql)

EXEC sp_executesql @sql, N'@x xml OUTPUT', @x = OUTPUT;

EXEC sp_xml_preparedocument @hdoc...

Thanks, Grant. I'll add this to my current reading rotation.

No, I should have been a bit more clear. This is the version I'm using:

Name ...

insert into [worm]

(

[hole]

)

select

[Bill Talada]

from [earth]

Well, faster is better.

Jeff Atherton (10/16/2013)

---

Sean Lange (10/16/2013)

---

btw, not sure what the previous poster was complaining about. SQLExpress is free and is a great tool, especially for learning when you don't have access...

Jeff Atherton (10/16/2013)

---

For starters if you want to play and learn SQL Server then why did you go with SQL Express. You might want to consider installing the full developer...

Unless I'm missing something, I think using EXISTS would be a very approachable solution.

http://technet.microsoft.com/en-us/library/ms188336.aspx

Thanks, Sean and Chris. It was a one off query, otherwise I would have probably moved some stuff around. But it got me thinking about what the heck was taking...

Sean Lange (10/9/2013)

---

erikd (10/9/2013)

---

dwain.c (10/7/2013)

---

But it can also be done with a single call to PatternSplitCM:

WITH SampleData(MyString) AS

(

SELECT' [{mark,peters,mr}{jane,fonda,mrs}{john,doo,mr}{james,bond,mr}]'

)

SELECT MyString

,Col1=MAX(CASE WHEN ItemNumber%6...

dwain.c (10/7/2013)

---

But it can also be done with a single call to PatternSplitCM:

WITH SampleData(MyString) AS

(

SELECT' [{mark,peters,mr}{jane,fonda,mrs}{john,doo,mr}{james,bond,mr}]'

)

SELECT MyString

,Col1=MAX(CASE WHEN ItemNumber%6 = 2 THEN...

Jeff Moden (10/8/2013)

---

So don't do that anymore. 😉 ...

The short answer is that varchar columns don't get along with Unicode characters. Your column type should be nvarchar.