I am helping someone else with this. If the next few things attempted don't fix it, I will gather the DDL and such and post it.

The getdate() is already being assigned to a variable, and used for the update. The update also should touch only 5 records (it is using a top 5). If the...

This is in preparation for an upgrade of the app, which will be replaced with reporting services. I am hoping that would not be too difficult, but I don't know...

Thanks Sergiy , that ended up being what I did, and it worked smoothly.

Thanks Bitbucket, I will have to give that a try in addition to the non-linear thinking way I am testing now.

(Which is, import all files with LF as the row...

Would these values be created out of a mainframe cobol program?

Thanks Paul, and yes I do.

Thankfully, after years of attempts, IT has ceased to be a wall. While they are still not ready to listen to me, they did hire...

It may be worth the effort to expand on this to look for other regular patterns. I would imagine eventually someone will figure out the sequential dialing is being detected,...

Ok, I have to...

What makes a good senior DBA.... it depends...

Thank you both! It is good to have confirmation that my gut reaction was on the right track. Not too bad for the accidental data warehouse designer/DBA/Developer where there are...

You do have the right idea. One to One for all but a single client, whom is one to many. While there is no guarantee this will be the...

I had this problem frequently, initially the IMEX setting on it's own worked fine. However, to work fine the excel sheet data has to have the mixed char/numeric data in...

Yeah, wouldn't it be nice if people followed some sort of actual logical rules on naming things, as well as the data entry people following those rules, rather than breaking...

Thank you Sergiy, I will have to try that. Every step closer to getting toward the answer for this is very welcome.

Rtrim does work in some cases, but not all. That is in some cases of the data, there should be a space added to the concatenation of the two fields,...