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

    Microsoft SQL 2 tables alias GROUP BY questions

    Tried the query that youmjust provided. Recieved an error message: ODBC Error 8120: Column A.New_Name is invalid in the select list because it is not contained in either an aggreagate function or the GROUP BY clause. Tried to do something stupedly simple: select...
  2. vladfrenkel

    Microsoft SQL 2 tables alias GROUP BY questions

    Hi,I've tryed that query. Received error message that HOUR( is not recognized as a function name... Sincerely vladfrenkel
  3. vladfrenkel

    Microsoft SQL 2 tables alias GROUP BY questions

    Thank you very much for your response. I'll try this first thing at Monday. I'm not sure about indexes, cause Friday was the first time I saw the DB. Thanks a lot Sincerely vladfrenkel
  4. vladfrenkel

    Microsoft SQL 2 tables alias GROUP BY questions

    Hi, I got the following question. I got 2 tables in Lets say A and B Structures of the tables are: "A" table "B" Table OldName Number New_name Number Value Time Time field in "B" table in following format "YYYY-MM-DD...

Part and Inventory Search

Back
Top