I assume then that you are getting an error referring to the StartDate column so you assume that the existance check is not working and the INSERT statement is running...

Well, there are a few ways you can do this. Are you trying to do a one-time insert of data or are you trying to create a re-usable automated...

What you're asking for is a bit broad. It sounds like you need to develop a change management process to propogate your schema and static data changes to your...

I'm just heading out of the office, so I don't have time to write the script for you, but what you'll need to do is create a file system object...

I'm not quite sure I'm following you here. It would help if you would post some sample data and an example of the result set that you are after...

Makes sense, thanks Jeff.

Are you still looking for help on this?

I'll have to say that after reading through the post a couple of times, I'm still not quite sure what you are trying...

Yes, this is what I thought also, but the OP had not mentioned using SQL Server 2005...

Not trying to be obtuse, but can you expand on this a bit Jeff? What issues are there with BCPing directly into the final table? Also, what do...

Sincere contrats guys, way to go!!

Who has placed these conditions on your solution? The only way I can see...

I understand that you've only posted this becuase you've ran into a roadblock. All I'm saying is that in order to find the table, you have to be able...

Unfortunately, I do not have a documented resource. I learned this last week at TechEd during a session with Paul Randall and Kimberly Tripp. I don't recall how...

INSTR and MID are not T-SQL functions so that won't work. Search SSC for 'split function. You'll find several viable options.

It's folks like that that make way for us to make a living.

Long live the Stupid!!