Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Solomon Rutzky Getting The Most Out of SQL Server 2005 UDTs and UDAs RE: Getting The Most Out of SQL Server 2005 UDTs and UDAs

  • March 14, 2011 at 4:11 pm

    #1298606

    Thanks for the article but it seems that the link is not working.

    CreateAssemblyAndAggregate.sql

    Also when I try to create the procedure below I get an error. I named the dll MedianSQLSERVER

    Error Message:

    Msg 6505, Level 16, State 1, Procedure Agg_Median, Line 1

    Could not find Type 'Agg_Median' in assembly 'MedianSQLServer'.

    CREATE PROCEDURE Agg_Median

    AS

    EXTERNAL NAME [MedianSqlServer].[Agg_Median].[Accumulate]

    --Assembly.type.

    Thank you