Very Important crosS Applying yaK Herder
quote:Originally posted by Surya Alekhyatry this it should work finecount(isnull(cast(Total_Count as float),0))
quote:Originally posted by Surya Alekhyatry this simple procedure--exec totccreate procedure totc as begin Declare @rp1 floatDeclare @rp2 floatSelect Distinct@rp1=sum(isnull(cast([Total Count] as float),0))from T_Status_Reportwhere Type = 'LastMonth' and OrderVal = '1'select count(@rp1) as totalcount end
quote:Originally posted by wsilageI didn't get to try it yet. Thanks.