Search results for query: *

I figured it out.. SELECT AVG((SELECT MAX(score) FROM scores WHERE question_id = ?_id)) FROM scores GROUP BY ?_id

I know AVG(MAX(values)) does not work, but I need something to do the same. I have a quiz that has different responses and each response is scored differently. I need to get a list of max possible scores for each question and then find the average of that list. Is this possible to do in a...

I'm asking if there is an easy way to filter by each month in a loop or something. Or is the best way to do it is to just make a month table and join on that?

This is an asp.net and mysql question all in one.. I want a list of each month and prize money for that month, some months may not have any prizes awarded, but I still want to show the month name. Is there an easy way to do this using a repeater or something? Ex: January $200 February...

Is there a way to output a "money" type in MySql? Say I have a decimal "1234.22222", I want it displayed as "$1,234.22" Thanks.

We've tried boolean and bit.

We're having issues bind an asp:checkbox to a mysql table. We've got far enough to retrieve the value and set the checked value of the checkbox, but when we try to update our mysql table it say's we cannot convert from type 'bool' to type 'string'. And if we try to insert a string it say's the...

Just found my answer, CONVERT(interface_id, CHAR(8)) AS id

I'm using a third party tool and it doens't like that I am trying to enter an int as a property, so I want to try and convert the int to a string to see if that works. How do you convert int to string using Mysql?

Thanks guys, I knew it was something easy I was just overlooking.

I have a table with accounts, id/name. And a customer vendor map table. I'm trying to create a list of accounts that do not already exist in my customer list. Accounts: 1,2,3,4,5,6,7,8 Customers: 2,3 If those are my accounts and customers, I want to return 1,4,5,6,7,8 to populate my dropdown...

PERFECT! Select Convert(Decimal(10,2), 1.1234567) That is exactly what I needed. Thanks gmmastros! Thanks for all the suggestions.

In ms sql I have 1.1234567 I want to return 1.12 I tried ROUND(1.1234567, 2) but that gives me 1.230000 I also tried TRUNC and TRUNCATE.

I've searched the forums and faq's, but havn't seemed to be able to find my specific problem. I have a page that is used to navigate through multiple user controls. Right now I am using sessions to pass variables between the controls, but this does not seem very efficient. Is there a way I can...