Could you post the DDL for tblUdrElemen so that we can see what the datatype of Value in this table is?
And why do you use Convert(DateTime, ...)? The type DateTime is deprecated. Microsoft recommends the DateTime2 data type.
Do you use the time part of the DateTime field? If not, you had better use the data type Date.
No comments:
Post a Comment