Thread: Problem with queries with DATETIME
View Single Post

  #4 (permalink)  
Old 10-09-2004, 03:26 PM
sanereddy sanereddy is offline
Senior Member
  
Join Date: Nov 2004
Posts: 177
sanereddy is an unknown quantity at this point
Re:Problem with queries with DATETIME
try this ....

Create procedure opentasks
@activedate as datetime
AS
Select Count(*) from tasks where activedate = @activedate
GO
Reply With Quote