Shahid,

Out of curiosity, what did you expect to get from this foruim that you didn't already get from SQLTeam three weeks ago? See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=137201.

When you say the order was changed, did you mean that a select from the table returns the rows in a different sequence than they were in the flatfile? ...

As a starting point, you can determine the day of the week for a date using the DATEPART() function. Also, since DATEDIFF() can be used to count weeks, you may...

Maybe I 'm missing something, but from the code posted, it looks as though since all the data is defined as varchar, the "+" operator would invoke string concatenation, and...

Lynn Pettis (12/22/2009)

---

I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing that trend?

(Okay, two...

Kit G (12/21/2009)

---

GilaMonster (12/21/2009)

---

Alvin Ramard (12/21/2009)

---

You're...

When you create your output flat file connection manager, the creation dialog offers you the choice of fixed length as opposed to delimited or ragged right. I believe that ragged...

A networked ring of a thousand Radio Shack TRS-80s running B-Trieve, asisted by a staff of thirty or so go-fers swapping floppy disks?

Julie, I've been through a similar experience posting a QOD and then finding out that I'd missed a point. Don't fret over that.

But, more important than a statement of...

GSquared (12/16/2009)

---

CirquedeSQLeil (12/16/2009)

---

john.arnott (12/16/2009)

---

CirquedeSQLeil (12/14/2009)

---

Alvin Ramard (12/14/2009)

---

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around -...

CirquedeSQLeil (12/14/2009)

---

Alvin Ramard (12/14/2009)

---

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall...

I sympathize with you, Ray. I too have to support some old DTS packages with SQL 2005. Sooner or later, our management will budget the resources to re-build their...

Great question. It took me thorugh several layers. I had to realize that the trigger could never reach the "did not fire" branch of the if statement. Then, I...

Bob Hovious 24601 (11/24/2009)

---

Welcome to The Thread, Les!! 😀

In order to avoid redundancy and repetition and redundancy, we have established an informal rule that newcomers first review...

I'd always heard that Irish Coffee was the perfect food as it comprises all of the major food groups:

Alcohol

Sugar

Caffeine