Hey biker,your avatar is also kinda cool! Although I prefer a Fireblade Now, for the pseudo topic relation:I think Andy Warren mentioned some time ago, he has some SQL Server table maps to share.
You could have coded your SP as follows CREATE PROCEDURE usp_check_login @username varchar(20), @password varchar(20) AS SET NOCOUNT ON SELECT user_id, user_active as login_active, user_loginattempts as login_attempts, user_type FROM tbl_user WHERE user_username = @username AND user_password = @password RETURN @@ROWCOUNT GO That way you could use your RETURN_VALUE to determine whether or not your user […]
just get rid of the time part on the input and sample dates. Method1 casting as int Cast(@inputDate1 as int) Method2 remove time part @newinputdate = Cast(Convert(varchar(10),@inputDate, 101) as datetime) Method3 you could use acombination of DateDiff using 'd' as the difference HTH