Viewing 3 posts - 1 through 4 (of 4 total)
Thank You for your Help. I changed the Where clause up a little bit and that seemed to help. I wished I could make it faster but I guess this...
March 23, 2011 at 2:17 pm
#1302707
I just check the table and followup is a datetime column.
Thank You
March 23, 2011 at 1:46 pm
#1302694
Thank You for responding.
In regards to the time and date. I also have tried (REPLACE(CONVERT(char(10), dbo.Notes.FollowUp, 111), '/', '') <= REPLACE(CONVERT(char(10), GETDATE(), 111), '/', '')).
But I still get...
March 23, 2011 at 1:42 pm
#1302692