Click here to Skip to main content
15,905,682 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: asp.net and access database Pin
ling_luv18-Jun-07 16:02
ling_luv18-Jun-07 16:02 
GeneralRe: asp.net and access database Pin
Christian Graus18-Jun-07 16:06
protectorChristian Graus18-Jun-07 16:06 
GeneralRe: asp.net and access database Pin
ling_luv18-Jun-07 16:26
ling_luv18-Jun-07 16:26 
GeneralRe: asp.net and access database Pin
Christian Graus18-Jun-07 20:25
protectorChristian Graus18-Jun-07 20:25 
GeneralRe: asp.net and access database Pin
ling_luv18-Jun-07 20:27
ling_luv18-Jun-07 20:27 
GeneralRe: asp.net and access database Pin
ling_luv18-Jun-07 16:50
ling_luv18-Jun-07 16:50 
GeneralRe: asp.net and access database Pin
Christian Graus18-Jun-07 20:26
protectorChristian Graus18-Jun-07 20:26 
Questionpass values Pin
seemamltn18-Jun-07 13:03
seemamltn18-Jun-07 13:03 
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




seema

AnswerRe: pass values Pin
Christian Graus18-Jun-07 13:10
protectorChristian Graus18-Jun-07 13:10 
AnswerRe: pass values Pin
Tarik Guney18-Jun-07 16:36
Tarik Guney18-Jun-07 16:36 
AnswerRe: pass values Pin
Sathesh Sakthivel18-Jun-07 16:47
Sathesh Sakthivel18-Jun-07 16:47 
QuestionLogin failed for user 'DIGITAL-NB\ASPNET'. Pin
aransiola18-Jun-07 9:43
aransiola18-Jun-07 9:43 
AnswerRe: Login failed for user 'DIGITAL-NB\ASPNET'. Pin
Not Active18-Jun-07 12:33
mentorNot Active18-Jun-07 12:33 
Questiondate time difference Pin
seemamltn18-Jun-07 7:36
seemamltn18-Jun-07 7:36 
AnswerRe: date time difference Pin
Not Active18-Jun-07 7:58
mentorNot Active18-Jun-07 7:58 
Questionasp.net help Pin
jonniebigodes18-Jun-07 6:50
jonniebigodes18-Jun-07 6:50 
AnswerRe: asp.net help Pin
Christian Graus18-Jun-07 12:52
protectorChristian Graus18-Jun-07 12:52 
GeneralRe: asp.net help Pin
jonniebigodes18-Jun-07 22:32
jonniebigodes18-Jun-07 22:32 
QuestionASP tags in VS2005 Pin
Heavy Storm18-Jun-07 6:21
Heavy Storm18-Jun-07 6:21 
AnswerRe: ASP tags in VS2005 Pin
Christian Graus18-Jun-07 12:58
protectorChristian Graus18-Jun-07 12:58 
QuestionProblem with Dataset Pin
anshina@advantech.ca18-Jun-07 6:05
anshina@advantech.ca18-Jun-07 6:05 
AnswerRe: Problem with Dataset Pin
Heavy Storm18-Jun-07 6:26
Heavy Storm18-Jun-07 6:26 
GeneralRe: Problem with Dataset Pin
anshina@advantech.ca18-Jun-07 6:32
anshina@advantech.ca18-Jun-07 6:32 
AnswerRe: Problem with Dataset Pin
Not Active18-Jun-07 7:55
mentorNot Active18-Jun-07 7:55 
QuestionPowerPoint Pin
deepaks318-Jun-07 5:18
deepaks318-Jun-07 5:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.