StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUser-Defined Aggregate in SQL Server 2008 - How to deploy with MaxByteSize = -1?
text
Body
copied!<p>I read <a href="http://www.halhayes.com/blog/PermaLink,guid,127faa81-511d-462f-9b48-3272142837f9.aspx" rel="nofollow noreferrer">here</a> (and elsewhere) that it's possible, in SQL Server 2008, to build a user-defined aggregate which can return a string longer than 8000 characters. This is exactly what I need.</p> <p>Supposedly, the method is to set maxByteSize to -1 instead of a number btw 1 and 8000; this should allow any size up to 2GB.</p> <p>For some reason, apparently, you can't deploy straight from Visual Studio 2008 if you use this setting; so you need to manually deploy.</p> <p>So: I build my project - GroupConcat (which is supposed to simulate MySQL's group_concat aggregator) - which gives me, in the project's bin folder, a file "SqlClassLibrary.dll". Per the instructions on the above-linked page, I build the assembly in SQL Server. The command executes successfully. However, when I try to actually <em>use</em> the groupconcat aggregator:</p> <p><strong><code>select department, dbo.groupconcat(projectNumber) from projectleads group by department</code></strong></p> <p>...it says it can't be found. This all works fine if I set maxByteSize to 8000 and deploy directly from within VS2008, but I need >8000. Anybody know what I'm doing wrong?</p> <p>Thanks -dan</p> <p><strong>NOTE:</strong> I do specifically need to have a groupconcat aggregator function rather than using some of the SQL Server tricks I've often seen.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload