Hi,
i have one sql queries.i want to retrieve hour and minutes. As per client requirement,i want to add display like this.
Ex--its retrieving like this(1281.5270). it should retrieve as 1281.275(means it should add 5+270=275). i have one sql quiries--
select (cast(Sum(IsNull(Effort1,0))as varchar(50))+''+ cast(Sum(IsNull(Effort1Minutes,0))as varchar(50))) as Total1,
(cast(Sum(IsNull(Effort2,0))as varchar(50))+''+ cast(Sum(IsNull(Effort2Minutes,0))as varchar(50))) as Total2,
(cast(Sum(IsNull(Effort3,0))as varchar(50))+''+ cast(Sum(IsNull(Effort3Minutes,0))as varchar(50))) as Total3,
(cast(Sum(IsNull(Effort4,0))as varchar(50))+''+ cast(Sum(IsNull(Effort4Minutes,0))as varchar(50))) as Total4,
(cast(Sum(IsNull(Effort5,0))as varchar(50))+''+ cast(Sum(IsNull(Effort5Minutes,0))as varchar(50))) as Total5,
(cast(Sum(IsNull(Effort6,0))as varchar(50))+''+ cast(Sum(IsNull(Effort6Minutes,0))as varchar(50))) as Total6,
(cast(Sum(IsNull(Effort7,0))as varchar(50))+''+ cast(Sum(IsNull(Effort7Minutes,0))as varchar(50))) as Total7
FROM TimeSheetDetail
whenever i am running this above quiries.i am getting 1281.5270(this one just only concatination). now i want to display like this(1281.275)
how i will add this ? pls reply me