Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Jan 4th, 2013  |  syntax: None  |  size: 0.84 KB  |  views: 17  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SELECT sr.ServicesResourcesID AS ID, sr.Title, sr.ContactFirstName, sr.ContactLastName, sr.ContactEmail, sr.ContactPhone, sr.FileName, sr.URL, sr.Description AS Description, rt.Type, KEY_TBL.RANK
  2. FROMvResourceType rt,vServicesResources sr
  3. INNER JOIN FREETEXTTABLE(ServicesResources, Title, 'computers') AS KEY_TBL
  4. ON sr.ServicesResourcesID = KEY_TBL.[KEY]
  5. WHERE sr.ResourceTypeID = rt.ResourceTypeID
  6. ORDER BY RANK DESC
  7.        
  8. SELECT sr.ServicesResourcesID AS ID, sr.Title, sr.ContactFirstName, sr.ContactLastName, sr.ContactEmail, sr.ContactPhone, sr.FileName, sr.URL, sr.Description AS Description, rt.Type, KEY_TBL.RANK
  9. FROMvResourceType rt,vServicesResources sr
  10. INNER JOIN FREETEXTTABLE(ServicesResources, Description, 'computers') AS KEY_TBL
  11. ON sr.ServicesResourcesID = KEY_TBL.[KEY]
  12. WHERE sr.ResourceTypeID = rt.ResourceTypeID
  13. ORDER BY RANK DESC