In Québec, we have to daily contend with two date formats mm-dd-yyyy (US English) and dd-mm-yyyy (French). I have repeatedly seen users confusing April 1 with January 4. So much...

Jeff:

Yet another sterling article!

I do not even need all the fingers on one hand to count the authors I have occasionally corresponded with.

You definitely stand out among the crowd.

And still...

Humm....

How do you "clean" a hex input ? convert it to string and also check the resulting string ?

Even trying to parse the incoming string for DELETE, DROP TABLE, etc. is doomed to fail.

A sneakier attack uses HEX, such as 0x77616974666f722064656c61792027303a303a323027

What does that unreadable string mean...

In India

[font="Courier New"]Lakh 10^5 (100,000)

Crore 10^7 (10,000,000)[/font]

Seems so natural to original poster, but not to the rest of the...

I was used to ssql2k when I did not need no smelly semi-colons.

Not clear yet as to why this was added to the language.

And yes, you are right about where...

Sean Lange:

Yes, both work. Since I inserted you cte solution after my own statements, I had to add a semi-colon before the "with GrandTotal as".

Thanks

Sean Lange:

Actually, the following SQL

[font="Courier New"]

SELECT #INV.InvNo, #INV.Currency, #INV.Amount AS GrandTotal, #PAY.Paid

FROM #INV LEFT OUTER JOIN #Pay ON #Pay.InvNo = #INV.InvNo

ORDER BY #INV.Currency, #INV.InvNo

[/font]

Produces the following results set: Note...

SQL_FS: And you are still a "Grasshopper" ?

Yes, it works, thanks for a speedy reply too.:-)

Thank you so much for your help Jeff.

And yes, I was already aware of the Tally table. I must be one of your greatest fans.

Regards

Thanks for your answers so far.

As regards my front end, I have to use the reporting facilities of CRM (2011). I doubt its front end reporting is capable of extracting...

Excellent !

First the new features of VALUES.

Then the very good link provided.

First class.

Keep 'em coming.

How do the newfangled Analytics functions compare with the Quirky Update method used for - among other things - creating running totals in term of performance ?

Why bother ?

The two WHERE clauses are NOT equivalent. No need for test data. You do not code based on known test data.

The only valid answer is that the two...

"it depends on the data" is true. but ...

The safe answer should be NO because it is obvious that the two WHERE clauses are not equivalent. An SQL statement should...