Try this
Create function dbo.fn_GetOverFromBall (@input INT)
returns NVARCHAR(10)
begin
declare @finalresult nvarchar(10)
declare @over int
declare @ballremaining int
select @over=@input/6 , @ballremaining=@input%6
set @finalresult=Convert(varchar(10),@over) + Convert(varchar(10),'.') + Convert(varchar(10),@ballremaining)
return @finalresult
end
and then call the function like this way
select dbo.fn_GetOverFromBall('14') as [OP]
--out put will be
OP
2.2
Thanks