SQL . The SP or function should calculate the next date for friday

by

I’d make this a scalar UDF as it is easier to consume the output.

CREATE FUNCTION dbo.GetNextFriday(
@D DATETIME
)
RETURNS DATETIME 
WITH SCHEMABINDING, RETURNS NULL ON NULL INPUT
AS
BEGIN
RETURN DATEADD(DAY,(13 - (@@DATEFIRST + DATEPART(WEEKDAY,@D)))%7,@D)
END

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Insert an image in a column of a table that already has 5 columns
  3. How to avoid the “divide by zero” error in SQL?
  4. SET versus SELECT when assigning variables?
  5. Querying data by joining two tables in two database on different servers
  6. sql query to return differences between two tables
  7. Real life example, when to use OUTER / CROSS APPLY in SQL
  8. How to print VARCHAR(MAX) using Print Statement?
  9. Convert Xml to Table SQL Server
  10. Concatenate values based on ID
  11. Splitting delimited values in a SQL column into multiple rows
  12. How to find current transaction level?
  13. How to connect to SQL Server from another computer?
  14. EXISTS vs JOIN and use of EXISTS clause
  15. Restrict an SQL Server connection to a specific IP address
  16. Custom aggregate function (concat) in SQL Server
  17. Average of multiple columns
  18. Cumulative Total in MS Sql server [duplicate]
  19. How do I find the data directory for a SQL Server instance?
  20. How can I delete using INNER JOIN with SQL Server?
  21. Convert varchar into datetime in SQL Server
  22. How to do pagination in SQL Server 2008
  23. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  24. Execute Stored Procedure from a Function
  25. How to write UPDATE SQL with Table alias in SQL Server 2008?
  26. SQL Server 2008- Get table constraints
  27. Why are logical reads for windowed aggregate functions so high?
  28. Add a row number to result set of a SQL query
  29. Connect different Windows User in SQL Server Management Studio (2005 or later)
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment