I have heard of it but have not tried ApexSQL (and their website won't allow me to register for a trial period with my gmail account...lame). Do you know if...

I spent a few minutes looking around and experimenting and I did not see a way to do it. I don't know everything you're trying to do, however while it...

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?