Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ross1228

    AVG(MAX(values))

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

    AVG(MAX(values))

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

    Month loop

    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?
  4. ross1228

    Month loop

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

    MySql Convert to Money

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

    How to bind asp:CheckBox to MySql table?

    We've tried boolean and bit.
  7. ross1228

    How to bind asp:CheckBox to MySql table?

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

    Convert int to string/varchar

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

    Convert int to string/varchar

    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?
  10. ross1228

    SELECT where does not exist

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

    SELECT where does not exist

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

    Truncating a decimal

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

    Truncating a decimal

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

    Storing Control Accessible Variables

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

Part and Inventory Search

Back
Top