Remove all the "3 spaces" and replace it with a "tab". I do have it on "Indent clause content normally"
Also, I have updated, the screenshot is from awhile ago.
Code: Select all
ALTER FUNCTION timeDuration
(
@startDate DATETIME,
@endDate DATETIME = NULL
)
RETURNS NVARCHAR(128)
AS
BEGIN
IF @endDate IS NULL
SET @endDate = getdate()
RETURN CASE
WHEN datediff(SECOND, @startDate, @endDate) < 45 --3 tabs, 3 spaces
THEN --4 tabs, 3 spaces
'Just Now' --5 tabs, 3 spaces, etc
WHEN datediff(SECOND, @startDate, @endDate) < 90
THEN
'1 minute'
WHEN datediff(MINUTE, @startDate, @endDate) < 45
THEN
cast(datediff(MINUTE, @startDate, @endDate) AS NVARCHAR) + ' minutes'
WHEN datediff(MINUTE, @startDate, @endDate) < 75
THEN
'1 hour'
WHEN datediff(HOUR, @startDate, @endDate) < 9
THEN
CASE
WHEN datediff(MINUTE, @startDate, @endDate) - (datediff(HOUR, @startDate, @endDate) * 60) >= 15 AND datediff(MINUTE, @startDate, @endDate) - (datediff(HOUR, @startDate, @endDate) * 60) <= 45
THEN
cast(datediff(HOUR, @startDate, @endDate) AS NVARCHAR) + '.5 hours'
ELSE
cast(datediff(HOUR, @startDate, @endDate) AS NVARCHAR) + ' hours'
END
WHEN datediff(HOUR, @startDate, @endDate) < 22
THEN
cast(datediff(HOUR, @startDate, @endDate) AS NVARCHAR) + ' hours'
WHEN datediff(HOUR, @startDate, @endDate) < 36
THEN
'1 day'
WHEN datediff(DAY, @startDate, @endDate) <= 4
THEN
CASE
WHEN datediff(HOUR, @startDate, @endDate) - (datediff(DAY, @startDate, @endDate) * 24) >= 8 AND datediff(MINUTE, @startDate, @endDate) - (datediff(DAY, @startDate, @endDate) * 24) <= 16
THEN
cast(datediff(DAY, @startDate, @endDate) AS NVARCHAR) + '.5 days'
ELSE
cast(datediff(DAY, @startDate, @endDate) AS NVARCHAR) + ' days'
END
WHEN datediff(DAY, @startDate, @endDate) < 12
THEN
cast(datediff(DAY, @startDate, @endDate) AS NVARCHAR) + ' days'
WHEN datediff(WEEK, @startDate, @endDate) < 4
THEN
CASE
WHEN datediff(DAY, @startDate, @endDate) - (datediff(WEEK, @startDate, @endDate) * 7) >= 3 AND datediff(DAY, @startDate, @endDate) - (datediff(WEEK, @startDate, @endDate) * 7) <= 5
THEN
cast(datediff(WEEK, @startDate, @endDate) AS NVARCHAR) + '.5 weeks'
ELSE
cast(datediff(WEEK, @startDate, @endDate) AS NVARCHAR) + ' weeks'
END
WHEN datediff(DAY, @startDate, @endDate) < 38
THEN
'1 month'
WHEN datediff(MONTH, @startDate, @endDate) <= 6
THEN
CASE
WHEN datediff(DAY, @startDate, @endDate) - (datediff(MONTH, @startDate, @endDate) * 30) >= 10 AND datediff(DAY, @startDate, @endDate) - (datediff(MONTH, @startDate, @endDate) * 30) <= 20
THEN
cast(datediff(MONTH, @startDate, @endDate) AS NVARCHAR) + '.5 months'
ELSE
cast(datediff(MONTH, @startDate, @endDate) AS NVARCHAR) + ' months'
END
WHEN datediff(MONTH, @startDate, @endDate) < 12
THEN
cast(datediff(MONTH, @startDate, @endDate) AS NVARCHAR) + ' months'
WHEN datediff(MONTH, @startDate, @endDate) < 15
THEN
'1 year'
WHEN datediff(YEAR, @startDate, @endDate) <= 4
THEN
CASE
WHEN datediff(MONTH, @startDate, @endDate) - (datediff(YEAR, @startDate, @endDate) * 12) >= 4 AND datediff(MONTH, @startDate, @endDate) - (datediff(YEAR, @startDate, @endDate) * 12) <= 8
THEN
cast(datediff(MONTH, @startDate, @endDate) AS NVARCHAR) + '.5 years'
ELSE
cast(datediff(MONTH, @startDate, @endDate) AS NVARCHAR) + ' years'
END
ELSE
cast(datediff(YEAR, @startDate, @endDate) AS NVARCHAR) + ' years'
END
END