mmm, becuase I have just posted a sample for Pro_progress, it has more than Receive, Repair,Test....other 20 Records
so Need something Dynamic
Sean Stuber
>>> so Need something Dynamic
you can't.
As noted above - SQL doesn't work that way.
If you can use pl/sql and generate a report then ok. If you're looking for a sql statement then you'll have to specify the 20 fields
johnsone
Is it truly dynamic? Could there really be a new status added to the tables without some sort of other significant code change? It would seem to me that while the number is large, it should be fairly static. A lengthy query to write, but certainly possible. What has been posted already is your framework, just keep adding more status codes to it.
so Need something Dynamic