Inserting an existing SQL statement

Sometimes you may have a query that has already been perfected on another system. You can either:

• Open the query file that has been provided or saved with a .dqy extension.
  

• Paste a SQL statement into the SQL window on the Microsoft Query window
  

In this example, we will follow the process when someone from the Synergetic Management Systems team emails you a SQL statement. This Structured Query Language (SQL) statement is written in a language that database management systems can interpret. Synergetic uses the Microsoft SQL Server database management system.

In this example, we will use a simple SQL statement that will report and total all religion codes at your organisation:

This statement selects campus, religion code and places a count field on your spreadsheet. The fields:

• to be returned or calculated are placed directly after the SELECT clause
• used to filter the records are placed directly after the WHERE clause
• used to group the output are placed after the GROUP BY clause
• used to sort the information are placed after the ORDER BY clause.

To paste in a SQL statement that has been sent to you by email:

1. Start Microsoft Excel.
2. Select:
   
   • Data > From Other Sources > From Microsoft Query (Microsoft Excel 2010 and Microsoft Excel 2013)
   
   • Data > Import External Data > New Database Query (Microsoft Excel 2007)
   • Data > Import External Data > New Database Query (Microsoft Excel 2003)
   • Data > Get External Data > Create New Query (Microsoft Excel 97).
   
   The Choose Data Source window is displayed.
   
3. Select the Synergetic database.
4. Clear the Use the Query Wizard to create/edit queries field.
    
5. Click .
   The SQL Server Login window is displayed.
   
6. Type in your username and password.
   
   Note: This is your usual Synergetic username and password.
   
   
7. Click .
   The Add Tables window is displayed.
   
8. Click .
9. Click .
   The SQL window is displayed.
   
10. Switch to the application with the SQL statement, such as an email message.
11. Select the SQL statement text and press Ctrl + C.
    
    The SQL statement is copied to the clipboard.
12. Switch back to the SQL window.
13. Press Ctrl + V.
    The SQL statement is pasted into the SQL window.
     
14. Click .
    The Microsoft Query window is updated with the new criteria and the records are displayed.
    
15. You can:
    • select File > Save to save the query for later use
    
    • select File > Return Data to Microsoft Office Excel to return the data to a spreadsheet.
     

Attachments (47)

worddavdf64f75c03dcbc2d116901035eef9ba4.png
4.54 KB

worddav1478867430118eadf903142aec2c767e.png
3.94 KB

worddavfb174eff4ae69352b99c02094d96afc4.png
9.7 KB

worddav2b3eaff157eb005827468cd1d9111b53.png
11.3 KB

worddav70a672795797c4103c0062e12d2cd578.png
1.05 KB

worddav848827d731148b82271de0d1d21db869.png
946 Bytes

worddavc97119f7bd2e78f4a9beac75878c1a8f.png
6.85 KB

worddavc040b95cadc409aff65cc397e4583ec5.png
9.95 KB

worddav04ad37898474f0ed94293e725023e4b5.png
4.26 KB

worddavd1502011eb7b8d500ed266886b5d6c6c.png
1.18 KB

worddav1582012707186a8736a002b41cfc892f.png
4.6 KB

image2019-9-12_15-30-26.png
13.8 KB

image2019-9-12_15-30-33.png
6.44 KB

image2019-9-12_15-31-8.png
9.37 KB

image2019-9-12_15-31-41.png
991 Bytes

image2019-9-12_15-31-56.png
17.7 KB

image2019-9-12_15-32-41.png
35.3 KB

image2019-9-12_15-33-1.png
3.25 KB

image2019-9-12_15-33-20.png
6.44 KB

image2019-9-12_15-33-40.png
13.3 KB

image2019-9-12_15-33-50.png
12.5 KB

Choose_Data_Source_window.png
24.8 KB

Microsoft_Query_window_(SQL_Server_Login).png
39.2 KB

Microsoft_Query_window_(Add_Tables).png
51 KB

Microsoft_Query_window_(Close_button).png
758 Bytes

Microsoft_Query_window_(SQL_window).png
6.66 KB

SQL_button_(Microsoft_Query_window).png
699 Bytes

SQL_window_(Basic_query).png
21.7 KB

Email_with_SQL_query.png
106 KB

Microsoft_Query_(With_SQL_Query).png
53.8 KB

Save_As_(Emailed_query).png
42.9 KB

File_-_Return_data_to_Microsoft_Excel.png
28.8 KB

Open_Query_window.png
45.9 KB

69e1e2a91360f.Open_20Query_20window.png
45.9 KB

69e1e2a913611.SQL_20window_20(Basic_20query).png
21.7 KB

69e1e2a913612.Microsoft_Excel_-_New_Database_Query_(Excel_2013).gif
28.4 KB

69e1e2a913613.Choose_20Data_20Source_20window.png
24.8 KB

69e1e2a913614.image2019-9-12_15-31-41.png
991 Bytes

69e1e2a913615.Microsoft_20Query_20window_20(SQL_20Server_20Login).png
39.2 KB

69e1e2a913616.Microsoft_20Query_20window_20(Add_20Tables).png
51 KB

69e1e2a913617.Microsoft_20Query_20window_20(Close_20button).png
758 Bytes

69e1e2a913618.SQL_20button_20(Microsoft_20Query_20window).png
699 Bytes

69e1e2a913619.Microsoft_20Query_20window_20(SQL_20window).png
6.66 KB

69e1e2a91361a.Email_20with_20SQL_20query.png
106 KB

69e1e2a91361b.Microsoft_20Query_20(With_20SQL_20Query).png
53.8 KB

69e1e2a91361c.Save_20As_20(Emailed_20query).png
42.9 KB

69e1e2a91361d.File_20-_20Return_20data_20to_20Microsoft_20Excel.png
28.8 KB