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

    Does anyone have an idea to improve this SQL???

    Bingo !!!! the diference is only because i'm forgot [yawn] to put in the first SQL one modification that i do after....[banghead] , Sum(IIf(RD="D",valor_real,0)) AS salario that's works GREAT now!!! One Coffee to me and one Star to you...
  2. Thiesen

    Does anyone have an idea to improve this SQL???

    Thanks, PHV, but i am confused because don't understand why your SQL returns 43952 lines and my SQL return 43951 lines..[ponder][ponder][ponder]
  3. Thiesen

    Does anyone have an idea to improve this SQL???

    I write this SQL, but i think it's very ugly (but very functional).... it make a sum of 3 diferents fields of BD and show then. SELECT user_id, month, year, Sum(A808_real) AS T808_real, Sum(Airrf_real) AS Tirrf_real, Sum(sal_liq) as salario from (SELECT GG_OSS_captura_real.user_id...
  4. Thiesen

    How to show only one line per id

    Thank's Paul, but i'm forget to say: The table have near 12000 lines (1156 ID x 12 month x 12 year), and i dont know when the person was included in the table.[ponder]
  5. Thiesen

    How to show only one line per id

    I have a table with three colunms PERSON_ID, MONTH, YEAR. PERSON_ID MONTH YEAR 1071403 5 1991 1071403 6 1991 1071403 7 1991 1071403 1 1992 1183071 3 1991 1183071 5 1991 1183071 9 1991 1183071 3...
  6. Thiesen

    Show register that not exists in table

    I will try: 01) My users after each transaction, send a report. 02) I need to know which reports was not been sent to me 03) the first 2 digits of Num_doc is the branch office code("11" in example) 04) with this information in hands I will call to ask where the report???" I explained correctly?
  7. Thiesen

    Show register that not exists in table

    i think those answers are not applied to my problem (translated by babelfish ;-))
  8. Thiesen

    Show register that not exists in table

    To show the registers of a table: Select * from table. It´s OK. But i need to show which documents had not been sent still.... Example of table: Num_doc city owner day_month 110001 Fpolis John 01/05 110002 Palhoça Peter 02/05 110003 Fpolis...

Part and Inventory Search

Back
Top