Still Not Clear

hi thank you for this solution Hugo (dutch?) and it's very handy, thank
you but my issue is that we created dozens of views with my function.
This functions returns an integer of a date. This function has to give a
lowerlimit and higherlimit back when dates are out of Calendar range.

But i want to read this from the Calendartable ONCE and store it in a
global variable somewhere in SQL Server. I DON'T want to reference
tables in my function. SO read once the lower- and upperlimit and use
this variable/property for referencing in my function!!


Greetz
Hennie

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!