DATEDIFF() Function

[suhash]

Hi there.
I have the following simple procedure. I dont get a value for @Diff. Any Ideas?

CREATE PROCEDURE RecordOptimise AS
declare @RecordDate datetime
declare @TimeNow datetime
declare @Diff int
Set @TimeNow = GETDATE()
select @Diff = DATEDIFF(ss, @RecordDate, @TimeNow)
select @RecordDate = (Select TimeOut From PeerFileListCollection Where PeerID ='11')
print @RecordDate
print @TimeNow
Print @Diff
GO


Thanks in advance

Mal.

 

[RobertT687]

Swap the order of these two lines to be:
select @RecordDate = TimeOut From PeerFileListCollection Where PeerID ='11'
select @Diff = DATEDIFF(ss, @RecordDate, @TimeNow)

This assumes the select of TimeOut will return ONLY one value.

 

[suhash]

Hi

I swap the statements, Now it works... Actually it should be the way how stupid i can be sometimes...

thanks for pointing out..

Mal.