Below is the SP
ALTER procedure [dbo].[ViewSreg]
@Mobile nvarchar(30)
as
begin
select *,
(select TOP 1 Behcode from Behcode group by Behcode, date having date=MAX(date)) behcode
from S_register
where Mobile=@Mobile
end
And I tested in SQL server
EXEC [dbo].[ViewSreg] '098745'
And it is showing results