sql server 2000. What does ABS do?
>"Mike" <anonymousdiscussions.microsoft.com> wrote inspecify>news:b72901c43784$c4281b30$a601280aphx.gbl...>> Is it possible to get the total number of rows andwidgets>> where clause in the same stored procedure.
>> For instance, I am trying to get the the total number of
>> widgets that = 'Toys' so I can get a percentage ofto modify it to>>> = 'Toys' for the widget category.
>> Is it possible?
>Database? Version? DDL? Sample Data? Desired Output?
>The query would look something like this. You will needit looks like.>reflect your database structure since I have no idea whatToysPercentage>
>ABS(SUM(W.CategoryName = 'Toys'))/COUNT(*) AS>FROM
>Widgets AS W