<div>
Did you inherit these functions, and what are you trying to do here? <br />
'What the hell is this?' is not the most actionable question.
</div>


Did you inherit these functions, and what are you trying to do here?
'What the hell is this?' is not the most actionable question.

<div>
<div class="content wysiwyg-content">
Hi <br />
I have 2 functions and not sure what it does and why structured this way.<br />
<br />
Fun_a:<br />
<br />
Create function x()<br />
Return table<br />
As<br />
Return<br />
(Select distinct ID from fun_b(getdate()) as result)<br />
Go<br />
<br />
Fun_b:<br />
Create function fun_b(@asifdate datetime)<br />
Return table<br />
As<br />
Return<br />
(<br />
Select distinct cc as ID<br />
&nbsp;( select a,s,f from tbl<br />
Where year = '2014') as result)<br />
Go<br />
<br />
What are these getdate and why two functions when get date is not used within query?
</div>
</div>


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?

SQL function

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.