Rank Table Sales Setup with Sale

• angelreynosog

  Mr or Mrs. 500

  Points: 595

  More actions

  January 10, 2019 at 2:53 pm

  #409427

  Hello DistinguishedThey could help me with this case, I have a column that shows the sales of each client. This is in a table. But I want to evaluate the result of the sale with another table that has the ranges of sales, which gives the level of it.

  

  Thanks

• ScottPletcher

  SSC Guru

  Points: 101118

  More actions

  January 10, 2019 at 3:05 pm

  #2018639

  Your ranges have gaps: where would 500,000.50 fall?

  At any rate, something like:
  
SELECT s.sales, ss.Nota
FROM sales s
LEFT OUTER JOIN sales_setup ss ON s.sales BETWEEN ss.rango_inf AND ss.rango_sup

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

• angelreynosog

  Mr or Mrs. 500

  Points: 595

  More actions

  January 11, 2019 at 1:21 pm

  #2018726

  ScottPletcher - Thursday, January 10, 2019 3:05 PM

  Your ranges have gaps: where would 500,000.50 fall?

  At any rate, something like:
  
SELECT s.sales, ss.Nota
FROM sales s
LEFT OUTER JOIN sales_setup ss ON s.sales BETWEEN ss.rango_inf AND ss.rango_sup

  Thanks Very Much!!  I work perfectly!!

• Jeff Moden

  SSC Guru

  Points: 1004403

  More actions

  January 11, 2019 at 2:11 pm

  #2018735

  angelreynosog - Friday, January 11, 2019 1:21 PM

  ScottPletcher - Thursday, January 10, 2019 3:05 PM

  Your ranges have gaps: where would 500,000.50 fall?

  At any rate, something like:
  
SELECT s.sales, ss.Nota
FROM sales s
LEFT OUTER JOIN sales_setup ss ON s.sales BETWEEN ss.rango_inf AND ss.rango_sup

  Thanks Very Much!!  I work perfectly!!

  It would except you didn't answer his question... you have gaps in your ranges... that needs to be repaired.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• HappyGeek

  SSCoach

  Points: 18729

  More actions

  January 13, 2019 at 4:50 am

  #2018787

  Jeff Moden - Friday, January 11, 2019 2:11 PM

  angelreynosog - Friday, January 11, 2019 1:21 PM

  ScottPletcher - Thursday, January 10, 2019 3:05 PM

  Your ranges have gaps: where would 500,000.50 fall?

  At any rate, something like:
  
SELECT s.sales, ss.Nota
FROM sales s
LEFT OUTER JOIN sales_setup ss ON s.sales BETWEEN ss.rango_inf AND ss.rango_sup

  Thanks Very Much!!  I work perfectly!!

  It would except you didn't answer his question... you have gaps in your ranges... that needs to be repaired.

  +1, but I don't think the OP gets it!

  ...