I would look into using the SQLCLR.

Ninja's_RGR'us (1/21/2011)

---

opc.three (1/21/2011)

---

For that large of a dataset a loop structure will likely yield the best performance. If you have an application layer I would recommend doing this type of...

For that large of a dataset a loop structure will likely yield the best performance. If you have an application layer I would recommend doing this type of work there...otherwise...

Your original post had an invalid GROUP BY scenario so I took the liberty of summing Column1. This solution will perform poorly for large datasets, but is an option using...

It's hard to tell from the sparse documentation on MSDN describing TRUSTWORTHY but it appears that setting the property ON allows objects using the EXECUTE AS OWNER functionality to use...

Maxer (1/13/2011)

---

I also used "EXECUTE AS OWNER" on the sproc, thinking I (who has sysadmin rights) own the sproc so it would execute as me.

However, this does not work as...

I do not know of any operational...

The roles you put them in depend on how much you want to restrict their capabilities on the server.

SELECT CONVERT(UNIQUEIDENTIFIER,0xF964C2D3F5376D479DA2A76C97B6BEB5);

Delivers:

D3C264F9-37F5-476D-9DA2-A76C97B6BEB5

Rob Fisk (8/31/2010)

---

opc.three (8/31/2010)

---

Rob Fisk (8/31/2010)

---

Very good points at the start of the article and I may do some refresher readin on some bits but for the specific example would...

Toby Harman (8/30/2010)

---

Always good to see a firm grasp of logic being used in computing!

If I may suggest a variation to this technique I have seen is to use ISNULL...

Rob Fisk (8/31/2010)

---

Very good points at the start of the article and I may do some refresher readin on some bits but for the specific example would something like this...

Could you kindly post the DDL for #myinfo and the test data you used for this article?

Thank you for the post...do you mind telling more about these projects? What types of analysis went into...

As luck would have it the issue just happened when posting this topic 🙂 This time I did not hit back button and try to resubmit and this time again...