Just suggestions, your milage may vary:

Start with Chris Date's 'Introduction to Database Systems' for a good foundation.  I'm partial to Fabian Pascal, though he's not everyone's cup of tea, who...

This is probably closer:

SELECT PERSON.LAST_NM, PERSON.FIRST_NM, ADDRESS.ADDR_TEXT

FROM PERSON, ADDRESS

WHERE PERSON.EMPLOYEE_ID=ADDRESS.PERSON_ID

You need to ad an 'order by' clause to the cursor definition if you want the rows back in a particular order.  Relational tables have no implied order and unless...

What's the target response time you're looking for?  Is there anyhing else running on the box?  How much memory is SQL Server actually using?

Does this step send out an email?  I've seen this same error scenario when the task works but the email fails.  If that's the case, make sure the sql-sa user...

Gotta agree.  The folks who talk about XML as a data management technology are returning us to IMS and other pre-relational ideas.  Those concepts were displaced by relational ideas for...

Try a lower case 'e'.

Another nice solution (with a single query) can be found here:

http://www.sqlserverprofessionalnewsletter.com/Media/MediaManager/SQL_Sample.pdf#search='sql%20calculate%20median'

'Unexpected EOF' is a pretty generic message.  It normally means that there was a formatting problem somewhere along the line and the BCP program got lost and couldn't figure out...

No problem.  If the master file is large, you might want to use the -b switch to force the server to commit after a know quantity of rows. (something like...

Give this a try:

Remove the first two \0

Change the third one to \n

I'm assuming that the text file doesn't actually contain string delimiters between the fields.  This should pick up...

If you're logging in with your Windows credentials, you need to leave off the -U and -P and add -T.  Give this a try:

 bcp "merch.roc\zyahya.tester" in "c:\temp\testdata" -f"c:\temp\testformat.fmt" -T -SSW520SQLDEV01

Could you show us the command you're using to invoke the bulk copy?  If you have rights to create tables in a database, you should be able to copy data...

Hmmm, getting around the semantics of 'business logic', 'application logic', and 'data validation', I'd like to propose that any logic, the avoidance of which may produce rows in the database which do...

It's been a long time since I've done this, but I seem to remember that the mainframe liked to have additional information about the imported files such as record length...