Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2008 Property Editors › Define SQL Server 2008 and 2012 Functions › Specify the Return Order for a Table Return Assembly Function

Specify the Return Order for a Table Return Assembly Function

Use the Return Order tab in the SQL Server Function Editor to specify the order in which results should be returned from a Table Return Assembly Function in a SQL Server 2008 physical model.

To specify return order

1. Click Functions on the Model menu.

   The SQL Server Function Editor opens.

2. Select the function in the Navigation Grid for which you want to specify return order.

   Note: Click New on the toolbar to create a new function. Use the Enter filter text box to filter a very large list of functions to quickly locate the one that you want to define.

3. Click the Return Order tab and work with the following options:

   New

   Creates a new return table order object.

   Note: Ensure you have set the return table definition first or you are unable to create the object.

   Delete

   Deletes the selected object.

   Sort

   Sorts the objects by alphabetic, reverse alphabetic, or return table order.

   

   Moves the object to the top of the list.

   

   Moves the object up one position in the list.

   

   Moves the object down one position in the list.

   

   Moves the object to the bottom of the list.

   Note: You use these up and down arrow buttons to specify the return order.

4. Click Close.

   Table Return Assembly Function order is defined and the SQL Server Function Editor closes.