Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT orderid, invs.[InvoiceID], invs.[InvoiceDate],
- invs.[InvoiceNumber], invs.[HasClientPaid],
- ROW_NUMBER() OVER (PARTITION by orderid,invs.invoicenumber,HasClientpaid ORDER BY orderid) AS DistNum
- FROM InvoiceLineItems Ilt
- JOIN Invoices Invs ON Ilt.InvoiceID= invs.InvoiceID
Add Comment
Please, Sign In to add comment