villychilly (7/15/2011)

---

Hi again, and thank you both very much for your replies. I was obviously having a bit of a bad morning and Welsh Corgi, your reply kickstarted my brain...

Very nice job posting usable DDL, DML and what you have tried! Provide your desired output relative to the same test data please and we'll see if we can assist.

Welsh Corgi (7/15/2011)

---

Correct me if I'm mistaken but if the subquery does not return a result the you code bombs out?

You have to replace the NULL with a Zero to...

You are saying cloud...have you looked into SQL Azure? It may be far more cost effective for you.

This is not a reliable setting to ask about licensing. If you take the advice of someone on a forum you are still liable. I recommend you work with Microsoft...

hmmm...when Googling the phrase "every feature in MS SQL 2008 R2 and which version everything is supported by" from the OP the technet version of the BOL article posted is...

C.K.Shaiju (7/15/2011)

---

Welsh Corgi (7/15/2011)I'm sure that there are easier ways to identify this. If you do not have local Host registered or are unable to register your local machine then...

villychilly (7/15/2011)

---

Does anyone have an elegant solution for this problem? Essentially I want to do the equivalent of an IN on the result of GetDescendantOf.

SELECT

something

FROM

somewhere

WHERE

...

Sweetness...happy to assist 🙂

Now why would anyone ever do that? :hehe:

Please vote 😀

http://connect.microsoft.com/SQLServer/feedback/details/127219/create-or-replace

The "Unicode" checkbox means UCS-2.

Can you attach an example file to the thread with a line or two. DDL for your destination table and your SSIS and SQL Server product...

Isn't that still using the 2.0 runtime?

Arrgh, I don't have the dev tools here to get into it. I may have some time over the weekend.

john.delahunt (7/15/2011)

---

opc.three: That must be the answer to someone else's question. I'm trying to dynamically load an old dll in SQLCLR (ie. use late binding by way of...