help with update

Hi all.....Im ok with sql but by no means a guru

i have like 100,000 rows of lineitems
example:
invoiceid, lineitemId, squencenum
9999999 11111111 1
9999999 11111181 2
9999999 11111182 3

the Data consistes of Many Invoices and the Lineitem id
is a Unique Id (Most are consequtive but not a Guarantee) and SequenceNum
is 1,2,3, etc of the line items on the invoice

In my Case i have say 100,000 rows , different Invoice numbers with
different number of lineitems
All the LineItems are out of Sync.....

So I need to Update them in the order 1,2,3 etc for there prospective
Invoice number

Help with a Update Scripts would be helpful
Thanks


.

Relevant Pages

  • Re: How do I create "expandable" fields?
    ... If you want it to work like an invoice, where an invoice can have any ... Invoice and LineItems for example ... In the portal settings window,, check ... When you exit, a record is created in lineItems ...
    (comp.databases.filemaker)
  • Re: help with update
    ... 'll use invoice and lineitem ... lineitems have there own identity also unique to ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: can ADD_LINE_ITEM table be duplicated??
    ... In my invoice layout, i have an add line item for my products. ... thing is that i want to make another addline item for my services and ... new table, make the proper relationships, duplicating the script(Sets ... product/service details in teh lineitems portal. ...
    (comp.databases.filemaker)
  • help with update
    ... 'll use invoice and lineitem ... lineitems have there own identity also unique to each ... UPdate command, ... is there a way to renumber the itemNo colum using a update ...
    (comp.databases.ms-sqlserver)