Not to revive an old thread, but I ran across this when Googling for something else and if I found it someone else will too. In the spirit of educational...

Well, if you are, then I am too...I could not have said...

krishnachowdary8 (7/19/2011)

---

data:

e_id ename

1 abc xyz def

2 ghi jqk

o/p:

e_id ...

Saravanan_tvr (7/18/2011)

---

2) When the automated updated happens the string length issues and data type issues in update and Insert Query occurred simultaneously, so i have hanged the Nvarchar(MAX) for all...

If you have other things running on your server besides just the Database Engine 5GB may be appropriate but only giving 5GB out of 8GB to SQL sounded low to...

Per the documentation it requires a constant string, a variable, or any combination concatenating those two options. It does not say that it supports expressions, i.e. returns from functions, built-in...

It took a bit of searching to find them so I figured I would share the links:

http://www.sqlmag.com/article/tsql3/calculating-concurrent-sessions-part-1

http://www.sqlmag.com/article/tsql3/calculating-concurrent-sessions-part-2

Note: The links in the articles to the "Listings" and "Web Listings" are broken...

Elliott Whitlow (7/18/2011)

---

Not at all, trustworthy is not a requirement there are ways to get an UNSAFE assembly in without it. But unsafe and external access are a lot...

UNSAFE was definitely required in this instance. LoadLibrary must have been the culprit.

I will check on TRUSTWORTHY down the line. I am not sure if it was...I think I was...

I know...but I think...

I think you are spot-on with your idea of employing the SQLCLR for this. You might want to try posting the question to the MSDN SQLCLR forum. You may get...

Sorry. I don't have all your tables here so did not bother compiling it. I did not intend for you to compile it anyay...it was just to strip away the...

I understand, but...

PS This could also be done, albeit with a lot more coding and testing, using a variation of the "Quirky Update" or the CLR (as noted) to get you a...

It isn't pretty (in form or potential performance impact) but it gives the proper result.

CAUTION: a query like this is laced with costly sorts and loops (hidden RBAR) and can...