Sorry Steve... you got there before I did... must've been just a couple of seconds because we both posted at the same time. 🙂

Very cool... thanks for the feedback.

You never did identify how you were going to identify which month you wanted...

elmerbotha (6/20/2008)

---

I truly feel honored to be graced by your absolutely meaningful and relevant answers. Truly, I am astounded by your infinite wisdom. Without risking being ridiculed once again by...

JRJ (6/20/2008)

---

Thanks guys for your response, it's really useful. I am just wondering which one will be faster when I deel with some 50,000 records: the one with temp table...

Thanks for the great feedback, Todd...

It's amazing... about 1/3rd of all posts that I respond to lately can easily be solved by a Tally table... I finally convinced the...

Got it... I'll be back.

wolfdeeper (6/20/2008)

---

Ok i'm on this trace till i find some thing "E"nsuring" what i want:D

But i remember have focused into bcp format file and have not seen such an option!!...

You missed it... that was in the first response... :hehe:

Heh... except on Fridays and every 3rd Tuesday.

I

f you don't want to do that, you'll get an approximate number (accurate in most,...

wolfdeeper (6/20/2008)

---

Does BCP format file insure string parsing?

I mean could i extract a field from a string fields by caracter position using the BCP format file?

I think that it's impossible...

Heh... ok, ok... I promise to never draw smiley faces on your helmet ever again 😛

Just a thought... Sometimes, it's faster to export the data to a file, transmit the file to the other server or put the data in an area accessible to both...

Heh... You're not really a DBA unless you know those tricks. 😀 You also have to know the king of tricks to get your morning chores done without...

Heh... just don't let it go to your head... One "Aw, crap" can wipe out a thousand "Atta-boys"... 😀

... except in my shop... if you don't make the occasional...