This can be kind of common...

If you have a table 'person'

in which you store Father and Mother who points on an other row in the Table.

There is a lot of...

Search for t-sql Common Table Expression recursion

in google. All the info you need!

You can't set tooltips on parameters. The only way is to put the reminder in the prompt, like said Maceke.

I never tested or even tryed this, but check if you...