Sql function

I ahve the function in sql "lastbusinessday " 
but How can I get the value from that function
Who is Participating?
Imran Javed ZiaConnect With a Mentor Consultant Software Engineer - .NET ArchitectCommented:
by name it seems to be a method to return last working day or date you you may use it as

select lastbusinessday()

and it will return you date or day
select lastbusinessday parameter -- pass the parameter if you have any

if not just

select lastbusinessday
Lee SavidgeCommented:
It depends on what that function does. What parameters does it take?

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

simply u can use
Select * from lastbusinessday
Select * from lastbusinessday('parameter value') --if you hae any parameter
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
if this function returns a table then you can use

select * from dbo.lastbusinessday (parameter)

and if it is a scalar value function then you may use it in some query as field

select dbo.lastbusinessday (parameter)
select dbo.lastbusinessday (parameter), * from your table
peterstiAuthor Commented:
solution is good
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.