Problem with AGGREGATE FUNCTIONS in SQL SERVER 200
I created 3 AGGREGATE FUNCTIONS in SQL SERVER 2005. Also i used three of them in SPs. Except one, the other 2 throwing error like :
Msg 6522, Level 16, State 2, Procedure ADDPeerGroupLowerQuartileStatistics, Line 591
A .NET Framework error occurred during execution of user defined routine or aggregate
System.Data.SqlTypes.SqlTypeException: The buffer is insufficient. Read or write operation
at System.Data.SqlTypes.SqlBytes.Write(Int64 offset, Byte buffer, Int32 offsetInBuffer,
at System.Data.SqlTypes.StreamOnSqlBytes.Write(Byte buffer, Int32 offset, Int32 count)
at System.IO.BinaryWriter.Write(String value)
at LowerQuartiles.Write(BinaryWriter w)
There is no much difference in three of the functions. Though im getting the error like above.
Anyone pls help me in this.
Thanks in Advance,