Okay, so I'm kinda flying on my own getting some stored procedures written. I'm figuring going for the easy basic ones first and then adding the harder ones later and adding features as ...

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...

Yes a sproc can return multiple resultsets and you can even work with them in ADO, though it is somewhat esoteric.