Hi , I am a Newbie using SQL server and vb.net in VS2010.
I am re-writing an exisitng application which is written in an old programming language.
I have a table with invoice records waiting to be assigned an invioce number and invoice date.
I have two ways of uupdating these records , the first way is the user manually selects which records/rows to be updated for a specific customer account number. This all works fine.
I am trying to write a stored proc which goes through all un-invoiced records (i.e invoice number = blank) , it is to group records/rows by account number and assign next invoice number (which i already have astroed proc to fetch) and then when the account number changes to move onto the next batch of records for the next account.
As i said earlier i have this already in another language , i am just trying to get my head around it in an SQL stored Proc.
Any help would be most appreciated