Select CONVERT(VARCHAR,[Last_Edited1],106) As [Date], count([Lead_id]) as [Total Lead] from Avalan_cus
Group By CONVERT(VARCHAR,[Last_Edited1],106)
-
(Select Count([Lead_Id]) from avalan_cus
where [Lead_Id] in(Select Leadid from avalan_extract)Group By CONVERT(VARCHAR,[Last_Edited1],106))
how can i do like this....i hv to substract