Hello Everybody,
Small Question about Temporary Tables:
I Know that Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name).
But i just dont understand when and where to use them ->local or global?

Thank you all in advance,
ERAN

PS,SHANA TOVA Everybody (Happy new year in hebrew)