๐ ๋ชฉ์ฐจ ์์ ์ฟผ๋ฆฌ ํ์ธํ๊ธฐWITH RankedData AS ( SELECT a.OrderID, c.SafeKey, ROW_NUMBER() OVER (PARTITION BY a.OrderID ORDER BY c.SafeKey) AS rn FROM SalesDB.dbo.Orders a LEFT OUTER JOIN SalesDB.dbo.CreditCheckResult b ON a.CreditCheckID = b.ID LEFT OUTER JOIN SalesDB.dbo.SafeKeyLog c ON c.SafeKey = b.SafeKey WHERE a.OrderID IN ( 10001, 10002, 100..