Just want to jump in here to say that it was your Bakers Dozen explanation of TVPs in Code Magazine that got me started using them. As I told you at the time it was so clearly explained I instantly could see their usefulness. Used them extensively at Dow Jones to handle some things that would otherwise have been terribly cumbersome.

Anyone who isn't familiar with or comfortable using Table Valued Parameters in SQL 2008 should jump on everything Kevin has written on this (and also look for posts by sqlDenis and possibly Naomi N. on lessthandot) Once you start using them you will think of many ways to refactor stuff you've done before.

Hi, Charles, thanks.

Yes, the new Table Table and TVPs are a great thing for a developer to add to the proverbial back of tricks.

As I mentioned in the text, what's great is that you can pass ADO.NET datatables as parameters to a proc.

There's only one thing that's a bit unfortunate. I'd love to use this in SSRS when a user selects multiple parameters - but SSRS sends up values for multi-valued parameters as a string, and there doesn't seem to be a way (at least none that I can see) to get SSRS to send up a data table instead. It's understandable they didn't do it in SSRS 2008, since TVPs were so new, but there have been 2 SSRS releases since then (2008R2 and 2012) and the logic hasn't changed. Maybe someday :)

But other than that, it's a great feature.