Is there anything special that I need to consider if I'm going to create a counter table that's single column, single row?
It's for creating unique serial numbers for labeling, so a program will determine that it needs 20 labels, and will do do a SELECT Count_Num FROM COUNTTABLE and then use that as a base to start the labels and then do an UPDATE COUNTTABLE SET Count_Num = (SELECT Count_Num FROM COUNTTABLE)+20.
So would it just be a: CREATE TABLE dbo.COUNTTABLE (Count_Num int)
Good thinking, we only have one label printer and one person processing right now, but we'll be adding more at some point so probably a good idea. (As long as the labeling program can handle both at once...)
Single Column Table
Posted - 03/14/2013 : 13:37:15
