More Fun with XML (and SQL Server 2005)
There is simply nothing more fulfilling and gratifying in the world of software development than solving a tough problem with an elegant, robust and scaleable solution.
Welllll…exxxxcept for googling your problem, standing on the shoulders of other programming geniuses, and using their elegant, robust, and scaleable solutions to solve your own tough problem. Programmers are inherently lazy and I’m no exception. So when I stumbled onto this little URL gem describing an elegant, scaleable, robust and plug-n-play-like method to providing a dynamic and variable number of parameters to a SQL stored procedure; I thought I’d share it with my fellow engineers.
Passing Lists to SQL Server 2005 with XML parameters.
[FYI; you must have Sql Server 2005 or greater].
