select distinct MRP.[date],FT.feedtype,round(MRP.rateperkg,3) as Rateperkg from K_FS_FeedMrpDetails MRP inner join K_FPS_feedtype FT on FT.sno=MRP.feedtype where MRP.[date] between '2013-08-09 00:00:00.000' and '2014-08-25 00:00:00.000' and MRP.state = 1 and MRP.rateperkg != 0 group by ft.feedtype,mrp.rateperkg order by MRP.[date] desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)