Ah. So an implicit conversion before the function call. I haven't spotted that in the docs.

Thanks, though.

I've seen a couple responses referencing table variables as not being affected by begin/save/commit tran statements. Would it be a safer lesson to assert NO local variables are affected by...

I'm no finance guru, so could someone explain to me what real-world situations would require me to multiply/divide one currency value by another? Interest rates aren't currency... they're percentages. Also,...

Although I don't particularly care for SSIS nor the fact that the technique in this article had to use a script to do the job (I did my thing 100%...

If you're not concerned about portability (T-SQL doesn't require a FROM clause), you might get away with a single INSERT statement:

INSERT INTO Customer (

...

As a side bar... I'm truly disappointed in XML in general. I thought the whole purpose of transmitting tags was so that you'd automatically "know" what's in the file....

Mr. Moden,

Is there any chance you might publish a book?

Please?

--SJTerrill--

Wow... I don't see any way of answering any of these questions directly or satisfactorily. They all seem to fall under the global response, 'It depends.'

--SJTerrill--

Rocky,

Your syntax is not at issue. It's what you're trying to do with address data that may come from various and 'random' sources. There's no guarantee that Boulevard is spelled...

Hmm... In this 'simple' case you're trying to remove the 'what type of road' qualifier from the name of the address... correct? To Make sure you're not duplicating addresses.

If this...

Would it be possible for you to post some example DDL and sample data INSERTs? This will allow us to help you in the specific context of your situation.

--SJT--

Have you looked into the BULK INSERT statement... or the bcp command-line utility?

--SJT--

Many thanks should go to GSquared for taking the time to make that code sane... I just have to put in that I find the original code implementation breathtakingly bad....

I'm not one to argue with results! Theory is often best practiced in the classroom:-)

--SJT--

Well, my understanding of LIKE parses the entirety of a string, beginning to end, looking for a pattern match given or not given the wildcards... It's entirely possible that the...