Search results for query: *

That's the one. Cheers!

The answer is " I don't know". I just wanted to take the top 10% of a certain column from one table. It sounds easy but appears not to be.

It is in fact SQL server 2000. If you look up toppercent in the help menu you will find the syntax I included.

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

I'm not sure if understand but I can tell you this; the ISNUMERIC syntax above brings up the metricvalue data that wouldn't work with my original query. Thus, I'm not sure if what you are saying is right as it does seem to require a CAST and FLOAT to work? I'm working with SQL server 2000 by...

FYI my problem has been sorted using the following code: update tblmetricdata set metricvalue = cast( metricvalue as float ) * 1.5 where metricid between 119 and 130 and modelid = 282 It's the cast function that does it. Thanks for your replies.

It's metricvalue that is varchar. It can't be numeric because it is storing text fields as well.

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...