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

So what in plain english are you trying to do? Find the difference in two dates?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.