Database Reference
In-Depth Information
9. Test the query using the execute icon (red exclamation mark), as shown in the fol-
lowing screenshot:
10. In the middle pane, select the autogenerated SQL query. Copy the details. While
still in MSSMS, click on the
New Query
icon and paste the SQL query you
copied in the new query window. Tidy up the text as shown in the following
screenshot, taking care not to delete any of the syntax. Test the query and save it
in a local folder.
11. Make sure you have saved the query. Close MSSMS, and when prompted, do not
save the view, as shown in this screenshot:
This completes the steps you need to create the dataset query.
