• Gotcha. Couple other notes. One is I hate to see code without error handling. Another is..I dont see where you are setting your connection to nothing, just closing it? Finally, why are you basically repeating your code in multiple lets? I'd rather see one 'GetHistory' method that calls a private routine.

    Interesting idea to encapsulate it. Looking forward to seeing your asp implementation.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/