Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Property Editors › SQL Server Property Editors › Define a View in SQL Server › Specify Properties for the WHERE Clause for a SQL Server View

Specify Properties for the WHERE Clause for a SQL Server View

Use the Where tab in the SQL Server View Editor to specify search conditions for queries against a view. The information you enter in the fields in this tab become the SQL code that is generated.

To specify the properties for the WHERE clause for a SQL Server view

1. Click Views on the Model menu.

   The SQL Server View Editor opens.

2. Select the view in the Navigation Grid for which you want to specify WHERE clause properties.
3. Click the Where tab and enter the values for the WHERE clause for the selected view using the following fields:

   Where

   Defines the search condition that must be satisfied by the results of the query. The text you enter becomes the WHERE clause in the SQL code that is generated. The WHERE clause excludes rows that do not meet the search condition.

   Group By

   Defines the criteria to use to group rows returned by the query. The text you enter becomes the GROUP BY clause in the SQL code that is generated. The GROUP BY clause places the selected rows into one group for each unique value.

   Having

   Defines the search condition that is applied to each row group, and filter out rows that do not meet the specified search condition. The text you enter becomes the HAVING clause in the SQL code that is generated.

   Restriction

   Applies the With Check Option restriction to the WHERE clause.

4. Click Close.

   The WHERE clause properties are specified for the selected view and the SQL Server View Editor closes.