I have the following Stored procedure.  There is column named
"tcktreceived" in my database and I want to pass all the rows one by
one to the parameter @starttime.  I don't know how to do it.

CREATE PROCEDURE [twcsan].[usp_DateDiff]
    -- Add the parameters for the stored procedure here
    @starttime DateTime

AS
BEGIN
DECLARE @Diff Varchar(15)
DECLARE @Day INT
DECLARE @Hour INT
DECLARE @Minute INT
DECLARE @Start_Date DateTime
DECLARE @End_Date DateTime
DECLARE  @itemReceived DateTime
DECLARE @ID INT
DECLARE @message VARCHAR(50)

DECLARE @table TABLE
(
 ItemReceived DateTime,
 ID INT,
 message text,
 Differnce VARCHAR(20)

)
    SET NOCOUNT ON;
 SET @Start_Date = @starttime

SET @End_Date = GETDATE()
SET @Day = DATEDIFF( day, @Start_Date, @End_Date)
SET @Hour = DATEDIFF(hour , @Start_Date, @End_Date)
SET @Minute = DATEDIFF(minute , @Start_Date, @End_Date)
SET @Minute = @Minute-(@HOUR* 60)
SET @Hour = @Hour-(24* @Day)
SET @Diff = CONVERT(Varchar, @Day) +'d ' + CONVERT(Varchar , @Hour) +
'h ' + CONVERT(Varchar , @Minute) +'m'

INSERT INTO @table(ItemReceived, ID, message, Differnce)
select tck.tcktreceived, tck.ticketid,tckmsg.tcktmessage,@Diff
from tbtickets tck inner join  tbticketsmessages tckmsg
on tck.ticketid = tckmsg.ticketid

select * from @table

END