Also watch out for the *= shorthand for LEFT OUTER JOIN. That has also been depricated.

I have been trying this myself. Some research has revealed that it isn't possible. Seems that all types are database specific and cannot cross lines between them even...

I have been trying this myself. Some research has revealed that it isn't possible. Seems that all types are database specific and cannot cross lines between them even...

A little more research indicates that all types are DB specific and cannot cross DB boundaries.

This article gives some helpful alternatives: http://www.sommarskog.se/share_data.html#prockeyed

Thanks for the help. Based on your input and the need for user interaction at the beginning I came up with this:

Created a table type for the parameters:

CREATE...

Sorry, miscommunicated what the parameters are for. We receive a file from our client and use SSIS to pull it into an intermediate table to process. The file...

I would do it like this:

@Collist = COALESCE( @Col1 + ',' + @Col2, @Col2, @Col1)

This will set @Collist to the first one of these that comes back without a NULL...

Yeah, I may hove to create a function or something to do the insert for the TVP. I think the person who runs this does a simple EXEC commanad...

Sounds good. Just wanted to be sure.

Thanks!