An excellent article. Thanx 4 the bomb list. 😉

Just want someone to clear my concept regarding section: A Top 'n' products solution.

If v use this 1 to 1 relationship (e.g....

Another way to keep the function using * up-to-date is :

1. alter the table (which u r using in function)

2. sp_helptext 'MyFunctionName'

3. Copy the result

4. Replace "Create Function" with "Alter...