how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]

by

i think you should use 

SELECT DATEDIFF(day,'2014-06-05','2014-08-05') AS DiffDate

and result is

DiffDate
61

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. Search SQL by date ASP.NET
  3. Sql: Incorrect syntax near ‘(‘ [closed]
  4. Is there a good LINQ way to do a cartesian product?
  5. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  6. Entering keys manually with Entity Framework
  7. Read SQL Table into C# DataTable
  8. Pass table valued parameter using ADO.NET
  9. DropdownList DataSource
  10. Stop SQL query execution from .net Code
  11. ASP.NET ODBC Query with parameters
  12. What is passing parameters to SQL and why do I need it?
  13. How to make LINQ execute a (SQL) LIKE range search
  14. Index (zero based) must be greater than or equal to zero
  15. no overload for method “ToString” takes 1 arguments
  16. Database Error: There is no row at position 0
  17. How to Deserialize XML document
  18. Path.Combine for URLs?
  19. Force download of a file on web server – ASP .NET C#
  20. How to retrieve data from a SQL Server database in C#?
  21. how to call a variable in code behind to aspx page
  22. Sending an array of values to Oracle procedure to use in WHERE IN clause
  23. Write PDF stream to response stream
  24. How to set attributes values using reflection
  25. How can I handle forms authentication timeout exceptions in ASP.NET?
  26. SQL/C# – Best method for executing a query
  27. Inline code in head tag – ASP.NET
  28. How require authorization within whole ASP .NET MVC application
  29. What is the difference between Debug Mode and Release Mode in Visual Studio 2010? [duplicate]
  30. Accessing controls created dynamically (c#)

Leave a Comment