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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.