General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi. I have a table that contains a product code, description and a quantity. I want to create an sql statement in order to product bar code labels. I cant figure out how to breakdown the quantity so I get a cursor with for each product the number of records relating to the quantity.ie.
Part A is 3, Part B is 2 so I want:
Part A
Part A
Part A
Part B
Part B
Does anyone know a clever way to get this?
TIA,
Sandi
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only