Upon reading the article a bit, I'd point out that you need to use an uppercase '-S' to identify the server name.

A good MS article.

https://blogs.msdn.microsoft.com/timart/2012/08/30/bulk-copy-use-bcp-from-sql-to-concat-databases/

I'm not sure about this particular command, but command options are usually case sensitive.
The output error seems to indicate the -t option should be lowercase.
You may want to...

I have read about that in the past, but didn't think about it.  Another good point.  I'm just going to split up the SPs based on function.  Thanks guys.

I think i understand.  The SP is for Inventory lot allocation. So, I should just create separate procedures. i.e. IM_Lot_Select, IM_Lot_Update, IM_Lot_Delete?

Can you provide a rough example or a link?  Also, why is it not good practice?

I made the change to db compat level and created the XML computed column.  Now the query takes 12 sec. to return 119 rows for a single CDA.  I'm at...

I changed the db compat level on our test server db to SQL 2012.  The try_convert function works on it now.  What things should i be concerned with when changing...

I get this error:

Msg 195, Level 15, State 10, Line 1
'try_convert' is not a recognized built-in function name.