Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ProductID | PrductName | Enable | Disable |
16 | ProdA | 12/20/13 | NULL |
45 | ProdK | 10/18/13 | NULL |
49 | ProdB | 11/12/14 | NULL |
16 | ProdA | NULL | 12/05/14 |
45 | ProdK | NULL | 12/31/14 |
16 | ProdA | 11/20/14 | NULL |
Now I want following Output:
ProductID | PrductName | Enable | Disable | Price |
16 | ProdA | 12/20/13 | NULL | 10 |
45 | ProdK | 10/18/13 | NULL | 10 |
49 | ProdB | 11/12/14 | NULL | 10 |
16 | ProdA | NULL | 12/05/14 | 0 |
45 | ProdK | NULL | 12/31/14 | 0 |
16 | ProdA | 11/20/14 | NULL | 10 |
Please help me to find the solution.
Thanks..
please post sample app and define the logic to calculate the Price column.
what is the logic behind it? how are you getting the price? it is not available in the first chart