You do know...

That doesn't make as much sense, I think. The DB2 database is already available on nearly every platform.

Really nice piece. I'll readily admit that I was thoroughly fooled right through the end. And that takes some doing. But I already knew that MySQL supports several different DB...

You have a few places in your query where you apparently need trimming on join fields:

UPPER(LTRIM(RTRIM(FIS2_Account_Shared.TD_LEGAL_ENTITY))) = UPPER(LTRIM(RTRIM(FIS2_Acct_Lgl_Ent.MNEMONIC)))

OR UPPER(LTRIM(RTRIM(FIS2_Account_Shared.TD_LEGAL_ENTITY))) = UPPER('TD SECURITIES CANADA')

In my limited experience this...

It's been alluded to in the other posts but the reason why it doesn't stop is because it's a non-SARGable query and you're also thinking in terms of rows (RBAR)...

The only thing I can think of that would cause this is if you have an unordered table, where n in one of the first rows is too big for...

But the try-catch approach is probably the better one. Something like this:

BEGIN TRY

INSERT INTO tblCustomer (cid, lName, fName)

...

Since the majority of the activity is inserts you may also want to investigate something like this:

INSERT INTO tblCustomer (cid, fName, lName)

SELECT @cid, @fName, @lName

WHERE NOT EXISTS (

SELECT *...

Hi,

Both of you seem to forget that this is the 2K5 group (SQL Server 2005), which means that fields of type DATE isn't supported (we have to use DATETIME fields)....

What you have is code that will add the necessary leading spaces up to 10. In effect it will leave you with a right-aligned 10 character field.

It is unnecessarily complicated,...

Nah, I don't find it all that comprehensive. Metric conversions seems to be missing. Only imperials there.

http://en.wikipedia.org/wiki/Conversion_of_units#Energy

Maybe he meant "most accurate"?;-)

Igor,

I really think you're overcomplicating it. From my point of view it is much simpler to add one month to the date and then subtract the day number, which brings...