Rekonn (6/20/2012)

---

Hi, I need to take a stored procedure that currently returns a simple and small record set, and change it to return JSON as an nvarchar(MAX) instead. There seem to be a good articles out there on how, but my knowledge of C# and Visual Studio is miniscule, so I'm missing some basic steps. Can someone help me bridge the gap between these two?

http://blog.sqlauthority.com/2008/10/19/sql-server-introduction-to-clr-simple-example-of-clr-stored-procedure/

and

http://www.sqlservercentral.com/articles/CLR/74160/

Or, if it's not much harder, I'd like to see if I can implement the CLR using fastJSON, as that seems to have much better performance.

http://www.codeproject.com/Articles/159450/fastJSON

I'm using SQL Server 2008 R2 and Visual Studio 2010 btw, thanks in advance!