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

Just about perfect... I'll be back in a few...

Look at it this way... they're all flaming one thread and leaving the others alone

That's referred to as a "sequence table" and it one of the things that was suggested.  But, you must be VERY careful how you do the update to it or...

Can you get them to reverse the process?  Seems to me that the data table should be there completely befor the trigger table that says it is.