StoredProc Help 1

[TheConeHead]

Hey - new to SP's here... OK - I have this:

select datediff(dd, '10/15/2006 12:15:24 PM', getdate())

but I need to change it so the date will actually be a value from another query... so I need a query to:

select udate from main where id = @recordID

I then need to take udate and put it into something like:

select datediff(dd, udate, getdate())

???

 

[SQLDenis]

declare @udate datetime
select @udate =udate from main where id = @recordID


select datediff(dd, @udate, getdate())

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/