Member Avatar for sachin1025 
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

Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
  • 2 Contributors
  • 1 Reply
  • 52 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

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.