I could be wrong, but I'm pretty sure Jeff is asking those questions so that he can come up with a method to generate your report data as a single...

Naw, not going to continue down this path anymore. You have yet to admit you are wrong, you have yet to attempt to demonstrate that you aren't, you haven't acknowledged...

There is no universal answer to this, but basically data cleansing is getting the individual pieces of data to look the way you want, consistently. With that said, it typically...

Then did you enjoy the big (okay, not so big) party on 12/31/2000 with the other people who believe that IT reflects their world? Sorry, but I was partying like...

I haven't done it in a while, but doesn't putting a zero into the "column sort order" column in the format file skip over that field in the source file?

Lots of options. I'd personally look into bcp or DTS. DTS would probably be my first choice, since every time I do design an import method of some sort, we...

Page 6 of this thread. It's not my test, but Sergiy's (He formulated it, I coded it). He has just distanced himself from it since then, since it demonstrated how...

I did answer the questions you posed, which is something you seem to avoid in return. I'll happily answer your new question, even though I'm only guessing at what you're...

If you replace your "SELECT INTO" that included an identity function into a "CREATE TABLE" with the identity column, and then did an "INSERT/SELECT... ORDER BY", the identity column will be...

While I wouldn't find it a necessarily aesthetically pleasing solution, what about splitting the delimited list, placing it into a table variable, and returning the max() (or min to emulate...

Do you only want to replace "F" with "?" when it is in the 15th position, or the 15th character no matter what it is? When you said "replacing a certain...

This is one of those "It depends" questions that are common in the SQL Server world. If the vendor does everything through stored procedures, for instance, then you can just...

That's my understanding, in that it just looks for blacklisted words, period. You can try it as a test to make sure, if you'd like, one pass with "password", the other...

The easiest way is to refactor the code, using something other than "password", such as "passcode".

The harder, more unsecure, virus scanner unfriendly, not necessarily service pack friendly, and fully unsupported...

I would name a "midnight event" "midnight". Seems like a surplus of words to do otherwise. As for what happens at 00:00, since I work in the IT world, it...