Is there a way to reference columns in @Tvp like this?
If @Tvp.UserID IS NOT NULL
I've read that you have to copy to a temp table, but I still couldn't reference any columns. I want to pass in some search values without making each one a parameter in the proc. Any help would be appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.