Delet serial number

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Delet serial number Gill 10-29-2007  RE: Delet serial number convoluted 10-30-2007
Posted by Gill on October 29, 2007, 11:39 am Please log in for more thread options I created 75k serail number by mistake.How i delet it. May I get full script ? -- Thank You Harjit SherGill /DBA Altaville Market 324 South Main st po box 370 Altaville CA 95221 Tel : 209-729-1410 vendaliajat@yahoo.com Posted by convoluted on October 30, 2007, 10:21 pm Please log in for more thread options Hi Gill - backup first and if possible try after hours.... Run this first select * from serial where transactionentryid = 0 If that shows you the 75 thousand serial numbers you created by mistake delete them with delete from serial where transactionentryid = 0 If the first select query shows more than the 75 thousand serial numbers you created by mistake, you'll need additional constraints to narrow down the list - hope this helps "Gill" wrote: > I created 75k serail number by mistake.How i delet it. May I get full script > ? > > -- > Thank You > Harjit SherGill /DBA > Altaville Market > 324 South Main st po box 370 > Altaville CA 95221 > Tel : 209-729-1410 > vendaliajat@yahoo.com > > > Similar Threads Posted Automate Serial NUmber transfer and Import Serial Number feature January 30, 2008, 10:26 am Serial Number December 1, 2007, 5:16 pm Serial Number December 6, 2007, 2:48 pm serial number December 21, 2007, 1:51 pm serial number can not be created in POS June 29, 2005, 12:51 pm Dongle Serial Number August 24, 2005, 7:21 pm How can I change a serial number? February 17, 2006, 5:02 am serial number search August 1, 2006, 2:53 am Serial Number Transfers October 26, 2006, 10:06 am Receipt with Serial Number November 5, 2007, 4:41 pm