Viewing 2 posts - 1 through 2 (of 2 total)
Thank you i got it
April 28, 2011 at 1:03 pm
#1317486
i used same earlier but it is displaying like below instaed of 6 iam getting one
216342117122031
216362117122031
select dataitemid,companyId,estimateperiodid, count(prasad)from #prasad_tbl
group by companyId,dataitemid,estimateperiodid,prasad
April 28, 2011 at 12:40 pm
#1317468