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!

Recent content by Thiesen

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

Part and Inventory Search

Back
Top