asked on SQL function
Hi
I have 2 functions and not sure what it does and why structured this way.
Fun_a:
Create function x()
Return table
As
Return
(Select distinct ID from fun_b(getdate()) as result)
Go
Fun_b:
Create function fun_b(@asifdate datetime)
Return table
As
Return
(
Select distinct cc as ID
( select a,s,f from tbl
Where year = '2014') as result)
Go
What are these getdate and why two functions when get date is not used within query?
I have 2 functions and not sure what it does and why structured this way.
Fun_a:
Create function x()
Return table
As
Return
(Select distinct ID from fun_b(getdate()) as result)
Go
Fun_b:
Create function fun_b(@asifdate datetime)
Return table
As
Return
(
Select distinct cc as ID
( select a,s,f from tbl
Where year = '2014') as result)
Go
What are these getdate and why two functions when get date is not used within query?
Microsoft SQL Server 2008SSRS
Last Comment
Jim Horn
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
'What the hell is this?' is not the most actionable question.