SQL User Defined Function Within Select

Question

I have a user defined function in SQL called getBuisnessDays it takes  startdate and  enddate and returns the number of business days between the two dates  How can I call that function within my select   Here s what I d like to do     SELECT getBusinessDays a opendate a closedate   FROM account a WHERE

User · Answer

Use a scalar-valued UDF  not a table-value one  then you can use it in a SELECT as you want

User · Answer

If it s a table-value function  returns a table set  you simply join it as a Table  this function generates one column table with all the values from passed comma-separated list  SELECT   FROM dbo udf generate inlist to table  1 2 3 4

User · Answer

Yes  you can do almost that    SELECT dbo GetBusinessDays a opendate a closedate  as BusinessDays FROM account a WHERE

User · Answer

If it s a table-value function  returns a table set  you simply join it as a Table  this function generates one column table with all the values from passed comma-separated list  SELECT   FROM dbo udf generate inlist to table  1 2 3 4

User · Answer

Yes  you can do almost that    SELECT dbo GetBusinessDays a opendate a closedate  as BusinessDays FROM account a WHERE

User · Answer

Yes  you can do almost that    SELECT dbo GetBusinessDays a opendate a closedate  as BusinessDays FROM account a WHERE

User · Answer

Use a scalar-valued UDF  not a table-value one  then you can use it in a SELECT as you want

User · Answer

If it s a table-value function  returns a table set  you simply join it as a Table  this function generates one column table with all the values from passed comma-separated list  SELECT   FROM dbo udf generate inlist to table  1 2 3 4

User · Answer

Use a scalar-valued UDF  not a table-value one  then you can use it in a SELECT as you want

User · Answer

If it s a table-value function  returns a table set  you simply join it as a Table  this function generates one column table with all the values from passed comma-separated list  SELECT   FROM dbo udf generate inlist to table  1 2 3 4

User · Answer

Use a scalar-valued UDF  not a table-value one  then you can use it in a SELECT as you want

User · Answer

Yes  you can do almost that    SELECT dbo GetBusinessDays a opendate a closedate  as BusinessDays FROM account a WHERE

[sql] SQL User Defined Function Within Select

Examples related to sql

Examples related to sql-server

Examples related to select

Examples related to user-defined-functions