Skip to Content
0
Former Member
Jun 26, 2007 at 11:40 AM

SQL 2000 Invoice - get number of line with batchnum

14 Views

Hi all

Im trying to get a query that show info about lines of invoices and i need to show a number of row (begin on 1 for each invoice) on a query results

INV1.Linenum col don´t useful for me cause im managed batchNum for item

How can i do it for numbering lines on my query results?

Actually im showing:

NºInvoice - NºLinea - ItemCode

0001-0-item001-bacth01

0001-0-item001-batch02

0001-1-item002-bacthB1

0001-1-item002-batchB2

An I want to show something like that:

0001-1-item001-bacth01

0001-2-item001-batch02

0001-3-item002-bacthB1

0001-4-item002-batchB2

thanks in advanced