Alter FUNCTION [dbo].[EF_CalculateTimeDuration_PatIOStatus_Scalar]
(
@arrivaltime varchar(20),
@Chkouttime varchar(20)
)
RETURNS varchar(200)
as
begin
declare @ToTime varchar(10)
declare @ToTimeAM varchar(10)
declare @AnsToTime varchar(20)
declare @FromTime varchar(10)
declare @FromTimeAM varchar(10)
declare @AnsFromTime varchar(20)
declare @AnsString varchar(50)
set @ToTime=SUBSTRING(@arrivaltime,1,5)
set @ToTimeAM=SUBSTRING(@arrivaltime,7,8)
set @AnsToTime=@ToTime+' '+@ToTimeAM
set @FromTime=SUBSTRING(@Chkouttime,1,5)
set @FromTimeAM=SUBSTRING(@Chkouttime,7,8)
set @AnsFromTime=@FromTime+' '+@FromTimeAM &n ...
Go to the complete details ...