Rob Schripsema (5/18/2010)

---

BUT --- the OP gave an example where the so-called date was in a nn/nn/nnnn format, and the problem was just that one (or potentially more) of the...

I'm not sure of OP's requirements, but there could be scenarios where...

I had a look at the ISDATE() function ( http://msdn.microsoft.com/en-us/library/ms187347.aspx ) and...

asita (5/18/2010)

---

1 step is the best one, but for this i need to use script task in that i have to get each line and had a separator coma (to...

Any specific reason why you would want the SQL query to return that text?...

Trey Staker (5/18/2010)

---

pattamuthu (5/18/2010)

---

Thank you very much, i will give a try with this, before that i need to add a condition when it doesnt reeturn any result then i...

The server name is the SMTP server name and you will...

asita (5/17/2010)

---

Thanks for your reply, i know program a little bit , but not my main stream so could you please give some sample or some example or could you...

John Rowan (5/17/2010)

---

This will not work. Your...

I am a programmer first, so I would think of writing a file parsing routine in a .Net language (VB/C#) and then reference the library to retrieve the parsed resultset...

I would suggest trying this (on a separate set of data first)

update TestTable set myDate = convert(varchar(20), getdate()-3,101)

where myDate <= '01/01/1753'

I think your statement at the end of your post skipped my eyes. Apologies :blush:

And just in case you were wondering why is "08/31/0002" an invalid date time: it's because the earliest date you can store in SQL2K5 is Jan 01, 1753:

I would guess one of the columns in your update statements are being used as part of an index. If so, this forces the index to be re-built after the...

I always have a "Table Designer" menu item whenever I'm in table design mode without any toolbar setting.

A relatively easy start to the week. 🙂