Create proc RecentComment @email nvarchar(100),@shortUrl nvarchar(50),@lastModifiedOn datetime,@currentDate DATETIME as select title,content from userComment inner join shortUrl on userComment.registeredUserId= shortUrl.shortUrlId and shortUrl.shortUrl=@shortUrl and userComment.lastModifiedBy=@lastModifiedOn inner join userUrl on shortUrl.shortUrlId =userUrl.registereduserId inner join registeredUser on userUrl.registereduserId=registeredUser.registeredUserId where registeredUser.email=@email --SET @lastModifiedOn = '2011-01-02 11:35:26' SET @currentDate = '2011-01-06 03:15:31' -- Total seconds in a day---- DECLARE @TotalSec int SET @TotalSec = 24*60*60; -- Convert DateDiff into seconds DECLARE @DiffSecs int SET @DiffSecs = DATEDIFF(SECOND, @lastModifiedOn, @currentDate) SELECT CONVERT(char(2), (@DiffSecs/@TotalSec))as [Days], CONVERT(char(2), ((@DiffSecs%@TotalSec)/3600)) as [Hours], CONVERT(char(2), (((@DiffSecs%@TotalSec)%3600)/60)) as [Minutes], CONVERT(char(2), (((@DiffSecs%@TotalSec)%3600)%60)) as [Seconds]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)