'return value cannot be used in this context at begin

Create function getallWeekDayorWeekends

(

@givenDate as date, @choice as int

)
RETURNS Table as
BEGIN
    if(@choice = 1)
    return (SELECT  cast(DATEADD(DAY, nbr - 1, (SELECT DATEADD(DAY, 2-(DATEPART(WEEKDAY,@givendate )), @givendate)) ) as date) allweekdays
                
        FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY c.object_id ) AS nbr
                    FROM      sys.columns c
                ) nbrs
        WHERE   nbr - 1 <= DATEDIFF(DAY, 
        (SELECT DATEADD(DAY, 2-DATEPART(WEEKDAY, @givendate), @givendate))
        , 
        (SELECT DATEADD(DAY, 6-(DATEPART(WEEKDAY,@givendate )), @givendate))
        ))
return (SELECT DATEADD(DAY, 8-(DATEPART(WEEKDAY,@givendate )),@givendate) union 
        SELECT DATEADD(DAY, 7-(DATEPART(WEEKDAY,@givendate )),@givendate)) 

END
sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions