>SELECT MyTable.MyField FROM MyDatabase.dbo.MyTable WHERE MyTable.AddDate>'2011/03/22 17:08:26'
>
> >...it executes instantly. The result is zero record. > >But, if I parameterize it such as: > >
>DECLARE @Date datetime
>
>SET @Date='2011/03/22 17:08:26'
>
>SELECT MyTable.MyField FROM MyDatabase.dbo.MyTable WHERE MyTable.AddDate>@Date
>
> >...it takes a while. And, the result is still zero record. > >I tried to make the declaration char and nvarchar but that did not help. > >There is something I am missing here.