April 25, 2012 at 9:01 am
New to SQL/ASP...not sure where to post this.
This is an ASP app. Attached is a partial screenshot of the app. What is the best way to get totals for each row (not column)...Like how many F's/U's/IP's/DNP's? One thought is to give each F/U/IP/DNP a value and then total. I need a way to show if the row has say 70% U's (red) then show a warning. Management doesn't care if it's on the screen or they select a button and it runs a report and analyzes the data. Does this make sense? Not sure how to approach this or what the proper terminology is for asking you all for help.
Thanks a bunch
April 25, 2012 at 9:06 am
Would the COUNT(columnName) function help?
SELECT COUNT(columnA)
FROM table
WHERE columnA = 'U'
Please read the article referenced in my signature to help us better help you.
Jared
CE - Microsoft
April 25, 2012 at 9:13 am
Thanks Jared...
I'll read it after I post. I need the totals on the row though not the column.
Derek
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply