Use scalar-valued functie

declare @days int;

exec @days = dbo.[days_diff] @date1=<value> @date2=<value>;

select @days

---

Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.