Kingston Dhasian (10/6/2010)

---

Normally formatting such as these is done in the front end. Anyways this should help you out

SELECT CONVERT(varchar(12), WDate, 103) + ' ' + CONVERT(varchar(28), WDate, 8)...

I'm sure there must be a better way to do this, but try this: -

SELECT CONVERT(VARCHAR, wdate, 103) + ' ' + Ltrim(

...

Wrong way around.

CONVERT(SmallDateTime,'2010-01-01')

That sucks. . . I really enjoy these comics! What can we do to stop them being finished?

SELECT crn, admission, admdate, admtime, disdate, admsource, admtype

FROM mfCarlRepos.dbo.admissions as table_name1

WHERE admdate BETWEEN '2010-04-01'...

Resolved.

Unsure why this worked, but here was the solution -

The data-flow was multi-cast between 5 different tasks. All except the second one were green. Turns out the error was in...

Added an error destination file.

Below are a few of the codes that successfully were input into the DB: -

PA24Z

MC03Z

FZ07B

NZ05A

WA22X

DZ21H

FZ03A

FZ03A

Now here are a few that failed and were instead redirected :...

True. I didn't really look at the format required,...

Assuming @logicaldate is datetime, it should be

SELECT CONVERT(NVARCHAR(255), @logicaldate, 102)

---

-Edit-

Lol, think I was a little slow :hehe:

SELECT [name] ...

Lowell (9/9/2010)

---

I know there is usually a reason behind everything in your posts , Jeff...I love reading your posts specifically because I learn something (and...

ORDER BY ID

??

In the last six months my title has changed from "Applications Development Consultant" to "Software Developer" - yet my actual job hasn't changed at all. Can't say I really care...

Brandie Tarvin (8/31/2010)

---

I know most people know I was joking in my original post, but in case you didn't get it, I was joking. I'm impressed at the number of...

suraj.app (8/31/2010)

---

Hi,

In a transaction there are 3 update statements. The 2nd update statement invokes a trigger which in turn updates a audit table.

The 3rd update fails which rolls back...