Hi Guys! I hope this is the right folder to post in (I'm a newbie), as I have a (simple?!) SQL query that's beginning to cause hair loss! :-
The below table is a log of a product being scanned at 5 stages to provide a logged audit trail. At each stage a monitor will display the number of barcodes at that stage.
I am attempting (!) to derive a list of barcodes in any given status, such that only the data for the barcode is listed, and not repeated.
this will give you data in seperate rows...if you need data all on the same row, invvestigate the coalesce command (there are many examples around here)
only issue you need to also checkup is whether or not your answer needs to be across all products, or particular to 1 product....as there doesn't "seem" to be anything on the record to identify a record with a particular product.
Retrieving status data from an audit/history table
Posted - 02/11/2003 : 05:09:39
