ScottPletcher (7/9/2012)

---

SQLKnowItAll (7/9/2012)

---

What am I missing... How can it be...

What am I missing... How can it be derived?

Gullimeel (7/9/2012)

---

I completely disagree. If I know I want rows where the createdDate was between '2012-05-01 13:32:00.000' AND '2012-05-01 13:35:00.000' why on earth would I want to convert those to...

Gullimeel (7/9/2012)

---

Gullimeel (7/9/2012)

--------------------------------------------------------------------------------

I would suggest a derived column like diff in minutes since say Jan 01.01.1900 and put that columns in both the tables.Then use that column. for join...

To the OP, what difference does it make if the ids in the accountsales table don't match up with dates in the accounts table? They will never match up, presumably....

Gullimeel (7/9/2012)

---

I would suggest a derived column like diff in minutes since say Jan 01.01.1900 and put that columns in both the tables.Then use that column. for join along with...

Glad to help! Below is the link I use for reference:

http://msdn.microsoft.com/en-us/library/ms191479.aspx

Add a created date column to the accountsales table.

Gullimeel (7/9/2012)

---

The best way to do is to first generate the format file using the bcp.Once that is done.You can use that file to bulk import or for bcp.

e.g. use...

Try changing the "\r" to "" or "\r\ n" (without the space before the n... I had to do that to get this to post properly)

Well, your format file is wrong for starters... So change the columns to 3 instead of 2. Also, assuming this is 2008 since you are in a 2008 forum,...

Agreed all around. So, when we needed to look up a balance on a current customer we could do that calculation on a small number of records from just...

Lynn Pettis (7/9/2012)

---

SQLKnowItAll (7/9/2012)

---

Well, personally, I like my createdBy, createdDAte, modifiedBy, modifiedDate at the end of the table. Of course, it really doesn't matter... but it makes it seem...

Well, personally, I like my createdBy, createdDAte, modifiedBy, modifiedDate at the end of the table. Of course, it really doesn't matter... but it makes it seem more logically organized....

I am actually against Lowell's thoughts in many cases. Specifically, generating balances for a customer on a monthly or weekly basis. We then store those balances along with...