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 Shaun E 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: *

  • Users: grecian9
  • Content: Threads
  • Order by date
  1. grecian9

    Toppercent syntax

    Hi, this should be easy for someone. I don't understand the syntax for toppercent. According to the help menu the syntax is TopPercent(«Set», «Percentage», «Numeric Expression»). Where in this syntax do you specify the column you want to sort on? Some demo syntax would be great. Thanks
  2. grecian9

    SQL novice needs update query help

    How do I run an update query in a field that is varchar? I'm trying to set the values in field "metricvalue" to a new value but my guess is that you can't multiply varchar values? This is my syntax: update tblmetricdata set metricvalue = metricvalue * 1.5 where metricid between 119...

Part and Inventory Search

Back
Top