Consider the table below
Is it possible to display the data in such way that when i read through the data if the first partno. in the table has the number of panels greater than owed, then i don't won't to dispaly the other partno. schedule on the same date(sch_date).
You can always write a view on top of your table. but need to define the business logic first, how are you defining the first row, how grouping is done. based on these logic either create a view or stored procedure.
answered Aug 21 at 07:45 PM