If you really want to impress them, create an "External Data Range" that queries the database using a well written view and set it up to automatically update every ten...

Heh... geek...

Heh... then there's that

And, just in case anyone is curious about how much the function will slow things down...

--===== Find a safe place to do this test using "real tables" because...

There IS a single magical update and you sure don't need a cursor

First... here's a little test data to play with as you...

Carsten,

Thanks for the detailed feedback.  Hard to believe that someone has that particular attitude.

Thanks for the confidence, Bledu... not sure it would do any good, though... if I were to give a general example, someone would fail to apply the knowledge to a...

So, Hickymanz... any feedback on the code I provided?

No... wasn't talking about external security... it's an internal security risk that would fail a PCI audit.

Heh... that'll teach me to read the question correctly   I labled the nodes 180 out

Generous but I'm curious... why would you pay someone $100 to write code and post it on a public/free forum?  Hate to look a gift horse in the mouth, but...

They also allow user name and password in clear text... a security risk, for sure.

Sorry... got carried away having fun

For the format similar to what you ultimately requested... feel free to tweek it... includes a column with...

Heh... see what happens when you provide just the right amount of data and a table definition to go along with a good description