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 dencom 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 hugoscp1

  1. hugoscp1

    sql query

    Thank you for the reply. Please tell me what I should do. Rewrite the code for me please. If I delete a column field will it work? Please help me
  2. hugoscp1

    sql query

    I try this query: select t.clndhf, t.ciusmd, t.nmismd, SUM(Quantity) as Num_Products from ( select clndhf, ciusmd, nmismd, sum(qtfdhf) as Quantity from swapfilio.EESWPLFD join swapfilio.EESWPLFH on SOCSLD = SOCSLH and CODSLD = CODSLH join swapfilio.gesmd on SOCSLD = socsmd and NIISLD =...
  3. hugoscp1

    sum grandtotal per code article (ciusmd)

    acho que és portugues, vou escrever em portuguès, para quê o count quando eu preciso é do sumatório
  4. hugoscp1

    sum grandtotal per code article (ciusmd)

    the last column is what i want to calculate. Its the sum (QTD) of the article (ciusmd) Example: This article 6191569 (ciusmd) as this quantatys (QTD) 2 +2 +1 = 5 (i want the sum 5 in this example in all 6191569 lines) and the article 5179627 as 160 + 92 + 1 + 11 (QTD) = 264 (i want the sum 264...
  5. hugoscp1

    sum grandtotal per code article (ciusmd)

    this is my query: select NFREFC, nmff01, ciusmd, nmismd, sum(QRCEGP) as qtd from swapfilio.gcffc join swapfilio.gcffp on SOCEFC = SOCEFP and NFREFC = FRNEFP and NRFEFC = NRFEFP join swapfilio.gcfgp on SOCEGP = SOCEFP and ARMEGP = ARMEFP and AGREGP = AGREFP and NGREGP = NGREFP and NLNEGP =...
See more

Part and Inventory Search

Back
Top