Use the CAST fuction. If your datetime column is in a format different from the server default you can also use CONVERT and specify the format/style of the date string.

CREATE...

Two things.

1. d65cafc-1435-45d3-acce-dc464f02c4b1 is not a proper UNIQUEIDENTIFIER. The first grouping only has 7 characters when there should be 8.

2. Don't rely on implict conversions. CAST the GUID string to...

You might try wrapping the date strings in single quotes before you pass the query.

PS: Be aware this could be dangerous.(see SQL Injection)

Are you asking about dirty data or dirty reads?

You might want to comapre the settings for TEMPDB. ALthough, I'm not sure what would cause that particular issue.

Here is one way: -- Setup Data

SET DATEFORMAT DMY

DECLARE @Foo TABLE (Val1 VARCHAR(50), Val2 VARCHAR(50), DateVal DATETIME)

INSERT @Foo

SELECT '26,4069', 'Caudal', '20-05-2010 1:02:12'

UNION ALL SELECT '26,5306', 'Caudal', '20-05-2010 1:07:13'

UNION ALL SELECT...

This doesn't answer your question, but I would highly suggest that you do NOT use database mail for such a task. The application should handle such things.

But, if you want...

HowardW (6/30/2010)

---

It would be interesting to see if this could be converted to an Inline Table Valued Function that avoided using table variables - that's the way to really improve...

Is the table a heap or did you just omit the clustered index?

To add to what BT said, SQL is Cost Based. So, how the optimizer does it business is based on the perceived cost (this cost could be out of whack...

Like is a bit funky when it comes to trailing spaces. You need to switch things around for a proper comparison:SELECT testdata

FROM @tbl

WHERE 'a' LIKE testdata

Maybe this will help?

http://support.microsoft.com/kb/316626

EDIT: Forgot to markup the URL.

The Dixie Flatline (6/10/2010)

---

Despite the BOL language that suggests ANSI_PADDING can allow you to store trailing blanks in a column with VARCHAR datatype, it appears that the actual behavior is...

Lowell already pointed out where the rounding point happens. But, just as an FYI, BOL says (where ss means Seconds):

ss is two digits, ranging from 00 to 59, that represent...

Business rules. Business Rules.. Business Rules.. 😀

Ideally if you can get them in words, not just entites and relationships. That way that business folks can review them for accuracy.

For example,...