Guest User

Untitled

a guest
Jan 4th, 2013
32
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  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
Add Comment
Please, Sign In to add comment