Tuesday, June 4, 2013

Use scalar-valued functie

MYMY


, I am not sure what your table structure is and what data you have in it.




but a general approach


to use function in select statement is




Select


dbo. day_diff( initial_date, next_date) from yourtable.




initial_date


and next_date are table coumns


Hope this will help


, if you have queries then please provide DDL of your table as well and expected result.



No comments:

Post a Comment