Dinakar,

You were right, the parameter should have been in format YYYY-MM-DD not DD/MM/YYYY! It works perfectly now!

Hi A.J,

Thanks for the response but here is what I'm actually doing:

 @Date_DT DATETIME  AS

DECLARE @Cnt INT

SET @Cnt = (SELECT COUNT(*)

FROM Diary_T

WHERE Diary_Date_DT = @Date_DT)

PRINT @Cnt

When I execute this I get:

Server:...

Thanks Kenneth

Thanks for that!

That's perfect! Thank you both for your help!

Hi Rayola,

Could you provide an example of the SP you are describing please?

Thanks Mike, so as well as defining the priamry key I must also add a constraint on the relevant columns in the three tables.