<div>
try (if Gnder column data is 1, 2, etc.):
<pre><code id="code-20-40866834-1">CREATE FUNCTION fx_avgVacationHours
(@Gender int)
Returns int
AS
BEGIN
RETURN
SELECT  AVG (VacationHours)
  FROM HumanResources.Employee
where Gender=@Gender
end</code></pre>
</div>


try (if Gnder column data is 1, 2, etc.):

CREATE FUNCTION fx_avgVacationHours
(@Gender int)
Returns int
AS
BEGIN
RETURN
SELECT  AVG (VacationHours)
  FROM HumanResources.Employee
where Gender=@Gender
end

<div>
Thanks eghtebas. The function got created but can you please explain the logic behind it? Gender is not an integer value. Moreover the select statement is giving me an error. Please help me understand the logic.
</div>


Thanks eghtebas. The function got created but can you please explain the logic behind it? Gender is not an integer value. Moreover the select statement is giving me an error. Please help me understand the logic.

<div>
Thank you so much eghtebas. This time it worked and now I understand the logic as well.
</div>


Thank you so much eghtebas. This time it worked and now I understand the logic as well.

<div>
<div class="content wysiwyg-content">
I need to create a function which will return an average of Vacation hours based on Gender.I have written the following code:<br />
CREATE FUNCTION fx_avgVacationHours<br />
(@Gender varchar(50))<br />
Returns int<br />
AS<br />
BEGIN<br />
RETURN<br />
(<br />
SELECT &nbsp;AVG (VacationHours)<br />
&nbsp; FROM HumanResources.Employee<br />
where Gender=@Gender<br />
)<br />
end<br />
<br />
Select dbo.fx_avgVacationHours(2)<wbr /><br />
<br />
But this code is returning me a NULL value.<br />
Please let me know what wrong i am doing here.
</div>
</div>


I need to create a function which will return an average of Vacation hours based on Gender.I have written the following code:
CREATE FUNCTION fx_avgVacationHours
(@Gender varchar(50))
Returns int
AS
BEGIN
RETURN
(
SELECT  AVG (VacationHours)
  FROM HumanResources.Employee
where Gender=@Gender
)
end

Select dbo.fx_avgVacationHours(2)

But this code is returning me a NULL value.
Please let me know what wrong i am doing here.

User Defined 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.