Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › Define SQL Server Aggregates

Define SQL Server Aggregates

Use the SQL Server Aggregate editor to define aggregate functions in a SQL Server 2005/2008 physical model.

To define a SQL Server aggregate

1. Click Aggregates on the Database menu.

   The SQL Server Aggregate Editor opens.

2. Select the aggregate in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new aggregate.

   • Name

     Displays the aggregate name. You can change the aggregate name in this field.

   • Schema

     Specifies the schema for the aggregate. Select a schema from the drop-down list or click the New icon to open the SQL Server Schema Editor and create one.

   • Input Parameter Name

     Defines the input parameter name. For an acceptable syntax value for this field, see your Microsoft SQL Server documentation.

   • Input Data Type

     Specifies the data type of the input parameter. Select a data type from the drop-down list.

   • Return Data Type

     Specifies the data type of the return value. Select a data type from the drop-down list.

3. Click the General tab and work with the following options:
   • Assembly

     Specifies the assembly that will bind with the aggregate function. Select an assembly from the drop-down list or click the New icon to open the SQL Server Assembly Editor and create one.

   • Class Name

     Specifies the name of the class.

4. (Optional) Click the Comment tab and enter any comments that you want to associate with the aggregate.
5. (Optional) Click the UDP tab to work with user-defined properties for the aggregate.
6. Click Close.

   The aggregate is defined and the SQL Server Aggregate Editor closes.