How to query archived data?

• chilithecat

  Valued Member

  Points: 67

  More actions

  October 18, 2004 at 12:28 pm

  #102239

  Can someone tell me if there's a convenient way to query my archived data in a single query? Let's say I have a table, Rides, and another table RidesArchive, and I want to run a "Select Distinct MemID", or "Select Count(RideID)" from these two tables combined? Can I do it in a single query?  There are numerous more complex queries I would like to run too, but I think that gets the basic point across.

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  October 18, 2004 at 1:02 pm

  #527080

  Chili,

  I would research UNION in BOL (books online).  This will probably help you.

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• AKM

  SSCommitted

  Points: 1538

  More actions

  October 19, 2004 at 2:43 am

  #527137

  Assuming Rides and RidesArchive have the same structure, you could just

  CREATE VIEW RidesAll AS
  SELECT * FROM Rides
  UNION
  SELECT * FROM RidesArchive

  RidesAll is now a view you can query on just like a Rides table.

  Some people might ask why you are archiving data that still gets queried with current data