Glitch: Output for custom SQL table incorrect?

Follow

David Babayev

June 11, 2019 17:06

Hi, 

I've created a custom SQL table with a CustomerID, OrderID, OrderDate, a rank called RankKey, and a join key that is (CustomerID + RankKey). For some reason, the output for the join key uses a different CustomerID from the CustomerID in its own row! Why would a CustomerID of ALFKI give a join key that uses CustomerID GREAL ?? (code below and output attached)

Any help would be greatly appreciated! Thanks so much!

David

SELECT o.CustomerID, o.OrderID, o.OrderDate,
RANKASC(o.CustomerID, o.OrderDate) AS RankKey,
CONCAT(toString(RANKASC(o.CustomerID, o.OrderDate)), o.CustomerID) AS JoinKey2
FROM Orders AS o

ORDER BY o.CustomerID, o.OrderDate

 

0

• 

  Roopa Raghavan June 13, 2019 20:37

  David,

  I haven't used RANKASC mathematical function, but try using RANKCOMPETITIONASC function and check your results, seems to work.

  Still no idea why the customerID is populated incorrectly in joinkey2

  Let me know.

   

  Roopa

  0

  Comment actions Permalink

Please sign in to leave a comment.