Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. twhitney

    SQL Server 2000 dataset sorting question

    PHV - thanks - that looks good - I just tried this and it seemed to work: ORDER BY CASE WHEN prop_firmID = 32 THEN prop_firmID ELSE prop_price END I might try yours too. Thanks again!!
  2. twhitney

    SQL Server 2000 dataset sorting question

    I'm trying to sort a SQL query while prioritizing one specific dataset - e.g.: table: tbl_properties field: prop_firmID I want to list those properties where prop_firmID=32 and second, by price (which I got covered) In other words - If I sort by prop_firmID - it will list properties...

Part and Inventory Search

Back
Top