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!

Register Log in
  • Congratulations Chriss Miller 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. 13Echo

    convert varchar to numeric with colon in data fails??

    Try the cast or convert, I have an exmple listed below. SELECT d.intPlayerId, p.vcPlayerName, count(*) as numberofgames, convert(numeric(10,2), sum(d.intRank)) AS rank, sum(convert(numeric(6,2),d.intKills)) AS kills...
  2. 13Echo

    Many Rows to a Single Row

    Angle and Tohomas, Thank you for trying, I am thinking that I need to dump reults into a temp table. Once I have the results in the temp table, then I need to group them and insert them into another temp table or view. Thus, I would have all answers for a user in one row. Would using a...
  3. 13Echo

    Many Rows to a Single Row

    Thomas, Thanks for the idea, but I have run into a couple problems. The following is my code SELECT I_SRVY_USER_ID, CASE N_SRVY_ACTUAL_NUM WHEN '1' THEN N_SRVY_ANSWER ELSE 0 END AS 'Q1', CASE N_SRVY_ACTUAL_NUM WHEN '2' THEN N_SRVY_ANSWER ELSE 0 END AS 'Q2', CASE N_SRVY_ACTUAL_NUM WHEN '3'...
  4. 13Echo

    Many Rows to a Single Row

    Ok, I am at a loose here, can someone help? I have some data in a table which looks like this; UserID Question Answer 68 1 2 68 2 3 68 3 Yes 69 1 3 69 2 2 69 3 No The UserID...

Part and Inventory Search

Back
Top