CirquedeSQLeil (2/16/2010)

---

Elliott W (2/16/2010)

---

Grrrr..

Do people not know how to read these days..

Between me and another prominent poster we provided an answer and a link to exactly do the answer. ...

Only problem I see with the solution provided, it doesn't work in SQL Server 7/2000 which is where this post occurs as it is for SSIS, not DTS.

Not really. That was his...

D.Oc (2/13/2010)

---

RBarryYoung (2/12/2010)

---

GSquared (2/12/2010)

---

I'm not sure that's the tag you wanted, Wayne.

Dictionary definition: physic noun: ...

Great. Now, keep an eye on this thread as you may find others that may show you another way to accomplish the task as well. This will give...

The best way to learn SSIS is to use it. I learned SSIS by using it to replace a DTS process written by my predecessor. The DTS process...

Not to be a kill joy, but don't you think you should look at the code provided and see if you can make the necessary changes to format the output...

Duplicate post. Problem is being worked and answered here.

lobbymuncher (2/11/2010)

---

Lynn Pettis (2/11/2010)

---

I may be confused on how things are applied. Could you take one set of records and show how the business rules work to generate one...

CooLDBA (2/11/2010)

---

I was able to change the data to

08-24-2004

08-25-2004

08-26-2004

select CONVERT(datetime, F3, 103) from _CalendarDate

Msg 242, Level 16, State 3, Line 1

The conversion of a char data type to a datetime...

I may be confused on how things are applied. Could you take one set of records and show how the business rules work to generate one of the sample...

Only thing I can think of is to build the query dynamically and execut the query at the end of the try block.

Jakke (2/11/2010)

---

Hi Markus,

Thanks for the reply. 🙂

I will certainly test your solution.

You stated that it would work on not to big tables. Is a table with about 550000 records per...

Michael Jeffrey (2/11/2010)

---

I had forgotten to say that in all cases I am using 32 bit versions of all the software and I am using SQL Express 2008 (the free...

CooLDBA (2/11/2010)

---

CREATE TABLE [dbo].[_CalendarDate](

[F1] [varchar](20) NULL

) ON [PRIMARY]

select * from dbo._CalendarDate

8242004

8252004

8262004

select CONVERT(datetime, F1, 103) from _CalendarDate

Syntax error converting datetime from character string.

I want to convert it to datetime, any...