Sample Queries

From SDU
Revision as of 14:34, 3 April 2008 by Komodo (Talk | contribs) (SQL Query for Request Areas)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

To obtain the most current listing, from the SQL Query Analyzer run the following query on the MDB.

SELECT prob_ctg.persid, prob_ctg.sym, prob_ctg.description FROM [dbo].[prob_ctg] WHERE (prob_ctg.del = 0)

This query will return a list of persistent ID's, Symbols (Request Areas) and Descriptions from SQL. Only ACTIVE Request Areas will be displayed by this query.