I have 2 functions and not sure what it does and why structured this way.
Create function x()
(Select distinct ID from fun_b(getdate()) as result)
Create function fun_b(@asifdate datetime)
Select distinct cc as ID
( select a,s,f from tbl
Where year = '2014') as result)
What are these getdate and why two functions when get date is not used within query?
'What the hell is this?' is not the most actionable question.