I guess there should be alot of information on the web. Have you tried to google for OPENXML and VBSCRIPT?

//Hanslindgren

Just for information:

SET DATEFORMAT YDM

SELECT CAST( '2005-05-07' AS DATETIME)

SET DATEFORMAT YMD

SELECT CAST( '2005-05-07' AS DATETIME)

Produces WRONG result. I.e you can't trust the format 'YYYY-MM-DD'.

Though going with the ISO 8601...

zahi antoine,

have you tried it with alot of XML? Have you seen that it will be malformed?

As stated before. QA has a ROW...

I most certainly agree.

Having the wrong data types are not just bad. It is worse then bad

* You miss out of some aspects of declarative...

Hehe, sorry. Obviously I forgot part that before I started answering

I don't see anything else that I might point out though... But since...

I guess the most fool proof way of determining if it is convertible to float would be a regular expression (I.e something like ^(\+|-)?[0-9]*(\.[0-9]*)?$ . Unfortunatly that must be...

Yeah, I thought about it But then it would have been a full Euro and not some cents

Have you tried to recreate the non clustered index? Checked for table inconsistency? Maybe you get different query plans for your queries and your index/table is corrupt (which could lead to different...

...which, for claritys sake, could also look like this

Select *

from dbo.MyTable

where DateCol between DATEADD(MONTH, -1 , GETDATE()) and <A href="mailto

SELECT CONVERT(FLOAT, '$')

Could be...