Click here to Skip to main content
15,884,930 members

Comments by abhitechno (Top 15 by date)

abhitechno 4-Jan-14 7:08am View    
there's no magic in the way u used coalesce. it will generate a wrong report.
abhitechno 4-Jan-14 7:04am View    
no no they maynot be zero.
abhitechno 4-Jan-14 7:03am View    
no, this will work, but will get extremely cumbersome to generate consumption report for even 1 material with 20 possible bins. forget about even getting a report for 10 materials stored in 20 bins.
abhitechno 4-Jan-14 7:01am View    
this data is about material_code(s) of different storage bins and the quantity of element released from them. the problem is that any material can be stored in any bin (bin 1 to 5). as a material is changed, the material_code corresponding to that bin is updated. the situation is dynamic and hence assigning a particular material fixedly to a bin is impossible.
abhitechno 26-Aug-13 6:01am View    
thanq